<sql> into outfile 'xxx.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
<sql> 表示正常的查询语句。导出的txt文件在mysql安装目录的data/<database>中。
<sql> into outfile 'xxx.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
<sql> 表示正常的查询语句。导出的txt文件在mysql安装目录的data/<database>中。
转载于:https://www.cnblogs.com/zongyl/p/10433131.html