update SUPPLIER
set LINKMAN1 =SUBSTRING(TAXPAYERID, 0, 30)
where length(LINKMAN1) > 30这个语句执行失败,报错的地方在SUBSTRING这急,在线等
请高手们帮忙处理,谢谢!
set LINKMAN1 =SUBSTRING(TAXPAYERID, 0, 30)
where length(LINKMAN1) > 30这个语句执行失败,报错的地方在SUBSTRING这急,在线等
请高手们帮忙处理,谢谢!
update SUPPLIER
set LINKMAN1 =SUBSTRING(TAXPAYERID, 1, 30)
where length(LINKMAN1) > 30
SET LINKMAN1 = SUBSTR (TAXPAYERID, 0, 30)
WHERE LENGTH (LINKMAN1) > 30
update SUPPLIER
set LINKMAN1 =SUBSTR(TAXPAYERID, 1, 30)
where length(LINKMAN1) > 30
SET LINKMAN1 = SUBSTR (TAXPAYERID, 0, 30)
WHERE LENGTH (LINKMAN1) > 30
update SUPPLIER
set LINKMAN1 =SUBSTR(TAXPAYERID, 1, 30)
where length(LINKMAN1) > 30
两个都正确
set LINKMAN1 =SUBSTR(TAXPAYERID, 1, 30)
where length(LINKMAN1) > 30 right!