Still on the top of foreign keys :)

I have this statement:

ALTER TABLE `mytable` 
ADD FOREIGN KEY ( `id` ) 
REFERENCES `othertable` ( `id` );

Is there a way I can give this key a specific name (eg 'FK_mytable_id') and
specific the type of reference (eg 'ON UPDATE CASCADE')?


-- 
View this message in context: 
http://www.nabble.com/Add-foreign-key-tf2950373.html#a8251394
Sent from the MySQL - General mailing list archive at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to