SQL_去重,插入不同数据
程序员文章站
2023-11-23 15:20:46
sql_去重,插入不同数据
删除重复数据
delete from t_common_079_show_screen t where t....
sql_去重,插入不同数据
删除重复数据
delete from t_common_079_show_screen t where t.rowid in(select max(rowid) from t_common_079_show_screen group by screen_id having count(screen_id)>1);
插入不同数据
insert into "t_common_006_main_attach_copy" select distinct t.* from t_common_006_main_attach t;
下一篇: 微信小程序开发经验总结(推荐)