mysql outfile追加 |mysql 导出access格式化

SELECT column1,column2,column3 INTO OUTFILE 'filename.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name
WHERE condition
ORDER BY column1 DESC
LIMIT 100

在上面的SQL语句中，大家可以直接在OUTFILE后面指定文件名，并且增加“APPEND”参数就可以实现追加的功能。

SELECT column1,column2,column3 INTO OUTFILE 'filename.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name
WHERE condition
ORDER BY column1 DESC
LIMIT 100
APPEND

需要注意的是，使用追加功能的时候，有可能会出现权限问题，需要确认该用户对指定目录是否有写入权限。