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
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
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