Re: mutual declarations produce Error 1064

2003-08-14 Thread Fred van Engen
Morten, In your extremely long mail, I think I managed to find your question and removed all other stuff. On Wed, Aug 13, 2003 at 03:18:26PM +0200, Morten Gulbrandsen wrote: > mysql> > mysql> # from now on the coding causes trouble > mysql> > mysql> ALTER TABLE EMPLOYEE > -> FOREIGN KEY (SUP

Re: mutual declarations produce Error 1064

2003-08-14 Thread Victoria Reznichenko
"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, > MGRS

Re: mutual declarations produce Error 1064

2003-08-08 Thread Victoria Reznichenko
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > I think something is wrong with my administration, > > Basically I get these messages, > > ERROR 1005 at line 9: Can't create table '.\company\department.frm' > (errno: 150) > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using passw