Mysql update statement value nested select

Mysql update statement value nested select Java code update a set col = (select col from a where id = '5') where id> 5 and id <10; ERROR 1093 (HY000) reported at www.2cto.com: You can't specify target table 'A' for update in FROM clause. It is found that the mysql update statement cannot assign values to the same disk at the same time, that is to say, when updating a, you cannot select col from a later. If the table is different, there is no problem. Solution: set Table a in the select statement to an alias B to solve this problem. Java code update a set col = (select col from (select * from) as B where id = '5') where id> 5 and id <10;