Replace null with 0 in MySQL

Question

I am getting NULL values in the results of an operation in MySQL.

Is there a way to convert the NULL values into the value 0?

user_2213708 · Answer

If you messed up and have NULLs in existing table layout and want zeros, here is solution:

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

user_3578242 · Answer

you can put the 0 value into your insert input method by casting it:(int)0