Updating a column(Null value to integer)

Question

SO what I am trying to do is update a couple columns in one of my tables in sql. I need to update a value that is currently null to a value that is 0.75. I have done some research but I can't specifically find an answer related to my issue. Can anyone help me out? I know that it would read something like this if the value was not null,

UPDATE copy_f_staffs
SET overtime_rate='11.10'
WHERE id=12;

How does '11.10', a string, relate to the value 0.75?

David Aldridge
– David Aldridge

2013-04-04 23:17:37 +00:00
Commented Apr 4, 2013 at 23:17 — David Aldridge
– David Aldridge, Commented Apr 4, 2013 at 23:17

Scotch · Accepted Answer · 2013-04-04 22:40:10Z

1

For oracle

  UPDATE copy_f_staffs
 SET overtime_rate='11.10'
  WHERE overtime_rate is null;

This will set your null overtime_rate fields to '11.10'

answered Apr 4, 2013 at 22:40

Scotch

3,23211 gold badges41 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yoyoyo Over a year ago

Awesome, thanks buddy. I'll mark as answer as soon as I can! :)

Collectives™ on Stack Overflow

Updating a column(Null value to integer)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related