First, you need and install MyToTxt.
MyToTxt is a tool to export Mysql query results to CSV file.
Using MyToTxt you can export Mysql query results to CSV file easily and fast.
Export Mysql Query Results To CSV File – 2 steps
1. Click “Export From Query” button.
2. Config and export.
More about MyToTxt – the tool to export MySQL query results to file