Check out example codes for "replace null value within column mysql". It will help you in understanding the concepts better.

Code Example 1

UPDATE `table` SET `somefield`=0 WHERE `somefield` is null

Learn ReactJs, React Native from akashmittal.com