Have you enabled the update on cascade features for the innodb tables? -----Original Message----- From: ginger cheng [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:26 AM To: Victor Pendleton Subject: RE: pseudo-trigger to update multiple tables?
Yes, I am using InnoDB tables. Victor Pendleton <[EMAIL PROTECTED]> wrote: Are you using innodb table types? Is this the type of updating you are in need of? -----Original Message----- From: ginger cheng [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:04 AM To: [EMAIL PROTECTED] Subject: pseudo-trigger to update multiple tables? Hello, I am just wondering how I can make a trigger to update multiple tables efficiently. (mysql db). RIght now I am thinking of making copys of the tables involved and update the copies to see the result. But it could be time consuming if the tables are huge. Any one has good ideas about it? Thank you for help ginger --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software _____ Do you Yahoo!? Yahoo! <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com> SiteBuilder - Free, easy-to-use web site design software