Re: update multiple columns

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'

?

Oliver

> I am almost 100% positive that I have been able to set multiple columns
> while doing an update statement but for the life of me I can't remember
> exactly how I did it. I tried using parenthesis, comas, and "and" but none
> of it worked. Have I lost my mind. If not, can anyone see my mistake?
>
> My code is below. TIA
>
> Julie
>
>
> update growernet_user
> set email='madegn(at)hotmail(dot)com'
> set username='adegn'
> where
> user_id=696

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly