I recommend converting your MySQL tables to the InnoDB storage engine if
you need cascading update functionality. Any other solution is
virtually guaranteed to result in consistency errors in your database.
mysql> ALTER TABLE mytable TYPE = InnoDB;
Regards,
Bill Karwin
________________________________
From: ashish.sharma [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 04, 2007 9:44 PM
To: [email protected]
Subject: [fw-general] Example for cascading update
Hello ALL, I am trying to implement the cascading update
functionality, but i hvn't found any good reference to implement the
same. My application is having TABLE-1 as master table with 2-3
dependent table and TABLE-2 is a master table for TABLE-3. Now what I
want is whenever I mark/change the status of a Record (from
active-to-inactive OR vise versa) from TABLE-1 the status of the
dependent records from TABLE-2 should also get updated and based on the
records of TABLE-2 the status of it's dependent records from TABLE-3
should also get updated. Can anyone suggest some good ways to implement
the same? I was thinking to create a MYSQL stored procedure for this ..
will it be a good idea of doing this? NOTE: I can't implement CASCADE
UPDATE on mysql table as the mysql's myisam engine does not support this
feature. .. Ashish
________________________________
View this message in context: Example for cascading update
<http://www.nabble.com/Example-for-cascading-update-tf4381914s16154.html
#a12491529>
Sent from the Zend Framework mailing list archive
<http://www.nabble.com/Zend-Framework-f15440.html> at Nabble.com.
