Export MySQL to CSV using UNIX

Is it possible to Export a My开发者_JAVA技巧SQL to a CSV using the command line in UNIX?

---

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

---

If you have Ruby, you can use the mysql2xxxx gem

gem install mysql2xxxx
mysql2csv --username=root --password=password --execute "select * from mytable" > mytable.csv

It's not as fast as mysqldump, but you don't need to be on the same computer as the MySQL server. It also provides mysql2xml and mysql2json.