16 px] single table batch update


A table

Null value in the value of the field to cover b field and a value of 0.00 field [/size]

CodePudding user response:

Update the set b=a where clause ifnull (b, 0)=0

CodePudding user response:

Update the set b=A where clause ifnull (b, 0)=0