； uncategorized SQLException； SQL state [HY000]； error code [1193]； Unknown system variable ‘create_

柔光的暖阳◎ 2022-12-29 06:54 393阅读 0赞

# 前言 #

项目突然报错：

# 错误信息： #

; uncategorized SQLException; SQL state [HY000]; error code [1193]; Unknown system variable 'create_time'; nested exception is java.sql.SQLException: Unknown system variable 'create_time',

# 解决： #

已经更换了，数据库连接的版本号：

<dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.11</version>
            </dependency>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70]  
最主要没有写xml，映射  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70 1]  
通过上面报错信息可以看到，在编写sql语句时没有写入参对象与，更新哪个表：

<update id="updateByScaleId" parameterType="com.naolu.phb.pojo.PhbCollectScale">
        update phb_collect_scale
        <set>
          <if test="createTime != null">
            create_time = #{ createTime,jdbcType=TIMESTAMP},
          </if>
          <if test="createUser != null">
            create_user = #{ createUser,jdbcType=VARCHAR},
          </if>
          <if test="updateTime != null">
            update_time = #{ updateTime,jdbcType=TIMESTAMP},
          </if>
          <if test="updateUser != null">
            update_user = #{ updateUser,jdbcType=VARCHAR},
          </if>
          <if test="collectId != null">
            collect_id = #{ collectId,jdbcType=INTEGER},
          </if>
          <if test="scaleId != null">
            scale_id = #{ scaleId,jdbcType=INTEGER},
          </if>
          <if test="scaleDetailsOptionAnswerId != null">
            scale_details_option_answer_id = #{ scaleDetailsOptionAnswerId,jdbcType=INTEGER},
          </if>
          <if test="scaleDetailsOptionId != null">
            scale_details_option_id =  #{ scaleDetailsOptionId,jdbcType=INTEGER},
          </if>
          <if test="scaleQuestion != null">
            scale_question=  #{ scaleQuestion,jdbcType=VARCHAR},
          </if>
          <if test="scaleQuestionAnswer != null">
            scale_question_answer = #{ scaleQuestionAnswer,jdbcType=VARCHAR},
          </if>
        </set>
        where scale_id = #{ scaleId,jdbcType=INTEGER}
      </update>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70]: /images/20221120/712c16796b1246d794b9edc1df729669.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201221112939804.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyMzcwOTEz,size_16,color_FFFFFF,t_70