In addition to Ben's answer...
> Hi All,
>
> I have been repeatedly trying to create the following table - without
> __ANY__ success. Looks like there is REALLY something wrong with the
> MySQL engine or something! Here is the script:
Posting the error itself would help.
Martijn Tonies
Databas
Asif, I note 3 problems:
1 - your table is named 'order', which is a reserved word in MySQL and
most other db engines. I'd suggest using a different name. If you must
use 'order' for the name, enclose it in backticks, a la `order`, in the
create statement.
2 - you have IDNEX instead of IND
Hi All,
I have been repeatedly trying to create the following table - without
__ANY__ success. Looks like there is REALLY something wrong with the
MySQL engine or something! Here is the script:
CREATE TABLE Order (
DID int not null,
DeskNo int
Hi!
> "Brandon" == Brandon Bird <[EMAIL PROTECTED]> writes:
Brandon> From: [EMAIL PROTECTED]
Brandon> To: [EMAIL PROTECTED]
Brandon> Subject: comment with "foreign key" text causes innodb CREATE TABLE
Brandon> failure
Brandon> Description:
Brandon> If an innodb table is created with a
-
From: ""Brandon Bird"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, March 15, 2003 12:36 AM
Subject: comment with "foreign key" text causes innodb CREATE TABLE failure
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Su
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: comment with "foreign key" text causes innodb CREATE TABLE
failure
Description:
If an innodb table is created with a comment with the words "foreign
key", the table creation fails.
The syntax used to work with MySQ
