2007/2/15, Manuel Vacelet [EMAIL PROTECTED]:
Hi all,
I'm facing a strange behaviour with an UPDATE statement.
I have a table like:
+-+--+
| item_id | rank |
+-+--+
|2812 |2 |
| 13050 |4 |
| 13051 |3 |
| 13052 |1 |
+-+--+
And I want
Hi all,
I'm facing a strange behaviour with an UPDATE statement.
I have a table like:
+-+--+
| item_id | rank |
+-+--+
|2812 |2 |
| 13050 |4 |
| 13051 |3 |
| 13052 |1 |
+-+--+
And I want to switch items 2812 and 13052 rank (i.e.
Hello,
I'm alittle unclear on how too update multiple tables. We have two tables with
the same column name:
account.state
account_service.state
when we update the account table, we also need to update the account_service
table with the same value for the 'state' column. Can this be done
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Monday, March 27, 2006 3:39 PM
Subject: Update multiple tables
Hello,
I'm alittle unclear on how too update multiple tables. We have two tables
with the same column name
Mike Blezien [EMAIL PROTECTED] wrote on 03/27/2006 03:39:15 PM:
Hello,
I'm alittle unclear on how too update multiple tables. We have two
tables with
the same column name:
account.state
account_service.state
when we update the account table, we also need to update
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