mysql 删除重复数据

来源:互联网 发布:mysql官方 编辑:程序博客网 时间:2024/05/02 00:56
create table tmp as select min(id) as col1 from content group by content;delete from content where id not in (select col1 from tmp);drop table tmp;

0 0
原创粉丝点击