Re: update multiple columns

"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