List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:October 19 2004 9:53am
Subject:Re: Innodb foreign keys names
View as plain text  
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


> 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
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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