title: create Student ID number with year and auto incremented value
body: <p>i created a student id number compose of text and auto incremented value like: KP0001 - KP9999 it will reset to KP0001 again, It will result to duplicate ID number. I changed it to this: 2013-00001 but it's not working i dont know why.</p>
  
  <p>this is what i tried:</p>
  
  <pre><code>text  id
  KP    1
  KP    2
  KP    3
  
  SELECT * ,concat(text,LPAD(id,4,'0')) as stud_id FROM students
  </code></pre>
  
  <p>i want to change the text into year which will update yearly.
  Thanks, Mills</p>