how to update a entire column elements

how to update a entire column elements

am 05.02.2010 11:50:08 von MuraliKrishna

------=_NextPart_000_0000_01CAA67F.3FAEACF0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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




------=_NextPart_000_0000_01CAA67F.3FAEACF0--

Re: how to update a entire column elements

am 05.02.2010 12:30:01 von Johan De Meersman

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

update table set column=value where .

"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@arthaoptions.com> 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--

Re: how to update a entire column elements

am 05.02.2010 12:37:02 von joao

Are you talking about data in column ou structure of table?

"MuraliKrishna" escreveu na mensagem
news:4b6bf981.0807c00a.0cba.29bb@mx.google.com...
> 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
>
>
>
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: how to update a entire column elements

am 05.02.2010 14:57:51 von Ramesh

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

Kindly draft you question clearly with scenario example, so that the
solution should be clear.

On 5 February 2010 16:20, MuraliKrishna 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
>
>
>
>


--
Ramesh

--0016e68debdc8c6938047edad7d6--