While Delete the multiple rows using column value, getting "update you can't specify target table for update in from clause" this error in mysql

Question

I'm using the below DELETE query.

DELETE FROM tableAA WHERE id IN (SELECT id FROM tableAA WHERE coreID IN (SELECT fill_ID FROM tableBBB) and columnData= 'data');

but I am getting this "update you can't specify target table for update in from clause" error.

Take a look at this question? https://stackoverflow.com/questions/7298504/mysql-delete-with-nested-select-query — Erwin, Jul 01 '22 at 22:51

score 1 · Answer 1 · answered Jul 01 '22 at 22:58

1

Sorry, i can not check my example right now:

DELETE FROM tableAA LEFT JOIN tableAA.id = fill_ID.tableBBB WHERE fill_ID NOT IS NULL and columnData = data;

answered Jul 01 '22 at 22:58

Maxim Danilov

score 1 · Accepted Answer · answered Jul 01 '22 at 23:00

1

Try with this one:

DELETE FROM tableAA 
WHERE coreID IN (SELECT fill_ID FROM tableBBB)
  AND columnData = 'data';

answered Jul 01 '22 at 23:00

lemon

While *Delete* the multiple rows using column value, getting "update you can't specify target table for update in from clause" this error in mysql