title: revert rows to default column value mysql
body: <p>I am using MySQL community server 5.1.  Is there a way to just set all the rows back to their default column values with one query?</p>
  
  <p>I just added a lot of rows. I had default values for most of the columns specified, but for some reason all the columns values were set = 0 instead. I was wondering if there is a query to set all the column values to their default value, and I would need the ability for a <code>where</code> clause too. </p>
  
  <p>something like this for example:</p>
  
  <pre><code>update table set values = values(default) where id &gt; 300;
  </code></pre>
  
  <p>Thanks!</p>