mysql中,第二天语句有些问题,并且语法有些难以理解
update user1 a join(
select b.user_name
from user1 a inner join user2 b on
a.user_name=b.user_name
)b on a.user_name=b.user_name
set a.[over]='齐天大圣'
update user1 a join(
select b.user_name
from user1 a inner join user2 b on
a.user_name=b.user_name
)b on a.user_name=b.user_name
set a.[over]='齐天大圣'
2019-01-22
举报