分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
做个笔记
DELETE FROM tablename where id not in (select id from (select min(id) as id from tablename group by key) as b ) ;
- 1
其中key是重复的字段
分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
做个笔记
DELETE FROM tablename where id not in (select id from (select min(id) as id from tablename group by key) as b ) ;
其中key是重复的字段