Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏

23.3. DELETE 删除

23.3.1. 删除重复数据

			
delete from member group by username having count(username) > 1			
			
			

23.3.2. 删除重复数据保留第一条

			
delete from testing.account where id not in (select tmp.id from(select min(id) as id from testing.account group by wechat) tmp);