simple query error 1

[andyb2005]

Hi

I am just trying to execute this query on a new mysql db with the query window in phpMyAdmin but am getting an error but can't figure out why - anyone got any ideas?

Error

SQL-query :  

CREATE TABLE cust(

cust_id INT NOT NULL AUTO_INCREMENT ,
cust_title VARCHAR NULL ,
cust_firstname VARCHAR( 20 ) NOT NULL ,
cust_surname VARCHAR( 20 ) NOT NULL ,
cust_companyname VARCHAR( 20 ) NOT NULL ,
cust_address_1 VARCHAR NOT NULL ,
cust_address_2 VARCHAR NULL ,
cust_address_3 VARCHAR NULL ,
cust_town VARCHAR NOT NULL ,
cust_county VARCHAR NULL ,
cust_country VARCHAR NOT NULL ,
cust_postcode VARCHAR NOT NULL ,
PRIMARY KEY ( cust_id ) 
) 

MySQL said: 

You have an error in your SQL syntax near 'NULL ,
cust_firstname VARCHAR( 20  )  NOT  NULL ,
cust_surname VARCHAR( 20  )  N' at line 2

 

[r937]

VARCHARs require a dimension, e.g. VARCHAR(37)



r937.com | rudy.ca

 

[andyb2005]

DOH!!!

Many thanks!