why am i getting this error??
CREATE TABLE customer(
cust_id int(5) NOT NULL auto_increment,
surname varchar(50) NOT NULL,
firstname varchar(50) NOT NULL,
initial char(1),
title varchar(10) NOT NULL,
addressline1 varchar(50) NOT NULL,
addressline2 varchar(50),
addressline3 varchar(50),
city varchar(20) NOT NULL,
state varchar(20) NOT NULL,
zipcode varchar(5) NOT NULL,
country varchar(20) NOT NULL,
phone varchar(15) NOT NULL,
email varchar(30) NOT NULL,
birth_date date() NOT NULL,
PRIMARY KEY (cust_id),
KEY names (firstname,zipcode)
);
MySQL said: You have an error in your SQL syntax near '() NOT NULL, PRIMARY KEY (cust_id), KEY names (firstname, zipcode) )' at line 16
whats the matter with that SQL ???
looks fine to me, please help!!
