title: How to put text in front of auto increment field in mysql (like : TTT00001)?
body: <p>I want to put some text in front of my auto increment field with mysql, 
  but I still have no answer to do this.
  here is the example data that I want to insert into table</p>
  
  <p>"IDC00000001"</p>
  
  <p>and what I do now just auto incremented integer with zerofill format,
  and the result just 00000001.</p>
  
  <p>and I want the number auto incremented. so when Insert some data again it will be like this
  "IDC00000002", "IDC00000003",........,"IDC00000022",etc</p>
  
  <p>my questions:</p>
  
  <ol>
  <li>how to solved this case? </li>
  <li>am I need a store procedure? </li>
  <li>what is best practice to do this, prepare this in php before insert or in mysql directly?</li>
  </ol>