Can anyone tell me what my problem is because i dont get the error?
CREATE TABLE generalContact (
timeStamp timestamp(14) NOT NULL,
firstName varchar(25) binary NOT NULL default \'\',
lastName varchar(25) binary NOT NULL default \'\',
company varchar(25) binary default NULL,
website varchar(50) binary default NULL,
phone varchar(25) binary NOT NULL default \'\',
countryCode varchar(4) binary default NULL,
phoneExt varchar(8) binary default NULL,
mobile varchar(25) binary default NULL,
fax varchar(25) binary NOT NULL default \'\',
email varchar(100) binary NOT NULL default \'\',
address varchar(50) binary NOT NULL default \'\',
city varchar(25) binary NOT NULL default \'\',
state varchar(25) binary NOT NULL default \'\',
country varchar(50) binary NOT NULL default \'\',
heardAbout varchar(255) binary default NULL,
other varchar(255) default NULL,
inquiringOn varchar(255) binary NOT NULL default \'\',
zipCode varchar(25) binary NOT NULL default \'\'
) TYPE=MyISAM;
MySQL said:
You have an error in your SQL syntax near '\'\',
lastName varchar(25) binary NOT NULL default \'\',
company varchar' at line 3
