Solved code to export mysql tables content to .text or .csv files

Hello guys !

Have you simple code to export mysql tables content to .text or .csv files ?
(FreeBSD environment, obviously).

Thanks in advance.

Bye bye.
 
The mysql command itself can do that; see mysql(1). So; just use your select command on the command line, tell it not to use headers and redirect the output. Done.

Another, maybe easier, option is mysqldump. See mysqldump(1), it can export to csv on its own.
 
Back
Top