Originally Posted by Old Pedant
You missed the spacing:
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.
INSERT INTO allBoards( boardID, manufacturer, ...) VALUES( NULL, 'Asus', ... )
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.
The error posted did have spacing where the OP had them, lost in copy-paste.. I fixed the CREATE TABLE but missed the rest.. thanks for the info.