Mysql update语句赋值嵌套selectupdate a set col(select col from (select * from a ) as b where id5
Mysql update语句赋值嵌套select
update a set col=(select col from (select * from a ) as b where id='5' )where id>5 and id <10;
Mysql update语句赋值嵌套select
update a set col=(select col from (select * from a ) as b where id='5' )where id>5 and id <10;