请查看链接 您只需将以下内容添加到查询中即可select * from table INTO OUTFILE '/tmp/myfilename.txt' 你可以将这个改进为csv文件(稍后在Excel中使用)。 例如:INTO OUTFILE '/tmp/myfilename.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'