Re: Inserting information into multiple tables and problems

[Jasper Bryant-Greene]

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/