Search This Blog

MySQL: export data to csv file

SELECT employee.id, employee.name, employee.salary 
INTO OUTFILE '/tmp/employee.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM employee;

No comments:

Post a Comment