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