UPDATE
tab1 a INNER JOIN tab_game_version as b ON a.id=b.id
SET a.advert_data=0
where a.advert_data is NULL
sql server
update tab set f = 1 from xxxxxxxxx
xxxxxxxxxx
where
UPDATE
tab1 a INNER JOIN tab_game_version as b ON a.id=b.id
SET a.advert_data=0
where a.advert_data is NULL
sql server
update tab set f = 1 from xxxxxxxxx
xxxxxxxxxx
where
转载于:https://www.cnblogs.com/kunlunmountain/p/10001144.html