If you want to send some mysql query result to an csv file, you can use a query sentece like this:

via How to send mysql query result to CSV file — NotesTI