List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 10 2003 4:11am
Subject:Re: MySQL 4.0.11 update syntax
View as plain text  
At 21:41 -0600 3/9/03, Charles Lewis wrote:
>I was reading somewhere that MySQL 4.1 UPDATE syntax will allow 
>update to table with values from another table in the following 
>manner:
>
>update client, zip
>set client.st = zip.st, client.city = zip.city
>where client.zip = zip.zip;
>
>Is there a creative way to do this in 4.0.11?

Sure.  Just issue the query you show above.  Multi-table updates
actually were implemented in 4.0.2.

Or did you try it and it didn't work?

>
>chas

Thread
MySQL 4.0.11 update syntaxCharles Lewis10 Mar
  • Re: MySQL 4.0.11 update syntaxPaul DuBois10 Mar