两种方法,1:
找出某一记录相同的数目 N 个
然后用 DELETE ..... WHERE .... LIMIT N-1;
2:
用临时表CREATE TEMPORARY TABLE temptable SELECT * FROM tA GROUP BY Col1,Col2;DELETE FROM tA;INSERT INTO tA SELECT * FROM temptable;
找出某一记录相同的数目 N 个
然后用 DELETE ..... WHERE .... LIMIT N-1;
2:
用临时表CREATE TEMPORARY TABLE temptable SELECT * FROM tA GROUP BY Col1,Col2;DELETE FROM tA;INSERT INTO tA SELECT * FROM temptable;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货