删除SQL某个表中重复的记录
来源：动视网
责编：小采
时间：2020-11-09 09:17:21
删除SQL某个表中重复的记录
删除SQL某个表中重复的记录:假如表为Mytable SELECT distinct * FROM into 临时表 from MyTable DELETE from MyTable insert into MyTable SELECT * FROM 临时表 drop table 临时表
导读删除SQL某个表中重复的记录:假如表为Mytable SELECT distinct * FROM into 临时表 from MyTable DELETE from MyTable insert into MyTable SELECT * FROM 临时表 drop table 临时表
假如表为Mytable
SELECT distinct * FROM into 临时表 from MyTable
DELETE from MyTable insert into MyTable
SELECT * FROM 临时表
drop table 临时表
删除SQL某个表中重复的记录
删除SQL某个表中重复的记录:假如表为Mytable SELECT distinct * FROM into 临时表 from MyTable DELETE from MyTable insert into MyTable SELECT * FROM 临时表 drop table 临时表
