Dumping a table in csv

[Anon]

I have a table user and I want to export it as a comma seperated values is there a way to do this

Thanx

[[deleted]]

here's the code:

SELECT * INTO OUTFILE '/path/to/file.txt/'
FIELDS
TERMINATED BY = ','
FROM tablename
(you can add a where clause here if you want);