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;
創作者介紹

推理文by阿誠

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