sql-修改每条数据的某一个字段的值

update B set B.maildata =(select SUBSTRING(maildata,0,3) from basedata where basedata.cid = B.cid)+(select CONVERT(varchar, CAST(SUBSTRING(maildata,3,4) as int )+100)
from basedata where basedata.cid = B.cid)+(select SUBSTRING(maildata,3+4,len(maildata)-1) from basedata where basedata.cid = B.cid) from basedata B where B.cid = 113

给要修改的表起别名的主要作用在于 子查询条件不唯一

 

posted @ 2018-07-23 16:01  一线之间  阅读(941)  评论(0编辑  收藏  举报