how change all of null fiulds of the table to zero?

Question

problem: without field name!

Answer 1

update <table> set <field name> =0 where <field name> is null ;

//example :::

update employee set salaray = 0 where salary is null ;
update employee set name ="no name" where name is null ;

//hope it helps ☺

Answer 2

i know only for single field , for more fields u can repeat the piece of code or u must look for another answer

Answer 3

there is many of field !!!

Answer 4

i donw know name of fields. :((