mysql> select * from test1;
+------+------+
| id | c_id |
+------+------+
| 1 | 0013 |
| 2 | 0014 |
| 3 | 0013 |
| 4 | 0013 |
+------+------+
4 rows in set (0.06 sec)
mysql> delete t from test1 t left join
-> (select c_id,min(id) as min_id from test1 group by c_id) t1
-> on t.id=t1.min_id
-> where t1.min_id is null;
Query OK, 2 rows affected (0.06 sec)
mysql> select * from test1;
+------+------+
| id | c_id |
+------+------+
| 1 | 0013 |
| 2 | 0014 |
+------+------+
2 rows in set (0.00 sec)
mysql>
MYSQL删除一个字段相同记录,保留ID最小记录
最新推荐文章于 2024-07-11 10:27:20 发布