imfx

摘要： 表结构及数据 删除name列重复的数据但是要保留一条 sql: DELETE FROM my_test WHERE id NOT IN (SELECT * FROM (SELECT max(r.id) FROM my_test AS r GROUP BY r. NAME) t); 注意:里面的子查询 阅读全文