"Juliet May" <jmay@speark.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@gtwebmarque.com>
> To: <pgsql-novice@postgresql.org>
> Sent: Thursday, July 11, 2002 6:15 PM
> Subject: Re: [NOVICE] update multiple columns
>
>
> UPDATE growernet_user
> SET email='madegn@hotmail.com', username='adegn'
> WHERE user_id='696'
Did you try this exact query?
update growernet_user set email='madegn@hotmail.com', username='adegn' where
user_id=696;
only one "set"? only one comma between the two field=value pairs?
Michael