mysql 实现查询并修改 UPDATE car set status = 0 where car_id in (SELECT c.car_id FROM (SELECT * FROM car) c where c.color = 1) 注意:需要在子查询中使用别名查询 (SELECT * FROM car) c 才能实现,否则会报错