todd hewett wrote: >>>mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) >>>mysql> VALUES(36534); >>> >>>ERROR 1216: Cannot add a child row: a foreign key constraint fails > > >>Can you please post the output of: > > >>SHOW CREATE TABLE BOARD_SERIAL_NUMBER; > > > mysql> SHOW CREATE TABLE BOARD_SERIAL_NUMBER; > --------------------------------------------+ > | BOARD_SERIAL_NUMBER | CREATE TABLE `BOARD_SERIAL_NUMBER` ( > `BOARD_SERIAL_NUMBER_PK` int(10) unsigned NOT NULL auto_increment, > `VCS_PO_NUMBER_PK` int(10) unsigned NOT NULL default '0', > `BOARD_SERIAL_NUMBER` varchar(255) NOT NULL default '', > PRIMARY KEY (`BOARD_SERIAL_NUMBER_PK`,`VCS_PO_NUMBER_PK`), > KEY `BOARD_SERIAL_NUMBER_FKIndex1` (`VCS_PO_NUMBER_PK`), > FOREIGN KEY (`VCS_PO_NUMBER_PK`) REFERENCES > `productiontrack.VCS_PO_NUMBER` (`VCS_PO_NUMBER_PK`) ON DELETE CASCADE > ) TYPE=InnoDB | > +---------------------+-----------------------------------------------------
Because you're not specifying a value for VCS_PO_NUMBER_PK in that INSERT statement, it will default to 0. It is a foreign key referencing the 'productiontrack.VCS_PO_NUMBER' table, which I bet doesn't have a row with VCS_PO_NUMBER_PK equal to 0. Hence the foreign key constraint fails. You need to either: 1/ Specify the relevant value for VCS_PO_NUMBER_PK in your insert statement, like INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER, VCS_PO_NUMBER_PK) VALUES (36534, 12345); 2/ Remove the foreign key constraint 3/ Create a row in VS_PO_NUMBER where VCS_PO_NUMBER_PK is equal to 0 You should probably take option 1 if possible. ##################################################################### O.K. VCS_PO_NUMBER_PK is an auto increment primary key for VCS_PO_NUMBER How would I know that value... I am trying to inser the VCS_PO_NUMBER at this time. I guess what needs to be one in this case is: Insert the VCS_PO_NUMBER Search the table for VCS_PO_NUMBER_PK where VCS_PO_NUMBER IS a certain value and then use that info in the board serial number insert. Does that sound right? Thanks for the illumination. Todd MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
