Just an example of using INTO OUTFILE for dumping sql data directly to a CSV file including column labels as the first row. Because I tend to forget these things over time, I’m posting this for future reference.

SELECT 'Firstname', 'Lastname', 'Email', 'Company', 'Title',
'Address1', 'Address2', 'City', 'State', 'Zip', 'Phone1'
UNION
SELECT users.firstname, users.lastname, users.email, users.company, users.title,
users.address1, users.address2, users.city, users.state, users.zip, users.phone1
INTO OUTFILE '/tmp/dump_users.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY ''
LINES TERMINATED BY '\r\n'
FROM users;

This entry was posted on Tuesday, October 21st, 2008 at 9:49 am and is filed under Code. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.