联合更新1
update user1 inner join (select user2.usename from user2 join use1 on user1.usename =user2.usename)user2 on user1.usename=user2.usename set user1.over='齐天大圣';语句中括号里的查询是否多此一举?
update user1 inner join (select user2.usename from user2 join use1 on user1.usename =user2.usename)user2 on user1.usename=user2.usename set user1.over='齐天大圣';语句中括号里的查询是否多此一举?
2018-06-25
举报