no comments yet
10
Apr
2018
MySQL删除重复记录只保留一条
DELETE FROM small_pic WHERE num IN (
SELECT num
FROM (
SELECT num
FROM small_pic
GROUP BY num
HAVING COUNT( * ) >1
)t
)
DELETE FROM small_pic WHERE num IN (
SELECT num
FROM (
SELECT num
FROM small_pic
GROUP BY num
HAVING COUNT( * ) >1
)t
)