Friday, May 23, 2008

How do I import delimited data into MySQL?

How do I import delimited data into MySQL?

mysql> load data local infile "xxxrs.txt" into table data_table; this work successfully make sure that rs.txt is located at 'MySQL Sverver 6.0\bin'


LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);


http://www.svdeals.com/

1 comment:

Unknown said...

Do you still use free service like blogspot.com or wordpress.com but
they have less control and less features.
shift to next generation blog service which provide free websites for your blog at free of cost.
get fully controllable (yourname.com)and more features like forums,wiki,CMS and email services for your blog and many more free services.