to jiezhi(西域浪子): 没有设主键啊 如果设了主键不就不会有重复的记录了吗? to offsider(烤鸡翅膀,我最爱吃) 你的方法不对啊,没有把重复的删掉啊!
是啊 主键是能唯一标示一条数据的项DELETE FROM our_table WHERE rowid not in (SELECT MIN(rowid) FROM our_table GROUP BY column1, column2, column3...
是啊 主键是能唯一标示一条数据的项DELETE FROM our_table WHERE rowid not in (SELECT MIN(rowid) FROM our_table GROUP BY column1, column2, column3...
这样吧:CREATE TABLE TAB_TMP AS SELECT column1, column2, column3... FROM YOUR_TAB GROUP BY column1, column2, column3...;DROP TABLE YOUR_TAB ;RENAME TAB_TMP TO YOUR_TAB;
没有设主键啊
如果设了主键不就不会有重复的记录了吗?
to offsider(烤鸡翅膀,我最爱吃)
你的方法不对啊,没有把重复的删掉啊!
主键是能唯一标示一条数据的项DELETE FROM our_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3...
主键是能唯一标示一条数据的项DELETE FROM our_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3...
SELECT column1, column2, column3...
FROM YOUR_TAB
GROUP BY column1, column2, column3...;DROP TABLE YOUR_TAB ;RENAME TAB_TMP TO YOUR_TAB;