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;
文章標籤
全站熱搜
- 2月 10 週五 201216:42
MSSQL MYSQL UPDATE from
創作 (2)