mysql> SELECT * FROM my_table -> INTO OUTFILE '/tmp/output.csv' -> FIELDS TERMINATED BY ',' -> ENCLOSED BY '"' -> LINES TERMINATED BY '\n';Query OK, 4 rows affected (0.04 sec)
/var/lib/mysql/tmp