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;

abort 發表在 痞客邦 PIXNET 留言(0) 人氣()