Mysql set decimal value if null

Actualizar campo decimal con un valor determinado en los casos que sea NULL


UPDATE `pro_table` SET `weight`='1000.00' WHERE weight IS NULL
UPDATE `pro_table` SET `width`='50.00' WHERE width IS NULL
UPDATE `pro_table` SET `height`='10.00' WHERE height IS NULL
UPDATE `pro_table` SET `depth`='50.00' WHERE depth IS NULL
post-author