Hi!
I know older versions of MySQL do not support foreign keys. Find out
weather your version do. If not, you may have to do without the foreign
keys in your definitions.
Best regards
Babs
-----Urspr=FCngliche Nachricht-----
Von: Morten Gulbrandsen [mailto:mg*@owi-aachen.de]=20
Gesendet: Freitag, 15. August 2003 12:05
An: my***@lists.mysql.com
Betreff: I simply can't compile this
CREATE TABLE EMPLOYEE
(=20
FNAME VARCHAR(15) NOT NULL,
MINIT CHAR,
LNAME VARCHAR(15) NOT NULL,
SSN CHAR(9) NOT NULL,
BDATE DATE,
ADDRESS VARCHAR(30),
SEX CHAR,
SALARY DECIMAL(10,2),
SUPERSSN CHAR(9),
DNO INT NOT NULL DEFAULT 1,
PRIMARY KEY (SSN),
INDEX (SUPERSSN),=09
INDEX (DNO)
)TYPE =3D INNODB;
CREATE TABLE DEPARTMENT
(
DNAME VARCHAR(15) NOT NULL,
DNUMBER INT NOT NULL,
MGRSSN CHAR(9) NOT NULL DEFAULT '888665555',
MGRSTARTDATE DATE,
PRIMARY KEY (DNUMBER),
UNIQUE (DNAME),
INDEX (MGRSSN)
)TYPE =3D INNODB;
=09
ALTER TABLE EMPLOYEE=20
ADD FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(SSN)
ON DELETE SET NULL =20
ON UPDATE CASCADE;
ALTER TABLE EMPLOYEE # here is the buggy code
ADD FOREIGN KEY (DNO) REFERENCES DEPARTMENT(DNUMBER)
ON DELETE SET DEFAULT =20
ON UPDATE CASCADE;=09
=09
ALTER TABLE DEPARTMENT
ADD FOREIGN KEY (MGRSSN) REFERENCES EMPLOYEE(SSN)=20
ON DELETE SET DEFAULT =20
ON UPDATE CASCADE ;
=09
Please tell me what could be wrong,
Yours Sincerely
Morten Gulbrandsen
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my******************@fongo.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw