insert into order_bt_component (id, order_id, order_id, module_specification, module_mini_cnt, module_total_cnt, module_pickup_cnt, is_deleted, creator, create_time_, operator, update_time_ values (#{id,jdbcType=BIGINT}, #{orderId,jdbcType=BIGINT}, #{componentId,jdbcType=BIGINT}, #{moduleSpecification,jdbcType=VARCHAR}, #{moduleMiniCnt,jdbcType=INTEGER}, #{moduleTotalCnt,jdbcType=INTEGER}, #{modulePickupCnt,jdbcType=INTEGER}, #{isDeleted,jdbcType=VARCHAR}, #{creator,jdbcType=BIGINT}, #{createTime,jdbcType=BIGINT}, #{operator,jdbcType=BIGINT}, #{updateTime,jdbcType=BIGINT})
时间: 2024-03-06 08:47:39 浏览: 83
insert into
很抱歉,这条SQL语句有语法错误,缺少了一个右括号。正确的SQL语句如下:
```
insert into order_bt_component (id, order_id, component_id, module_specification, module_mini_cnt, module_total_cnt, module_pickup_cnt, is_deleted, creator, create_time_, operator, update_time_) values (#{id,jdbcType=BIGINT}, #{orderId,jdbcType=BIGINT}, #{componentId,jdbcType=BIGINT}, #{moduleSpecification,jdbcType=VARCHAR}, #{moduleMiniCnt,jdbcType=INTEGER}, #{moduleTotalCnt,jdbcType=INTEGER}, #{modulePickupCnt,jdbcType=INTEGER}, #{isDeleted,jdbcType=VARCHAR}, #{creator,jdbcType=BIGINT}, #{createTime,jdbcType=BIGINT}, #{operator,jdbcType=BIGINT}, #{updateTime,jdbcType=BIGINT})
```
请注意,我修改了原始SQL语句中重复的order_id参数名,并补全了最后一个右括号。
阅读全文