List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:June 21 2000 2:57pm
Subject:Re: [DOCS COMMENT] Section 'UPDATE'
View as plain text  
On Tue, Jun 20, 2000 at 04:54:33AM -0000, Baker Franke wrote:
> Is it possible to do multiple updates in one 
> line.  I have two values for two different keys 
> that I simply want to swap.  Do I have to do two 
> separate update statements?  I know the answer is 
> no, I just can't figure it out.

The answer is "yes".  You can't swap the values in one statement.

Tim Smith   < tim@stripped >  :MySQL Development Team:  Boone, NC  USA.
[DOCS COMMENT] Section 'UPDATE'Baker Franke20 Jun
  • Re: [DOCS COMMENT] Section 'UPDATE'Thimble Smith21 Jun