MySQL in your can ' t specify target table for update on FROM clause a

MySQL in your can ' t specify target table <tbl> for update in FROM clause error means that you cannot select some of the values in the same table first, and then update the table (in the same statement).

The following l:

You can circumvent the error by needing to select the result of the search again through the intermediate table select again.
As follows:

PS: This issue only occurs on Mysql,sql service and Oracle does not occur.

MySQL in your can ' t specify target table for update on FROM clause a