數(shù)據(jù)庫查詢?nèi)绾稳ブ?Mysql如何去掉數(shù)據(jù)庫中的重復記錄？
Mysql如何去掉數(shù)據(jù)庫中的重復記錄？很簡單 通過id刪除DELETE FROMtable_name AS ta WHEREta.唯一鍵 <> (SELECTt.maxid FROM( SEL
Mysql如何去掉數(shù)據(jù)庫中的重復記錄？
很簡單 通過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.判斷重復的列 = tb.判斷重復的列 ) t
)