title: Mysql -- inserting in table with only an auto incrementing column
body: <p>Lets say we have table A with just one column, id(which is the primary key)</p>
  
  <p>How do we insert a new row into the table without specifying an id?</p>
  
  <p>I tried this</p>
  
  <pre><code>INSERT INTO A (`id`) VALUES (NULL)
  </code></pre>
  
  <p>and it doesn't work</p>
  
  <p><strong>Edit:</strong> I forgot to mention that id, the primary key has the auto_increment and NOT NULL attribute.</p>
  
  <p><strong>Edit 2:</strong> The exact error when running the query above is </p>
  
  <pre><code>Column 'id' cannot be null
  </code></pre>