What's the best way to dump a MYSQL table to CSV? [duplicate]

This question already has answers here: Closed 12 years ago.

Possible Duplicate:

Dump a mysql database to a plaintext (CSV) backup from the command l开发者_高级运维ine.

I prefer python, but if mysqldump works...then how can I do that?

---

SELECT ... INTO OUTFILE ...