set a data to null in sql code example
Example 1: can you update NULL in sql
UPDATE [table]
SET [column]=0
WHERE [column] IS NULL;Example 2: get null data in sql
SELECT * FROM EMPLOYEES
WHERE MANAGER_ID IS NULL ;UPDATE [table]
SET [column]=0
WHERE [column] IS NULL;SELECT * FROM EMPLOYEES
WHERE MANAGER_ID IS NULL ;