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

You run SQL to delete records:
delete from acc where id IN (select id FROM acc where id > 3);

and got error:
[Err] 1093 - You can't specify target table 'acc' for update in FROM clause

Solution:
delete from acc where id IN (select id FROM (select id FROM acc where id > 3) t);