ERROR druid.sql.Statement - {conn-10001, pstmt-20016} execute error. insert into exam_question_assembly (asid, created_time, order, qid, score, updated_time) values (?, ?, ?, ?, ?, ?) java.sql.SQLSyntaxErrorException: 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 'order, qid, score, updated_time) values ('2', null, '1', '7', 3, null)' at line 1
时间: 2023-11-14 12:04:58 浏览: 319
druid-master.rar_Druid_jboss druid_ojdbc5-11.2.0.3.jar
根据出现的错误信息,似乎是在执行SQL语句时发生了语法错误。具体来说,错误信息中指出了在执行下列SQL语句时出现了问题:
```
insert into exam_question_assembly (asid, created_time, order, qid, score, updated_time) values (?, ?, ?, ?, ?, ?)
```
根据错误信息来看,似乎是 `order` 这个字段出现了问题。`order` 是 MySQL 中的关键字之一,在使用时需要注意。建议将 `order` 改为其他名称,例如 `order_num` 等。修改后的 SQL 语句为:
```
insert into exam_question_assembly (asid, created_time, order_num, qid, score, updated_time) values (?, ?, ?, ?, ?, ?)
```
你可以尝试将 SQL 语句中的 `order` 改为 `order_num`,然后再次执行。
阅读全文