MySQL Forums
Forum List  »  Newbie

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!


Options: ReplyQuote

Written By
Changing all values in a column
January 30, 2011 02:31PM

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.