sql报错

1  ### SQL: Insert into table_front_user_certification_information (user_id,username,certificate_type,certificate_num,               certificate_front_pic,certificate_back_pic,certificate_face_pic             )       VALUES(?,?,?             ,?                                                                       ,?)
### Cause: java.sql.SQLException: Column count doesn't match value count at row 1

; bad SQL grammar []; nested exception is java.sql.SQLException: Column count doesn't match value count at row 1

 <insert id="insertUser" parameterType="map">
        Insert into
          table_front_user
          (user_id,telephone,username
          <if test="password !=null and password != ''">
             ,password
          </if>
          
          ,register_type,deviceId)
        VALUES
            (
            #{userNo},#{mobile},#{userName}
             <if test="password !=null and password != ''">
             ,#{password}
             </if>
            
            ,#{registerType},#{deviceId}
            )
    </insert>

   

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 5
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

at com.sun.proxy.$Proxy102.selectOne(Unknown Source)

 2 

mysql错误:Column count doesn't match value count at row 1

是由于类似

INSERT INTO table_name(col_name1, col_name2, col_name3) VALUES('value1','value2');

语句中，前后列数不等造成的，

3

Incorrect integer value: 'aaa' for column 'auditor_no' at row 1

数据库字段类型不对

4

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

mysql 连接出现问题