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);