title: ERROR 1364 (HY000): Field 'id' doesn't have a default value
body: <p>This is my table. id expected as Primary Key and auto filled</p>
  
  <pre><code>mysql&gt; DESCRIBE test_table
  -&gt; ;
  +-------+--------------+------+-----+---------+-------+
  | Field | Type         | Null | Key | Default | Extra |
  +-------+--------------+------+-----+---------+-------+
  | id    | int(8)       | NO   | PRI | NULL    |       |
  | name  | varchar(256) | YES  |     | NULL    |       |
  | phone | varchar(20)  | YES  |     | NULL    |       |
  +-------+--------------+------+-----+---------+-------+
  3 rows in set (0.00 sec)
  </code></pre>
  
  <p>However, when I INSERT data this way</p>
  
  <pre><code>mysql&gt; INSERT INTO test_table (name, phone) VALUES ('Nikita', '26908050');
  </code></pre>
  
  <p>It returns error, that id doesn't have Default value. </p>
  
  <pre><code>ERROR 1364 (HY000): Field 'id' doesn't have a default value
  </code></pre>
  
  <p>How I can tell MySQL that id must start with 0 and increese each time something is added to test_table?</p>