如何用update语句解决问题 [英] How can i solve problem with update statement

问题描述

解析查询时出错。 [令牌行号= 1，令牌行偏移= 158，令牌错误= WHERE]



UPDATE pr_product SET pr_name_3454 ='{0}'，pr_remaining_3454 =' {1}'，pr_priority_3454 ='{2}'，pr_purchase_level_3454 ='{3}'，pr_price_3454 ='{4}'，WHERE pr_id_3454 = {5}



我尝试了什么：



尝试多次更改但没有结果

There was an error parsing the query. [ Token line number = 1,Token line offset = 158,Token in error = WHERE ]

" UPDATE pr_product SET pr_name_3454 ='{0}', pr_remaining_3454 ='{1}', pr_priority_3454 ='{2}', pr_purchase_level_3454='{3}', pr_price_3454='{4}', WHERE pr_id_3454= {5}"

What I have tried:

Tried to change several times but no result

推荐答案

'{4}'之后有一个逗号，表示另一个参数

You have a comma after '{4}' which implies a further argument

这篇关于如何用update语句解决问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！