Re: MySQL 4.0.11 update syntax

[Paul DuBois]

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