List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:March 27 2006 8:39pm
Subject:Update multiple tables
View as plain text  
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 with MySQL 
4.1.12. and what is the correct syntax?


Thx's
Mickalo 

Thread
Update multiple tablesMike Blezien27 Mar
  • Re: Update multiple tablesRhino27 Mar
  • Re: Update multiple tablesSGreen28 Mar