From: Martijn Tonies
Date: October 19 2004 2:42pm
Subject: Re: Innodb foreign keys names
List-Archive: http://lists.mysql.com/mysql/174506
Message-Id: <040601c4b5e9$e44f34a0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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