title: How do I insert an empty row, but have the autonumber update correctly?
body: <p>I was hoping to be able to do something like</p>
  
  <pre><code>INSERT INTO `table`;
  </code></pre>
  
  <p>or maybe even a SET clause like</p>
  
  <pre><code>SET `primary_key` = null
  </code></pre>
  
  <p>where all the columns of the table aren't set (and are left to their default), with the exception of the autonumbered primary key which should be set.</p>
  
  <p>Any suggestions?</p>