Need help understanding error message

[tryin_to_learn]

I'm not terribly experienced with databases. Can someone tell me what's wrong with this query? I've included the error message below - I'm not sure what it's telling me or how I fix it.

CREATE TABLE saClient(
clientID INTEGER UNSIGNED NOT NULL ,
firstName VARCHAR NOT NULL AUTO_INCREMENT ,
middleName VARCHAR NULL ,
lastName VARCHAR NULL ,
address1 VARCHAR NULL ,
address2 VARCHAR NULL ,
city VARCHAR NULL ,
state VARCHAR NULL ,
zip VARCHAR NULL ,
birthday VARCHAR NULL ,
ssn VARCHAR NULL ,
fax VARCHAR NULL ,
email1 VARCHAR NULL ,
email2 VARCHAR NULL ,
phoneCell VARCHAR NULL ,
phoneHome VARCHAR NULL ,
phoneWork VARCHAR NULL ,
phoneOther VARCHAR NULL ,
emergContactName VARCHAR NULL ,
emergContactPhone1 VARCHAR NULL ,
emergContactPhone2 VARCHAR NULL ,
emergContactRelationship VARCHAR NULL ,
sex TINYINT UNSIGNED NULL ,
notes TEXT NULL ,
STATUS TINYINT UNSIGNED NULL ,
PRIMARY KEY ( clientID )
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL AUTO_INCREMENT,
middleName VARCHAR NULL,
lastName VARCHAR NULL,
' at line 3

[swampBoogie]

You need to specify a maximum lengths for the columns defined as varchar

e.g.

phoneHome vachar(20)

Also, auto_increment can not be defined for a varchar column, use integer or bigint.

[tryin_to_learn]

Thanks. Worked like a charm.