Re: [DOCS COMMENT] Section 'UPDATE'

[Thimble Smith]

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
-- 
Tim Smith   < tim@stripped >  :MySQL Development Team:  Boone, NC  USA.