Mysql update话语赋值嵌套select

Mysql update语句赋值嵌套select

update a set col=(select col from (select * from a ) as b where id='5' )where id>5 and id <10;