Re: Update multiple tables strange behaviour

2007-02-19 Thread Manuel Vacelet
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 wan

Re: Update multiple tables

2006-03-27 Thread SGreen
"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 the ac

Re: Update multiple tables

2006-03-27 Thread Rhino
- Original Message - From: "Mike Blezien" <[EMAIL PROTECTED]> To: "MySQL List" 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: account.state account_se