MySQL Forums
Forum List  »  InnoDB

Re: ON DELETE CASCADE
Posted by: Peter Brawley
Date: November 27, 2007 12:43PM

>the script works on Oracle...the tables are emptied...point made
>does NOT work on mysql 5.0...question is WHY NOT?

Unless innodb is the default engine, you need CREATE TABLE(...)engine=innodb;

PB

Options: ReplyQuote


Subject
Views
Written By
Posted
100311
September 11, 2007 09:14AM
30038
November 08, 2007 11:18AM
21974
November 26, 2007 12:37PM
24132
November 27, 2007 08:14AM
14976
September 01, 2008 09:39AM
14752
November 26, 2007 01:39PM
Re: ON DELETE CASCADE
10198
November 27, 2007 12:43PM
10208
September 21, 2008 10:59AM
18606
November 17, 2007 09:09PM


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.