update goods_order set isPay = 1, where orderId = 100 > 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where orderId = 100' at line 3
时间: 2023-07-17 22:04:30 浏览: 75
SQL.zip_capf1r_sql
根据你提供的SQL语句和错误信息看起来,错误是在 "set" 和 "where" 之间存在一个额外的逗号(,)。请尝试去掉这个逗号,将SQL语句修改为以下形式:
```
UPDATE goods_order
SET isPay = 1
WHERE orderId = 100;
```
这样修改后的SQL语句应该就不会再报错了。
阅读全文