title: set default values in mysql Id column?
body: <p>I want to start my mysql table id as todaysdate+000001 like 20120602000001 OR 20120602/000001 and that when next entry made then ID should be 20120602000002 OR 20120602/000002 (means it should get auto_incremented also).
  HOw can we do this?</p>
  
  <p>my table structure is</p>
  
  <pre><code>table abc(id int auto_increment,name varchar(50),company varchar(50),contact varchar(10),persontomeet varchar(30),intime TIMESTAMP CURRENT_TIMESTAMP,primary key(id));
  </code></pre>
  
  <p>but id starts with 1 obiviously..
  I want to start it as 20120602000001 and when next time INSERT triger will trigger then it should get set to 20120602000002
  please help me...</p>