详细说明 导出全部数据 是pv_temp? select a.num, b.num, pv_temp.pv from pv_temp left join a on a.user_id = pv_temp.user_id left join b on b.book_id = pv_temp.book_id into outfile 'd:/tsd.txt' fields terminated by '\t';
是1000整行? 做个其它试验,你直接 select pv from pv_temp into outfile 'd:/xx.txt'; 看看出来多少记录。 如果仍是1000,则估计是哪儿有什么限制。
select a.num, b.num, pv_temp.pv from pv_temp left join a
on a.user_id = pv_temp.user_id
left join b on b.book_id = pv_temp.book_id
into outfile 'd:/tsd.txt' fields terminated by '\t';
做个其它试验,你直接 select pv from pv_temp into outfile 'd:/xx.txt'; 看看出来多少记录。 如果仍是1000,则估计是哪儿有什么限制。
你手工加上个limit 100000000000就可以了。