### 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.