Revision [1733]
Last edited on 2008-05-26 23:03:29 by WikiAdminAdditions:
select * from table_name into outfile 'table_name.csv' fields terminated by ',' enclosed by '"';
Deletions:
Revision [1732]
Edited on 2008-05-26 22:56:58 by WikiAdminAdditions:
Use mysqlimport. Note that table name is read by removing the .txt extension from the import text file.
mysqlimport --fields-terminated-by=',' --fields-enclosed-by='"' db_name table_name.txt
mysqlimport --fields-terminated-by=',' --fields-enclosed-by='"' db_name table_name.txt
