UPDATE car set status =0 where car_id in (SELECT car_id FROM car where color =1)
执行以上SQL后 报错信息如下:
UPDATE car set status =0 where car_id in (SELECT car_id FROM car where color =1)1093-You can't specify target table 'car' for update in FROM clause
时间:0.001s
错误信息提示为: 不能在FROM子句中指定用于更新的目标表’car’
二、解决方法如下:
在子查询中再添加一个查询并取出别名,如下:
UPDATE car set status =0 where car_id in (SELECT c.car_id FROM (SELECT *FROM car) c where c.color =1);