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> 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');
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
