CodingForums.com - View Single Post

Old Pedant · 02-18-2013, 04:29 PM

You missed the spacing:

Code:

    CONSTRAINT   FOREIGN  KEY  boardID REFERENCES allBoards( boardID )

**********

You must either omit the field name of the auto_increment field from your INSERT *or* supply a NULL as the value, else the value you give overrides the auto_increment feature.

Code:

INSERT INTO allBoards( boardID, manufacturer, ...) VALUES( NULL, 'Asus', ... )
*OR*
INSERT INTO allBoards( manufacturer, ...) VALUES( 'Asus', ... )

**************

If you are on Windows, the case (upper vs. lower) of table names is not significant and by default all are converted to lower case by MySQL. I believe that even on Linux this behavior is optional.

02-18-2013, 04:29 PM	PM User \| #9
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,248 Thanks: 59 Thanked 3,999 Times in 3,968 Posts	You missed the spacing: Code: CONSTRAINT FOREIGN KEY boardID REFERENCES allBoards( boardID ) ********** You must either omit the field name of the auto_increment field from your INSERT or supply a NULL as the value, else the value you give overrides the auto_increment feature. Code: INSERT INTO allBoards( boardID, manufacturer, ...) VALUES( NULL, 'Asus', ... ) OR INSERT INTO allBoards( manufacturer, ...) VALUES( 'Asus', ... ) ************** If you are on Windows, the case (upper vs. lower) of table names is not significant and by default all are converted to lower case by MySQL. I believe that even on Linux this behavior is optional. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.