dept表和locations表的结构如下: dept表: Name Null? Type dept_id decimal(4) dept_name not null varchar(30) manager_id decimal(6) location_id decimal(4) city varchar(30) locations表: Name Null? Type location_id not null decimal(4) address varchar(20) postal_code varchar(12) city not null decimal(4) state varchar(25) country_id char(2) 将dept表中每行的city的值修改为locations表中相应的city的值,正确的语句为:
A.
update dept set city=any(select city from locations)
B.
update dept set city=(select city from locations) where dept.location_id=locations.location_id
C.
update dept set city=(select city from locations where dept.location_id=locations.location_id)
D.
update dept set city=all(select city from locations) where dept.location_id=locations.location_id