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" ([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-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 : [EMAIL PROTECTED]
site vitrine : www.cedricom.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
