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;
- Feb 10 Fri 2012 16:42
-
MSSQL MYSQL UPDATE from
請先 登入 以發表留言。