对 SQLite 表进行重复数据删除

DELETE FROM table_name WHERE rowid NOT IN (SELECT MIN(rowid) FROM table_name GROUP BY column1, column2, ...);

CREATE TABLE new_table_name AS SELECT DISTINCT * FROM table_name;

ATTACH DATABASE ':memory:' AS temp;
CREATE TABLE temp.new_table_name AS SELECT DISTINCT * FROM table_name;
DETACH DATABASE temp;

CREATE TEMPORARY TABLE temp_table AS SELECT DISTINCT * FROM table_name;
DROP TABLE table_name;
ALTER TABLE temp_table RENAME TO table_name;
CREATE UNIQUE INDEX index_name ON table_name (column1, column2, ...);