title: Primary Key Index Automatic
body: <p>I m currently doing  a project using mysql and am a perfect beginner in it.....</p>
  
  <p>I made a table with the following columns.....</p>
  
  <pre><code>            ID           // A integer type column which is a primary key........
              Date         // A Date type column.........
              Day          // A String column.........
  </code></pre>
  
  <p>Now i just wanna know whether there exist any method by which the <code>ID</code> <strong>column insertion value is automatically generated</strong>......??</p>
  
  <p>for eg: -   If i insert a <code>date - 4/10/1992</code> and <code>Day - WED</code> as values. <strong>The Mysql Server should automatically generate any integer value starting from <code>1</code> checking whether they exist.</strong>
  i.e in a table containing the values</p>
  
  <pre><code>             ID              Date              Day
  
               1              01/02/1987         Sun
               3              04/08/1990         Sun
  </code></pre>
  
  <p>If i m inserting the Date value and Day value(specified in the example) in the above table. It should be inserted as </p>
  
  <pre><code>             2              04/10/1992         WED
  </code></pre>
  
  <p>I tried methods like using auto incrementer.....But i m afraid it just only increments the ID value.</p>