Sunday, April 17, 2005

LOAD DATA INFILE example - importing data from csv into mysql

LOAD DATA INFILE "/home/mysql/data/my_table.csv" INTO TABLE my_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

1 comments:

corporate webhosting said...

corporate webhosting

Can I Help You.. Yes If you want to get on the web. If you want to start learning about creating a web site of your own.. go to http://webhost11.com. to find out more about corporate webhosting ... We can help find a web host for you.