mysql删除重复数据只保留一条;
关键代码(标红):同oracle中不同
- DELETE book from book ,
- (
- SELECT id FROM (
- SELECT id FROM book WHERE name IN(SELECT name FROM book GROUP BY name HAVING count(name) > 1)
- ) t
- WHERE id NOT IN (SELECT id FROM book GROUP BY name HAVING count(name) > 1)
- ) as a
- WHERE book.id = a.id;
转载至:http://injavawetrust.iteye.com/blog/2294754