update null values using WHERE filter

PHOTO EMBED

Mon Mar 21 2022 03:01:30 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

UPDATE emp_info
SET address = ''
WHERE address IS NULL;
SELECT * FROM emp_info;

UPDATE emp_info
SET salary_$ = 0
WHERE salary_$ IS Null;
SELECT * FROM emp_info;
content_copyCOPY