Trouble with mysql

[farley99]

what am i doing wrong?

the error is:

SQL-query :

CREATE TABLE `jluLogin` (

`jluID` INT NOT NULL AUTO_INCREMENT,
`jluLogin` VARCHAR NOT NULL ,
`jluPass` VARCHAR NOT NULL ,
`jluDate` DATE,
PRIMARY KEY ( `jluLogin` )
)

MySQL said:


You have an error in your SQL syntax near 'NOT NULL, `jluPass` VARCHAR NOT
NULL, `jluDate` DATE, PRIMARY KEY (`jluLogin`))' at line 1

 

[sleipnir214]

As is documented here:

http://www.mysql.com/doc/en/Column_types.html

, you have to specify a maximum length for a varchar column.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!