例子:表201403的byPoolName值的前两位赋给byFactoryName值 update [201403] set byFactoryName=substring(byPoolName,1,2) 得到的结果如图所示: