title: Can primary index be a CHAR in MySQL?
body: <p>My primary indexes are unique reference numbers like 002345 and 000023.</p>
  
  <p>If I format them as integers I loose my zero's. They need to be 6 digits.</p>
  
  <p>Can I use CHAR? I don't need any auto increments.</p>