AW: mutual declarations produce Error 1064

2003-08-14 Thread Morten Gulbrandsen
C:\mysql\bin>mysql -u elmasri -pnavathecompany Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 4.1.0-alpha-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select database(); ++ | database

AW: mutual declarations produce Error 1064

2003-08-14 Thread Morten Gulbrandsen
Hello Programmers, Thank you for the kind advice, I have another small problem with MySQL I'd like to investigate, All I get is this: ERROR 1005 at line 47: Can't create table '.\company\#sql-40c_4.frm' (errno: 150) What I attempt to do is this: C:\mysql\bin>mysql -u elmasri -pnavathe -vvv c

AW: mutual declarations produce Error 1064

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

AW: mutual declarations produce Error 1064

2003-08-12 Thread Morten Gulbrandsen
Hello programmers, 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) ERROR 1133: Can't find any matchin