Question: Stumped with NOT NULL AUTO_INCREMENT
I've almost made it through my webpage without asking questions, but this problem has me stumped.
I am trying to create a new table with the ID column being NOT NULL AUTO_INCREMENT.
The table will create if I do not have NOT NULL AUTO_INCREMENT, but it WILL NOT create if I add those commands.
Here is my code:
mysql_query( "CREATE TABLE fb_$user_id ( id MEDIUMINT NOT NULL AUTO_INCREMENT, user_id INT(11), courseid INT(10), score INT(13), date TEXT )" );
Hopefully this code shows up correctly. I did follow the 'how to post code block correctly' instructions.
Thanks for your help