MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

SET DEFAULT in FOREIGN KEY constraint
Posted by: Karsten Wutzke
Date: June 11, 2009 04:58AM

Hello,

MySQL doesn't support the SET DEFAULT referential action with FOREIGN KEYs because of InnoDB.

What's the reason for that?

I don't see any difference between setting a default ON DELETE or ON UPDATE and a entering some value manually. Why not just generate an error and rollback, which InnoDB can do?

Karsten

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SET DEFAULT in FOREIGN KEY constraint
3286
Karsten Wutzke
June 11, 2009 04:58AM
Re: SET DEFAULT in FOREIGN KEY constraint
2162
Peter Gulutzan
June 11, 2009 10:30AM
Re: SET DEFAULT in FOREIGN KEY constraint
1948
Karsten Wutzke
June 11, 2009 04:40PM
Re: SET DEFAULT in FOREIGN KEY constraint
1898
Peter Gulutzan
July 05, 2009 01:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.