Error has me chewing my hair

Hello!

I am a mysql newbie here. I was working with a particular database and created two tables with no problems. then, for apparently no reason, i am not able to create a new table. here is the syntax i am using:


CREATE TABLE Tables (Table_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT);

but then i get a error 1064 and it says i have an error in my SQL syntax.

this is liquifying my brain. please help me!!

Shaheeb

Sorry to hear about your brain shabba - this is probably due to the fact that you have a primary key defined
this example creates a table called persons with a primary key and a column called name

CREATE TABLE persons (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(60) NOT NULL,
PRIMARY KEY (id)
);

Hope this helps

CREATE TABLE Tables (
Table_ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (Table_ID ));