MySQL
UPDATE accomodation a, country c
SET a.country = c.country
WHERE a.country_id = c.country_id;
MSSQL
UPDATE accomodation a
set a.country = c.country
FROM country c
where a.country_id = c.country_id;
UPDATE accomodation a, country c
SET a.country = c.country
WHERE a.country_id = c.country_id;
MSSQL
UPDATE accomodation a
set a.country = c.country
FROM country c
where a.country_id = c.country_id;
全站熱搜
留言列表
創作 (2)
