Converting sql file to csv

[veledrom]

Hi,

I have mysql database dump xxx.sql
How can i convert xxx.sql to xxx.csv?

Thanks

[mwasif]

Import .sql to MySQL and then export it via any GUI tool or export as CSV with a simple PHP script.

I don't know any tool which can directly convert .sql to .csv.

[veledrom]

Yes you are right.

[thebsv]

run this query:
SELECT *
FROM TABLE_NAME
INTO OUTFILE '/tmp/xyz.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'