>> 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> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT MODULE N12310);
>>
>> ERROR 1064: You have an error in your SQL syntax near 'MODULE N12310)' at
>> line 1
>Did you mean:
>INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES('INPUT MODULE N12310')
#######################################
It does appear that I did meanthat.
The Structure I should be using should be:
INSERT INTO TABLE_NAME (COLUMN_NAME) VALUES('VALUE_TO_INSERT_INTO_COLLUMN');
mysql> SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
+---------------------+-----------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------+
| Table | Create Table
|
+---------------------+-----------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------+
| 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 |
+---------------------+-----------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------+
1 row in set (0.02 sec)
Thanks again for your help in getting this right.
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]
