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]