2014年2月8日 星期六

Dump database to csv format

SELECT *FROM the_tableINTO OUTFILE '/tmp/the_table.csv'FIELDS TERMINATED BY ','ENCLOSED BY '"'LINES TERMINATED BY '\n';




References:
Save MySQL query results into a text or CSV file | a Tech-Recipes Tutorial

沒有留言:

張貼留言