mysql 格式输出

SELECT * FROM employees;

SELECT JSON_OBJECT('id', id, 'name', name, 'salary', salary) AS employee FROM employees;

SELECT * FROM employees INTO OUTFILE '/tmp/employees.csv'
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
';

SELECT * FROM employees FOR XML PATH('employee');

SELECT JSON_OBJECT('id', CAST(id AS CHAR), 'name', REPLACE(name, '"', '\"'), 'salary', salary) AS employee FROM employees;

SELECT * FROM employees INTO OUTFILE '/tmp/employees.csv'
CHARACTER SET utf8mb4
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
';