Re: [GENERAL] Dynamic update

On Wed, 3 Nov 1999, Alain TESIO wrote:

> -- Simon Drabble <simon(at)eskimo(dot)com> 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(at)eskimo(dot)com