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 [duplicate]

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? stackoverflow.com/questions/7298504/… — Erwin
– Erwin, Commented Jul 1, 2022 at 22:51

lemon · Accepted Answer · 2022-07-01 23:00:56Z

1

Try with this one:

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

answered Jul 1, 2022 at 23:00

15.6k6 gold badges23 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maxim Danilov · Accepted Answer · 2022-07-01 22:58:16Z

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;