您的位置: 首页 > IT文章 > mysql 同表查询更新

mysql 同表查询更新

分类: IT文章 • 2024-05-18 19:43:25

update apples
set price = (
select price from (
select * from apples
) as x
where variety = 'gala')
where variety = 'fuji';