Please notice that
INDEX (DNO, DNUMBER),
is changed to be
INDEX (DNO),
And I managed to get another error message,
But it still woun't compile.
Also manually typing the code gave another result as
Piping the company_01.sql file through an input operator <
Please tell me what could be wrong ?
Yours sincerely
Morten Gulbrandsen
-----Ursprüngliche Nachricht-----
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 7. August 2003 13:54
An: [EMAIL PROTECTED]
Betreff: Re: mutual declarations produce Error 1064
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
> USE company;
>
> # SHOW INNODB STATUS;
>
> DROP TABLE IF EXISTS DEPARTMENT;
>
> CREATE TABLE DEPARTMENT
> (
> DNAME VARCHAR(15) NOT NULL,
> DNUMBER INT NOT NULL,
> MGRSSN CHAR(9) NOT NULL,
> MGRSTARTDATE DATE,
>
> PRIMARY KEY (DNUMBER),
> UNIQUE (DNAME),
>
> INDEX (MGRSSN), # between employee and department
> FOREIGN KEY (MGRSSN), # a sort of mutually declaration
> REFERENCES EMPLOYEE(SSN) # this is declared in employee
Remove comma before REFERENCES.
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
