Mysql 删除相同数据

发表于 2016-07-31 | 分类于 mysql | | 阅读次数

根据两个字段进行相同数据删除

1 2	delete from video where id not in ( select * from(select id from video group by name,link)b);