MySQL and SQL Server
SQL Server and MySQL DBA.
Wednesday, 22 January 2014
Export MySQL query results in csv format
select *
from table
where .....
INTO OUTFILE '/tmp/output.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)