Ad

What's The Easiest Way To Import A New Table Into MySQL V5 From CSV?

- 1 answer

I'm running MySQL 5 on a linux server on my local network. Running windows XP for my desktop. Had a look at the MySQL GUI Tools but I dont think they help. I cannot install apache on the remote server & use something like PHPmyAdmin.

Ad

Answer

I use SQLyog on my Windows system which has a free Community Edition and has an option to import from CSV.

I've never used this option myself so I can't tell you how good it is. However, SQLyog has been great for all the other things I've used it for.

Ad
source: stackoverflow.com
Ad