Mysql:table ' name ' is specified twice, both as a target for ' UPDATE ' and as a separate source for data

MySQL may have this error when performing a delete, update, such as you wrote a SQL similar to the following:

UPDATE SET Col=col+1where in (SELECTfromWHERE Othercol=0)

Or

DELETE  from WHERE inch (SELECTfromWHERE othercol=0)

This time will appear table ' xxx ' is specified twice such errors, do not know why MySQL will do such a freeze, know the great god please give a link.

To solve this problem is very simple, since the table ' xxx ' can not be placed in the subquery inside, then do a cache table chant.

DELETE from MYTABLE where ID in (SELECT * FROM (select ID from MYTABLE where othercol=0) as TEMP)

There's no problem with that.

Mysql:table ' name ' is specified twice, both as a target for ' UPDATE ' and as a separate source for data