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
舉報(bào)
2019-01-22
這個代碼老師講的說不行呀,然后換一個操作