Martijn,
- Alkuperäinen viesti -
Lähettäjä: "Martijn Tonies" <[EMAIL PROTECTED]>
Vastaanottaja: <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Wednesday, October 20, 2004 11:34 AM
Aihe: Re: Innodb foreign keys names
> Hello Heikki,
>
...
&
yodbc
> Sent: Wednesday, October 20, 2004 10:08 AM
> Subject: Re: Innodb foreign keys names
>
> > Hello Heikki,
> >> >
> >> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
> >> >
> >> >Does a newer version allow you
Hello Heikki,
> >> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
> >> >
> >> >Does a newer version allow you to change/set the names yourself?
> >>
> >> you can give the name yourself in new versions. Please look at the
InnoDB
> >> manual section.
> >
> > "A constraint name can
Martijn,
- Original Message -
From: ""Martijn Tonies"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 20, 2004 10:08 AM
Subject: Re: Innodb foreign keys names
Hello Heikki,
>
>> you have to use a fairly recent 4.0 or 4.
Hello Heikki,
> >
> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
> >
> >Does a newer version allow you to change/set the names yourself?
>
> you can give the name yourself in new versions. Please look at the InnoDB
> manual section.
"A constraint name can be given as of MySQL 4.
Martijn,
List: mysql
Subject:Re: Innodb foreign keys names
From: "Martijn Tonies"
Date: 2004-10-19 9:53:28
Message-ID: <01ad01c4b5c1$7c1e69a0$0a02a8c0 () martijn>
[Download message RAW]
>Heikki,
>
>> you have to use a fairly recent 4.0 or 4.1
Heikki,
> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Does a newer version allow you to change/set the names yourself?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
>
technical support from https://order.mysql.com/
.
From: "Richard - CEDRICOM" ([EMAIL PROTECTED])
Subject: Innodb foreign keys names
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2004-10-0
Hi everybody,
Still have a problem with naming "foreign key" constraints on innodb tables.
Can't retrieve any of the name that was given to the constraints.
"Internally generated" IDs are always given to the foreign keys... no way to
apply a "drop foreign key 0_" on a replicated server or ger
