SELECT * FROM 库名.表名 INTO OUTFILE ‘/tmp/record.txt’ CHARACTER SET gbk FIELDS TERMINATED BY ‘\、’ OPTIONALLY ENCLOSED BY ‘"’ LINES STARTING BY ‘>’ TERMINATED BY ‘\r\n’;
mysql select into outfile 导出查询数据
最新推荐文章于 2023-05-24 09:47:31 发布
SELECT * FROM 库名.表名 INTO OUTFILE ‘/tmp/record.txt’ CHARACTER SET gbk FIELDS TERMINATED BY ‘\、’ OPTIONALLY ENCLOSED BY ‘"’ LINES STARTING BY ‘>’ TERMINATED BY ‘\r\n’;