One of the column user_form in my table is filled with (NULL) value. Now i want to change that NULL to 'A' with this code UPDATE table_name SET user_form='A' where user_form=(NULL) but no luck. I have also tried to ALTER column default value. But still no luck
Use is NULL to check .Detail
What manual says about NULL :
Conceptually,
NULLmeans “a missing unknown value” and it is treated somewhat differently from other values.
To test for NULL, use the IS NULL and IS NOT NULL operators
UPDATE table_name SET user_form='A' where user_form is NULL
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments