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;
Copyright© offブログ! , 2021 All Rights Reserved Powered by AFFINGER5.