AW: mutual declarations produce Error 1064

2003-08-14 Thread Morten Gulbrandsen
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

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, MGRSTARTDATE

mutual declarations produce Error 1064

2003-08-14 Thread Morten Gulbrandsen
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, MGRSTARTDATEDATE, PRIMARY KEY (DNUMBER), UNIQUE (DNAME), INDEX

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 (SUPERSSN)

AW: mutual declarations produce Error 1064

2003-08-14 Thread Morten Gulbrandsen
Cc: 'Victoria Reznichenko'; [EMAIL PROTECTED] Betreff: Re: mutual declarations produce Error 1064 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

AW: mutual declarations produce Error 1064

2003-08-14 Thread Morten Gulbrandsen
declarations produce Error 1064 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

AW: mutual declarations produce Error 1064

2003-08-12 Thread Morten Gulbrandsen
[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

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 password: YES)