How can I export data in csv?

[pqiaohaoq]

Example

execute SQL:

SELECT * FROM t_table LIMIT 3;

It will show:

id	name
1	a
2	b
3	c

Now, I want to export these columns into ~/Downloads/export.csv.

How can I do it?

INTO OUTFILE is not working, because it just work in mysql-server.

[meeuw]

Try this:
\T csv ; \o ~/Downloads/export.csv ; SELECT * FROM t_table LIMIT 3

[pqiaohaoq]

Thanks, it helps me a lot.

[necesitod]

just great