MySQL Forums :: Newbie :: Changing all values in a column


Advanced Search

Changing all values in a column
Posted by: Peter Nugter ()
Date: January 30, 2011 02:31PM

Dear Forum users,

I apologize my self for my poor knowledge of SQL but will anybody help me with the following sql-statement for a MySql-database?

Suppose I have
a database "a" (value between brackets)
with a table "b"
and a field (column) "c"
The values inside "c" have the type "double" with length = 2 and decimals = 1 and null = allowed. So you will find there values like "0.7", "0.0" and "2.1".

Now I want to change the values inside this "c"-column who have the value "0.0" (and ONLY THESE ONES!) into the value "0.2".

Can anyone give me the right sql-statement?

I am sorry again as I use databases only to fill out values within Navicat and the above syntax should be made inside this programm but I lack the skills.

Thank you kindly for your help!

Peter.

Options: ReplyQuote


Subject Written By Posted
Changing all values in a column Peter Nugter 01/30/2011 02:31PM
Re: Changing all values in a column Peter Brawley 01/30/2011 03:24PM
Re: Changing all values in a column Peter Nugter 01/30/2011 05:35PM
Re: Changing all values in a column SOLVED Peter Brawley 01/30/2011 05:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.