删除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 临时表
声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
删除SQL某个表中重复的记录
删除SQL某个表中重复的记录:假如表为Mytable SELECT distinct * FROM into 临时表 from MyTable DELETE from MyTable insert into MyTable SELECT * FROM 临时表 drop table 临时表
