On Wednesday 26 February 2003 12:36, David Martin-Roche (ECE) wrote:
> I had a problem with mySQL 3.23.55 running on Solaris and on Linux (this
> problem doesn't occur in NT). When I'm creating the tables in the database,
> the next error is always provoked:
>
> ERROR 1005 at line 54: Can't create
David,
http://www.innodb.com/ibman.html#InnoDB_foreign_keys:
"Starting from 4.0.5 the InnoDB parser is aware of possible option
lower_case_table_names you give in my.cnf."
Upgrade to 4.0.11!
Heikki
Innobase Oy
sql query
...
Subject: Can't create FOREIGN KEY restraints on InnoDb ta
MySQL-4.1 to return more diverse error messages.
Regards,
Heikki
Innobase Oy
- Original Message -
From: "Erv Young" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 26, 2002 1:19 PM
Subject: Re: Can't create FOREIGN KEY restraints on InnoD
At 11:55 AM 6/25/2002 -0400, Andy Dustman wrote:
> From a usability perspective, since other databases don't seem to be so
>picky about this sort of thing, InnoDB ought to (IMHO):
>
>a) Act on REFERENCES clauses (i.e. column type REFERENCES ref-table)
>instead of ignoring them.
>
>b) Auto-create
On Tue, 2002-06-25 at 10:54, Roger Baklund wrote:
> Like Heikki said: your problem is probably that you don't have indexes on
> the foreign keys.
Setting an INDEX on each of those columns does fix the problem. It then
does allow me to remove the NOT NULL from the tracks table as I
originally ha
* Andy Dustman
> On Mon, 2002-06-24 at 17:50, Roger Baklund wrote:
> > * [EMAIL PROTECTED]
> > [...]
> > > The referred to keys are the same type and are indexed (they are
> > [...]
> > > CREATE TABLE genres (
> > > genre_idSMALLINT NOT NULL PRIMARY KEY,
> > [...]
> > > genre_id
On Tue, 2002-06-25 at 01:08, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message,
"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, June 25, 2002 1:16 AM
Subject: Re: Can't create FOREIGN KEY restraints on InnoDb tables
> * [EMAIL PROTECTED]
> [...]
> > The referred to keys are the same type and are indexed (they are
>
* [EMAIL PROTECTED]
[...]
> The referred to keys are the same type and are indexed (they are
[...]
> CREATE TABLE genres (
> genre_idSMALLINT NOT NULL PRIMARY KEY,
[...]
> genre_idSMALLINT,
...does not look the same to me... ;)
--
Roger
sql
