How to export a MySQL query as CSV
This guide will show you how to export your MySQL query as a CSV file, a common need when analyzing records or data.
This guide will show you how to export your MySQL query as a CSV file, a common need when analyzing records or data.
For instance, if you're trying to get all of the users from the 'users' table:
SELECT * FROM users
Append this onto the end of the query to output the results to a file /tmp/users.csv
INTO OUTFILE '/tmp/users.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
SELECT *
FROM users
INTO OUTFILE '/tmp/user.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
If you found this guide useful, check out our guide on how to query by timestamp in MySQL.
The Picade from Pimoroni brings new meaning to tabletop gaming. This tiny box is built for DIY gamers with a touch of class.