For example, type "mysql -u root -p" (without the quote marks) and enter your password when prompted. Create a MySQL SELECT query to select the data you want to output to CSV.

When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert tab characters into the output data stream ...