You can't specify target table 't_d_cc_spacing' for update in FROM clause

存在的问题: You can't specify target table 't_d_cc_spacing' for update in FROM clause

 

sql语句 :  delete from t_d_cc_spacing where id=(select MAX(id) from t_d_cc_spacing )

 

mysql当中不能在统一语句中先在当前表中查出某些值,然后在通过这个值来update这个表, 这也只有在mysql中不可以.

 

解决:

 

delete a from t_d_cc_spacing a ,(select max(id) as max_id from t_d_cc_spacing) b

where a.id=b.max_id

 

delete from t_sys_user_area where id in (select * from (select id from t_sys_user_area where user_id not in (SELECT ID from t_sys_user ))_)