Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql update null values

--See records where specific column is NULL
SELECT * from table1 WHERE column1 IS NULL 

--Update all the NULL values in the selected column
UPDATE table1 SET column1 = replace_value WHERE column1 IS NULL
Source by dataschool.com #
 
PREVIOUS NEXT
Tagged: #sql #update #null #values
ADD COMMENT
Topic
Name
1+4 =