"Juliet May" <jmay(at)speark(dot)com> wrote:
> The comma gives me a parse error at or near "username". Without the comma
I
> get a parse error at or near "set".
>
> Any other suggestions?
>
> ----- Original Message -----
> From: "Oliver Kohll" <oliver(at)gtwebmarque(dot)com>
> To: <pgsql-novice(at)postgresql(dot)org>
> Sent: Thursday, July 11, 2002 6:15 PM
> Subject: Re: [NOVICE] update multiple columns
>
>
> UPDATE growernet_user
> SET email='madegn(at)hotmail(dot)com', username='adegn'
> WHERE user_id='696'
Did you try this exact query?
update growernet_user set email='madegn(at)hotmail(dot)com', username='adegn' where
user_id=696;
only one "set"? only one comma between the two field=value pairs?
Michael