SQL syntax problem

[oblig]

What's up with this MySQL syntax?

CREATE TABLE users (
ID int NOT NULL, 
Alias varchar(40) NOT NULL, 
Team varchar NOT NULL, 
FName varchar NOT NULL, 
SName varchar NOT NULL, 
DOB date NOT NULL, 
Gender tinyint(1) NOT NULL, 
Password varchar NOT NULL, 
Email varchar NOT NULL, 
ICQ varchar NULL, 
MSN varchar NULL, 
AIM varchar NULL, 
YIM varchar NULL, 
Showemail tinyint(1) NOT NULL, 
ShowIM tinyint(1) NOT NULL, 
Mobile varchar NULL, 
CountryID INT NOT NULL, 
State varchar NOT NULL, 
Bio varchar NULL, 
NewPassword varchar NOT NULL, 
NewEmail varchar NOT NULL, 
PicID tinyint NOT NULL,
PRIMARY KEY (ID)
);

TIA

[Godin]

well, much as my memory as a bit iffy on this (been a while since I had a similar prob) I seem to remember that MySQL wont let you use password as a column name, so try changing it to something like pass or passwd and see if that goes. It doenst seem to be documented as a reserved word but it normally acts as one.

[MattR]

All character datatypes besides text require a size parameter.

e.g.
VARCHAR( 40 )
CHAR( 10 )

[oblig]

Thanks, it works now.