mysql重復(fù)數(shù)據(jù)去重 Mysql如何去掉數(shù)據(jù)庫中的重復(fù)記錄？
Mysql如何去掉數(shù)據(jù)庫中的重復(fù)記錄？很簡單 通過id刪除DELETE FROMtable_name AS ta WHEREta.唯一鍵 <> (SELECTt.maxid FROM( SEL
Mysql如何去掉數(shù)據(jù)庫中的重復(fù)記錄？
很簡單 通過id刪除
DELETE
FROM
table_name AS ta
WHERE
ta.唯一鍵 <> (
SELECT
t.maxid
FROM
( SELECT max( tb.唯一鍵 ) AS maxid FROM table_name AS tb WHERE ta.判斷重復(fù)的列 = tb.判斷重復(fù)的列 ) t
)