J a v a 编程中常见的错误有哪些
sql 错误 找不到列 Unknown column „fillMen‟ in „field list‟ 2
列名在sql 语句中写了2次 Column „fillMan‟ specified twice 3
下面2条 数据库插入对应的列都是int 类型的 所插入的数据类型不符合要求时报错 Data truncated for column „gatheringMoney‟ at row 1 Data truncation: Out of range value adjusted for column „amount‟ at row 1 4
Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause 5
修改一个表时无法取得同一个表的数据 ERROR 1093 (HY000): You can‟ t specify target table „context‟ for update in FROM clause 6
主键 未自动增长 ERROR 1062 : 7
int 类型字符过长 com
exceptions
MySQLDataException: ‟ 2
5026744582E10′ in column ‟ 1′ is outside valid range for the datatype INTEGER
没找到错误 没影响数据读取 java
SQLException: Operation not allowed after ResultSet closed 9
类型错误 最常见的是数字类型错误 Data truncated