I have already run this query .. but it is not changing the table type to InnoDB as phpMyAdmin is still showing the table type as MyISAM.
Ashish Bill Karwin wrote: > > 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. > > > > -- View this message in context: http://www.nabble.com/Example-for-cascading-update-tf4381914s16154.html#a12535922 Sent from the Zend Framework mailing list archive at Nabble.com.
