List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:October 19 2004 9:20am
Subject:Re: Innodb foreign keys names
View as plain text  
Richard,

you have to use a fairly recent 4.0 or 4.1 version of MySQL.

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/

.............................................
From: "Richard - CEDRICOM" (etudes@stripped)
Subject: Innodb foreign keys names
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2004-10-08 07:03:42 PST

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_xxxx" on a replicated server or gererate
automatic update scripts.

This is from mySql documentation :

ALTER TABLE yourtablename
ADD [CONSTRAINT [symbol]] FOREIGN KEY (...) REFERENCES anothertablename(...)

What the "symbol" value is use for ? if it is not handled : is this a bug ?

Is there any planned release of InnoDB that could handle the constraint
"foreign key" names ?

thanks in advance
regards


--
Richard FURIC
CEDRICOM
Tel : 02 99 55 07 55
Fax : 02 99 55 08 64
E-mail : etudes@stripped
site vitrine : www.cedricom.com 

Thread
Innodb foreign keys namesRichard - CEDRICOM8 Oct
Re: Innodb foreign keys namesHeikki Tuuri19 Oct
  • Re: Innodb foreign keys namesMartijn Tonies19 Oct
Re: Innodb foreign keys namesHeikki Tuuri19 Oct
  • Re: Innodb foreign keys namesMartijn Tonies20 Oct
Re: Innodb foreign keys namesHeikki Tuuri20 Oct
Re: Innodb foreign keys namesMartijn Tonies20 Oct
Re: Innodb foreign keys namesRichard - CEDRICOM20 Oct
Re: Innodb foreign keys namesHeikki Tuuri20 Oct