When I execute the following query

CREATE TABLE Sponsor (
sNum INTEGER UNSIGNED NOT NULL,
sAdrBlock CHAR(2),
sCivil_ID CHAR(12),
sDateOfBirth DATE,
sDrvLicenseExp DATE,
sDrvLicenseNum CHAR(9),
sGender ENUM('M','F'),
sName VARCHAR(20),
sStatus VARCHAR(20),
sTelephone CHAR(7),
A_areaNum INTEGER UNSIGNED NOT NULL,
G_goverNum INTEGER UNSIGNED NOT NULL,
O_occupNum INTEGER UNSIGNED NOT NULL,
N_nationNum INTEGER UNSIGNED NOT NULL,
PRIMARY KEY (sNum),
FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
FOREIGN KEY (G_goverNum) REFERENCES Governate(goverNum),
FOREIGN KEY (O_occupNum) REFERENCES Occupation(occupNum),
FOREIGN KEY (N_nationNum) REFERENCES Nationality(nationNum)
);

I get the following error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Area(areaNum),
FOREIGN KEY    (G_goverNum)  REFERENCES Governate(goverNum),
at line 17

Any ideas?
Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to