mysql - 如何删除重复记录但 Int 除外？

Question

在我的 MySQL 表记录下，我有这些:

SELECT * FROM dbo.online;
+-------+
| Id    |
+-------+
| 10128 |
| 10240 |
|  6576 |
|    32 |
| 10240 |
| 10128 |
| 10128 |
| 12352 |
+-------+
8 rows in set (0.00 sec)

如何做到:

 SELECT * FROM dbo.online;
+-------+
| Id    |
+-------+
| 10128 |
| 10240 |
|  6576 |
|    32 |
| 12352 |
+-------+
8 rows in set (0.00 sec)

换句话说，我想做的是，使用 DELETE 命令而不是 SELECT * FROM dbo.online GROUP BY id..那么，知道怎么做吗？

Answer 1

用distinct复制数据到备份表，steop消除重复

create table backUp_online as
SELECT distinct * 
FROM online;

清除源表

truncate table online

不重复地从备份中复制数据到源表

   insert into online
   select *
   from backUp_online