Software

Ask something
Discussion Locked

Major Update question.....Please Help

0 helpful
2 replies

by rumstead

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a table that contains x amount of columns. One of those columns contains thousands of NULL values. I need a way to quickly change those null values into real values (already determined values) without changing them manually 1 at a time.

2 replies

by loril

UPDATE table
SET your_column_with_nulls = new_value
WHERE your_column_with_nulls IS NULL

by okda7

update emp
set address='non'
where address is null;

where column_name is null

This discussion is closed to new replies.