Re: [GENERAL] Dynamic update

On Wed, 3 Nov 1999, Alain TESIO wrote:

> -- Simon Drabble  wrote:
> > Is it possible to update a column with another column's value, say
> > 
> > UPDATE member SET votes = `SELECT count(votes) FROM ballot WHERE id
> > = 1`;
> > 
> > with or without aggregates?
> 
> Have you tried a more direct command ?
> 
> UPDATE member SET votes count(votes) FROM ballot WHERE id = 1 ;
> 
> (I can't test right now but I don't see why this wouldn't work ...)
> 
> Alain


I get parse error at or near count - any variation (without the = sign)
produces a similar error.

TA,

Simon.

> 
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
> 

-- 
 "Linux - open doors, not windows."
   
   Simon Drabble                      It's like karma for your brain.
   simon@eskimo.com