How to replace null with mysql?
You can replace null data find null use “where”
UPDATE tb_name SET co_name = "test" WHERE co_name IS NULL;
If you want to temporary replace null
SELECT COALESCE(co_name, 'test') FROM tb_name;
You can replace null data find null use “where”
UPDATE tb_name SET co_name = "test" WHERE co_name IS NULL;
If you want to temporary replace null
SELECT COALESCE(co_name, 'test') FROM tb_name;