String SQL_ADD_ = "INSERT INTO DEPARTMENT VALUES ( Null, 'HR')";
或者
String SQL_ADD_ = "INSERT INTO DEPARTMENT VALUES ( '0', 'HR')"; stmt.executeUpdate(SQL_ADD_);
或者
String SQL_ADD_ = "INSERT INTO DEPARTMENT VALUES ( '0', 'HR')"; stmt.executeUpdate(SQL_ADD_);
解决方案 »
- 关于分区表,函数YEARWEEK无效的疑问。
- PostgreSQL 逻辑型一问
- 如何在windows 的mysql把数据库放到d盘
- 如何创建外键
- mysql恢复数据库
- 请教这个excel格式的题库是哪个系统导出的,谢谢各位~
- mysql 转储 大写变小写问题
- 求助 1054 - Unknown column '*' in 'where clause'的问题
- mysql 的存储过程的问题
- mysql load或者mysqlimpoort 数据,txt格式,如何跳过数据格式错误的行(字段超长或者字段格式少或者多))?
- 数据库用LINUX下MYSQL,客户端用VC,能行吗?
- mysql数据库连接的问题!请求帮助!
如果用INSERT INTO DEPARTMENT VALUES ( Null, 'HR')",报错
java.sql.SQLException: General error: Column 'DEPT_ID' cannot be null
at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQuery(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.Statement.executeUpdate(Unknown Source)
at com.mysql.jdbc.jdbc2.Statement.executeUpdate(Unknown Source)
at AddTester.main(AddTester.java:24)
java.sql.SQLException: Invalid argument value: Duplicate entry '0' for key 1
at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQuery(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.Connection.execSQL(Unknown Source)
at com.mysql.jdbc.Statement.executeUpdate(Unknown Source)
at com.mysql.jdbc.jdbc2.Statement.executeUpdate(Unknown Source)
at AddTester.main(AddTester.java:24)
???再试试这个
INSERT INTO `DEPARTMENT` SET dept_name = 'HR';如果还不行,
用 SHOW CREATE TABLE `DEPARTMENT`
将表结构显示出来看看呢,