pseudo-trigger to update multiple tables?

2003-09-24 Thread ginger cheng
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

RE: pseudo-trigger to update multiple tables?

2003-09-24 Thread Victor Pendleton
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

RE: pseudo-trigger to update multiple tables?

2003-09-24 Thread Victor Pendleton
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