List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:October 19 2004 2:42pm
Subject:Re: Innodb foreign keys names
View as plain text  
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.0.18"

Ah, by itself - a great feature. Pain in the *** though, that it has been
added in (yet another) _minor_ MySQL update. This makes providing
tools for it quite a burden...

The good thing: this is an addition, unlike renaming a column returned
from SHOW TABLES :-/


Thanks for pointing this out.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.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