company LIKE "EMPLOYEE";
SHOW TABLE STATUS FROM company LIKE "DEPARTMENT";
Can someone please take a look at my coding,
-Ursprüngliche Nachricht-
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 8. August 2003 13:02
An: [EMAIL PROTECTED
van Engen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 13. August 2003 15:36
An: 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
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
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 (MGRSSN
"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
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"
the users I have created ?
I expect one user and one password for entering mysql,
And depending upon which database I'd like to use
I expect for each database I'd like to use, one second password,
This seems to be another topic,
When I write
mysql> grant all on company.* to '
"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
