MySQL筛选出的结果怎么导出

Question

我的数据很大，筛选后还有十多万条数据，我想先把筛选好的数据保存成一个表，怎么办到呢？我试了导出，只能选这一页的1000条，这远远不够，选全部数据导出的却是筛选之前的整个表的数据。

Answer 1

只能这一页，是被limit限制了

试试使用 -- INTO OUTFILE

SELECT * FROM myTable Where XX=XX and YY=YY INTO OUTFILE '/tmp/myTest.txt';

或者：//CSV

SELECT * FROM myTable INTO OUTFILE '/tmp/myTest.txt'
    -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    -> LINES TERMINATED BY '\r\n';

也或者：
把表复制一份，去掉冗余内容再全表导出

CREATE TABLE tableNew SELECT * FROM tableOld;
DELETE FROM tableNew Where XX=XX...