mysql
文章平均质量分 66
铁扇爱吃牛肉面
我说空间要大,其实是想亲人都能住在一起;我说宠物要多,其实是想包容每个人的爱好。
展开
-
mysql查重、去重、更改状态
1.查重:select * from file awhere (a.name) in (select name from file WHERE isDelete = 0 and status = 1 GROUP BY phone HAVING count(*)>1);2.删除DELETE a FROM file a, file bWHERE a.id < b.id AND a.name = b.name ;3.修改重复状态update file set status =0 wher原创 2020-12-11 13:52:52 · 219 阅读 · 0 评论 -
MYSQL如何通过一张表更新另外一张表?
UPDATE feifei.student s, feifei.temp tSET s.name = t.name,s.sex = t.sex,s.age = t.ageWHERE s.student_id = t.student_id;或者可以这样UPDATE feifei.student sINNER JOIN feifei.temp t ON t.student_id=s.student_idSET s.name=t.name,s.age=t.age,s.sex=t.sex;.原创 2020-08-19 09:05:22 · 187 阅读 · 0 评论