How to Write a Data Table ... 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.