专题文章
时长:00:00更新时间:2020-11-09 18:52:10
MYSQL删除重复数据的简单方法_MySQL:bitsCN.com CREATETABLE`users`(`id`int(10)NOTNULLAUTO_INCREMENT,`name`char(50)NOTNULL,PRIMARYKEY(`id`))deletefromuserswhereidin(selectmin(id)fromusersgroupbynamehavingcount(name)>1);结果报错:1093youcan'tspecifytargettable....原因是mysql删除动作不能带有本表的查
查看详情