// MySQL allows you easy export data into CSV file. It provides a mechanism for writing the results of a select statement into a text file on the server, so it is possible to create a comma separated value (CSV) which can be imported into a spreadsheet application such as OpenOffice or Excel or any other application which accepts data in CSV format. 

SELECT order_id,product_name,qty FROM orders
INTO OUTFILE '/tmp/customers.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'