Hello all
I am using PHPmyAdmin to create a table.
Here is my SQL Statement:
CREATE TABLE constest2003 (
contestantID INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
age INT NOT NULL ,
fname VARCHAR NOT NULL ,
lname VARCHAR NOT NULL ,
address VARCHAR NOT NULL ,
city VARCHAR NOT NULL ,
state VARCHAR NOT NULL ,
country VARCHAR NOT NULL ,
pnumber VARCHAR NOT NULL
)
And I get the following error in phpMyAdmin
You have an error in your SQL syntax near 'NOT NULL , fname VARCHAR NOT NULL , lname VARCHAR NOT NULL , address VARCH' at line 1
Can anyone tell me what the problem with my script is?