Mysql update statement: You can't specify target table 'user' for u

When I learned MYSQL, I took the user table in mysql and found some problems with mysql subqueries. For example, the contents of the user table are as follows:

 

Shows how to change it:

 

It should be very simple, but it should be OK with the subquery, but the error is: You can't specify target table 'user' for update in FROM clause.

 

It's still a strange thing about how such a simple thing can be solved. Just hurry to Baidu and you can't use it like this in mysql. faint, modify the statement, as shown below, it's OK, it just takes a second to get a temporary table and an alias. It is really troublesome. I hope mysql can solve this boring problem as soon as possible.





From sdjjt's BLOG