表格1+----------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+----------+-------------+------+-----+---------+----------------+| UserID | int(11) | NO | PRI | NULL | auto_increment || Password | varchar(20) | NO | | | || Username | varchar(25) | NO | | | || Email | varchar(60) | NO | | | |+----------+-------------+------+-----+---------+----------------+表2+------------------+--------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+------------------+--------------+------+-----+---------+----------------+| UserID | int(11) | NO | MUL | | || PostID | int(11) | NO | PRI | NULL | auto_increment || Title | varchar(50) | NO | | | || Summary | varchar(500) | NO | | | |+------------------+--------------+------+-----+---------+----------------+错误:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`myapp/table2`, CONSTRAINT `table2_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `table1` (`UserID`)) 我做错了什么?我阅读了http://www.w3schools.com/Sql/sql_foreignkey.asp,但看不到有什么问题。
添加回答
举报
0/150
提交
取消