这在逻辑上是行不通的,因为sql会试图获取它正在更新的数据。
尝试运行嵌套语句 select PRICE from PRODUCTS where ID = 1 另外,保存响应,然后运行主语句: "UPDATE PRODUCTS SET PRICE = " + newPrice
select PRICE from PRODUCTS where ID = 1
"UPDATE PRODUCTS SET PRICE = " + newPrice