如果记录总数>15万delete from yourtable where id>xxx;[align=center]====思想重于技巧==== [/align]
如果记录总数<15万insert into newTble select * from yourtable where id<xxxx; TRUNCATE yourtable ; ALTER TABLE newTble RENAME TO yourtable; [align=center]====思想重于技巧==== [/align]
[/align]
TRUNCATE yourtable ;
ALTER TABLE newTble RENAME TO yourtable;
[align=center]==== 思想重于技巧 ====
[/align]
delete from 你的表名 order by 自增ID desc limit 100000;