title: mysql update increment int field that is null
body: <p>I have a very large table with two INT columns that are null on Default. This is a problem because since they are INT fields, it would help in many cases if they were originally set to 0. </p>
  
  <p>So my questions are, is there a way I can UPDATE and INCREMENT(+1) these fields while they are like this (null on Default)? BTW.. I didn't have luck so far, it seems increment only works when the default=0</p>
  
  <p>..or is my only option to Change the Default to none from null</p>