查出重复数据放入tmp零时表中:
create table tmp as select min(id) as id from restaurant_info group by restaurant_name having count(restaurant_name) > 1;
根据零食表中id删除表中重复数据:
delete from restaurant_info where id in(select id from tmp );
删除零食表:
drop table tmp;
完毕。
本文共 306 字,大约阅读时间需要 1 分钟。
查出重复数据放入tmp零时表中:
create table tmp as select min(id) as id from restaurant_info group by restaurant_name having count(restaurant_name) > 1;
根据零食表中id删除表中重复数据:
delete from restaurant_info where id in(select id from tmp );
删除零食表:
drop table tmp;
完毕。
转载于:https://www.cnblogs.com/havenshen/p/3584946.html