MySQL :: UPDATE using SELECT

MySQL :: UPDATE using SELECT

瀏覽:1162
日期:2025-04-23
Coming from an Oracle background I am used to doing this: UPDATE accomodation a SET a.country = (SELECT c.country FROM country c WHERE c.country_id = a.country_id); I could not ge thtis to work so looked up the syntax for this: update accomodation a...看更多