From: Johan De Meersman
Date: February 5 2010 11:30am
Subject: Re: how to update a entire column elements
List-Archive: http://lists.mysql.com/mysql/220576
Message-Id: <aaba5c101002050330y201c4c5oc2da195eeaddb0e9@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e6d272f7b276e9047ed8c589

--0016e6d272f7b276e9047ed8c589
Content-Type: text/plain; charset=ISO-8859-1

update table set column=value where <condition>.

"value" may be calculated based on other columns or whatever.

If you need to set n rows to arbitrary values, however, you'll need to issue
multiple statements.


On Fri, Feb 5, 2010 at 11:50 AM, MuraliKrishna <
murali_krishna@stripped> wrote:

> Hi I am in need to update a entire column elements with different values.
> If
> any body know the syntax please help me.. Regarding this.. Thanks in
> advance
>
>
>
> By
>
> Muralikrishna
>
>
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0016e6d272f7b276e9047ed8c589--