bus_customer是主表。bus_customer_info_student是副表。bus_customer_info_student表中存了外键
刚开始查询错误数据的时候是正常的
SELECT istu.* FROM `bus_customer` c
left join bus_customer_info_student istu on c.id = istu.customer_id
where c.is_del =0 and c.customer_type_id = 1
and istu.id is null
想删除的时候就提示错误了:
delete from bus_customer where id in(
(SELECT c.id id FROM `bus_customer` c
left join bus_customer_info_student istu on c.id = istu.customer_id
where c.is_del =0 and c.customer_type_id = 1
and istu.id is null)
You can't specify target table for update in FROM clause。意思是说,不能先select出同一表中的某些值,再update这个表(在同一语句中)改成酱婶儿的就好了
dele