Mysql无主键删除重复数据的快速方法

create procedure p()
begin
    create table casbin_rule_copy2 select distinct * from casbin_rule; 
    drop table casbin_rule;
    alter table casbin_rule_copy2 rename to casbin_rule;
end


call p();