Software·43,881 discussions

Major Update question…..Please Help

Locked

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.

Topic

Try this to update your NULL values

In reply to Major Update question…..Please Help

UPDATE table
SET your_column_with_nulls = new_value
WHERE your_column_with_nulls IS NULL

Major Update question

In reply to Major Update question…..Please Help

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

where column_name is null

[Author]

Replies