http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html

mysql import

you can import csv data into mysql by running the mysqlimport command

mysqlimport

$ mysqlimport -h host -u user -p \
--ignore-lines=1 --fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\' \
dbname --local tblname.csv


see also

MySqlExport

REFERRERS
MySqlAdministration
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki