update apples
set price = (
select price from (
select * from apples
) as x
where variety = 'gala')
where variety = 'fuji';
转载于:https://www.cnblogs.com/yins/p/10895291.html
update apples
set price = (
select price from (
select * from apples
) as x
where variety = 'gala')
where variety = 'fuji';
转载于:https://www.cnblogs.com/yins/p/10895291.html