phpMyAdmin gives syntax error on 'perfect' table script
Posted: Tue May 13, 2003 9:19 pm
This script is identical in syntax to other code that was succesfully entered into phpMyAdmin. I am puzzled because it should work. Could someone try it out for me? Cheers Abby
---------
CREATE TABLE ADDRESS
(
addressID INT(10) NOT NULL AUTO_INCREMENT,
addressType VARCHAR(8) NOT NULL,
street1 VARCHAR(50),
street2 VARCHAR(50,
town VARCHAR(50),
state CHAR(5),
postcode VARCHAR(10),
country VARCHAR(20) REFERENCES COUNTRY (country),
email VARCHAR(50),
url VARCHAR(50),
phone CHAR(15),
mobile CHAR(15),
fax CHAR(15),
PRIMARY KEY ('addressID')
);
-------------
---------
CREATE TABLE ADDRESS
(
addressID INT(10) NOT NULL AUTO_INCREMENT,
addressType VARCHAR(8) NOT NULL,
street1 VARCHAR(50),
street2 VARCHAR(50,
town VARCHAR(50),
state CHAR(5),
postcode VARCHAR(10),
country VARCHAR(20) REFERENCES COUNTRY (country),
email VARCHAR(50),
url VARCHAR(50),
phone CHAR(15),
mobile CHAR(15),
fax CHAR(15),
PRIMARY KEY ('addressID')
);
-------------