该句的意思是,insert操作的SQL语句里列的数目和后面值的数目不一致.比如说,
String sql = "insert into t_aqi(city_name, cur_date, aqi_val, no2_val, no2_val) values(?, ?, ?, ?)";
这里很明显,t_aqi括号中的参数的个数多余values括号中的个数.
相关文章
- 09-11[Err] 1136 - Column count doesn't match value count at row 1
- 09-11SQLException： Column count doesn't match value count at row 1
- 09-11java.sql.SQLException:Column count doesn't match value count at row 1
- 09-11Err 1136 - Column count doesn't match value count at row 1
- 09-11开发中运行mysql脚本，发现提示mysql提示Column count doesn't match value count at row 1错误
- 09-11mysql Column count doesn't match value count at row 1
- 09-11[Mybatis - 1A] - Cause: java.sql.SQLException: Column count doesn't match value count at row 1
- 09-11报错：Column count doesn't match value count at row 1
- 09-11sql语句出错：Column count doesn't match value count at row 1
- 09-11mysql错误:Column count doesn't match value count at row 1