[Err] 1093 - You can't specify target table 'matorder' for update in FROM clause 原句：delete from mat

[Err] 1093 - You can't specify target table 'matorder' for update in FROM clause

原句：delete from matorder where mat_id in (select mat_id from matorder where mat_code = 1)

解决：delete from matorder where mat_id in (select mat_id from (select m.mat_id,m.mat_code from matorder m) mat where mat.mat_code = 1)