UPDATE T_PlanFund
SET FPlanSumarry = '数码相机' FPlanMoney = 99999 FPlanMoneyDirection = 0 FPlanMoneyImport = 0 FPlanFundSign = ' ' FPlanFundDate = 2010 / 1 / 11 FPlanFundLock = 0
FPlanNote = '111'
WHERE FPlanFundId = 10
错误信息:'FPlanMoney'附近有语法错误
SET FPlanSumarry = '数码相机' FPlanMoney = 99999 FPlanMoneyDirection = 0 FPlanMoneyImport = 0 FPlanFundSign = ' ' FPlanFundDate = 2010 / 1 / 11 FPlanFundLock = 0
FPlanNote = '111'
WHERE FPlanFundId = 10
错误信息:'FPlanMoney'附近有语法错误
2、日期类型一般是用减号分隔,加单引号
当然根据具体DBMS类型及连接DBMS的方式不同可能还有额外要求,参考语句如下UPDATE T_PlanFund
SET FPlanSumarry = '数码相机', FPlanMoney = 99999, FPlanMoneyDirection = 0, FPlanMoneyImport = 0, FPlanFundSign = ' ', FPlanFundDate = '2010-1-11', FPlanFundLock = 0, FPlanNote = '111'
WHERE FPlanFundId = 10
最好用to_date()函数,这样包没错