Sometimes we need to format our sql file to csv format, we usually dump mysql table to a file and then later on we need toview this file or check on the data but the problem is you still need to format it so that you can easily read it. So here is a small trick to directly conver your mysql dump file to csv.

mysql -uroot -p -e"select * from your_table" your_database > your_table.csv

That’s all folks… hope this trick helps you… drop a comment if it did.