MySQL: How to export query results to a CSV file

You can use the following query, making sure you have write permission over the destination path.

SELECT field1, field2
FROM table_name INTO OUTFILE '/destination_path/result.csv' 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Including headers:

(SELECT 'label_field1','label_field2')
UNION 
(SELECT field1, field2
FROM table_name
INTO OUTFILE '/destination_path/result.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n');

Empower your Gmail with Mailtrack

What is Mailtrack?

Mailtrack is a Chrome extension for Gmail, which allows you to know when the messages you send have been read.
Basically it brings the double-checks (✓✓) we usually see in mobile messaging to your Gmail inbox and it is free for unlimited time!

Main Features:
- See which messages have been read, how long ago, how many times and which device they were opened on.
- Real-Time desktop notifications
- The only email tracking app with double-checks for Gmail.

Who is it for?
- Account managers, businesses, sales teams and people with direct client relationships
- Professionals looking to increase their productivity
- Teams, project managers, coordinators and internal communications
- Independent people (individuals, freelancers) and people actively looking for employment

GET THE ✔✔ IN YOUR GMAIL