What program to use to convert sql to csv?

Question

SQL

I have a large database and to make it easier to work with it, I need a utility that converts from sql to csv on a PC. Google didn't find anything similar.

Answer 1

mysql -B -uroot -p1111 -e 'SELECT * FROM books' test, where the -B switch specifies the form of the output.