Whats wrong with this query ??

[Anon]

here is the query that I did :

code:--------------------------------------------------------------------------------

CREATE TABLE (id TINYINT not null AUTO_INCREMENT, msg VARCHAR (500) not null , date INT (10) not null , view INT (3) not null , mood INT (5) not null , PRIMARY KEY (id), UNIQUE (id)) ;

(problem : "MySQL said: You have an error in your SQL syntax near '(id TINYINT not null AUTO_INCREMENT, msg VARCHAR (500) not null , date INT (10' at line 1
")

can someone please help ??

THANX

[mwilson]

You haven't given a table name, should have been;

CREATE TABLE [table name] (id TINYINT not null AUTO_INCREMENT, msg VARCHAR (500) not null , date INT (10) not null , view INT (3) not null , mood INT (5) not null , PRIMARY KEY (id), UNIQUE (id)) ;

HTH

Matt

[Anon]

THANX, its cuz I didnt sleep all the day (-;

• varchar max is 255 and not 500 :-)

THNAX,
dima.

[Anon]

CREATE TABLE (id TINYINT not null AUTO_INCREMENT, msg VARCHAR (500) not null , date INT (10) not null , view INT (3) not null , mood INT (5) not null , PRIMARY KEY (id), UNIQUE (id)) ;

where is the table name?

give the table name it should work fine.