mysql update(delete) inner join

曹振华

已于 2022-10-18 16:09:20 修改

阅读量866

点赞数

分类专栏： mysql sql server 文章标签： mysql sql inner join update

于 2022-08-10 16:02:25 首次发布

本文链接：https://blog.csdn.net/chadcao/article/details/126268479

版权

sql server 同时被 2 个专栏收录

77 篇文章 0 订阅

订阅专栏

mysql

13 篇文章 0 订阅

订阅专栏

update

select u.OALoginName,h.OALoginName from MDM_User u
inner join OALoginName_20220810 h on u.Email=h.email
where u.OALoginName<>h.OALoginName

#mysql
update MDM_User u
inner join OALoginName_20220810 h on u.Email=h.email
set u.OALoginName=h.OALoginName
where u.OALoginName<>h.OALoginName

#sqlserver
update u set u.OALoginName=h.OALoginName from MDM_User u
inner join OALoginName_20220810 h on u.Email=h.email
where u.OALoginName<>h.OALoginName

delete

select * from MDMR_DimensionDept dd
inner join MDM_Dept d on dd.DeptId=d.DeptId
where dd.DimensionManageId='A88427B0-5207-4F70-A310-55D2EDB60747' 
and d.DeptId='4F4E2BE3-F42A-4B34-97A4-4E7511AB6087'


#sqlserver、mysql
delete dd from MDMR_DimensionDept dd
inner join MDM_Dept d on dd.DeptId=d.DeptId
where dd.DimensionManageId='A88427B0-5207-4F70-A310-55D2EDB60747' 
and d.DeptId='0574C19B-DAFC-46C4-874F-29B368AACFF4'