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 
>update client, zip
>set =, =
>where =;
>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?


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