在删除之前首先做好备份!!!
删除重复数据
DELETE
FROM table_name a
WHERE a.rowid != (
SELECT max(b.rowid)
FROM table_name b
WHERE b.id = a.id)
//根据rowid删除重复数据中较小的rowid
在删除之前首先做好备份!!!
删除重复数据
DELETE
FROM table_name a
WHERE a.rowid != (
SELECT max(b.rowid)
FROM table_name b
WHERE b.id = a.id)
//根据rowid删除重复数据中较小的rowid