Problems with the MySQL DELETE statement

Have encountered this problem a few times before, all feel that the problem is not big, so there is no record, but this time again met, and did not think of the first time, so there is a record of the necessary

MySQL DELETE statement throws when using a subquery to manipulate the same table

DELETE  from where inch (Selectfromwhereisnull )

[Err] 1093 - You can"ABC" for update in from clause

Workaround: Add a virtual intermediate table to relay

DELETE  from where inch (Select* fromwhere-isnull ) s  );

The same problem will exist when you update it.

Solved, but what is the principle? Not clear, I hope the great God see after the advice, thank you.

There is also a problem, the deletion of the time is not an alias

Delete  from where = ' Qeq ';

[Err] 1064 - inch Check  to  for  Right  to  Use '  'qeq'1

The alias is removed and can be executed normally.

Problems with the MySQL DELETE statement