Skip site navigation (1) Skip section navigation (2)

Re: update multiple columns

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: update multiple columns
Date: 2002-07-11 23:21:55
Message-ID: 008801c22931$bf05f450$c9bab23e@beeblebrox (view raw or flat)
Thread:
Lists: pgsql-novice
"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



In response to

Responses

pgsql-novice by date

Next:From: Juliet MayDate: 2002-07-11 23:26:36
Subject: Re: update multiple columns
Previous:From: Juliet MayDate: 2002-07-11 23:15:23
Subject: Re: update multiple columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group