title: MySQL Primary Key Field Type
body: <p>I am working with some transactional data and having issues with my primary key field.  When importing data from my order manager system and Google analytics, the OrderID field has the following two value formats:</p>
  
  <pre><code>123456  
  002-0130775-1483424
  </code></pre>
  
  <p>How do I format this field to be a primary key?</p>
  
  <p>Thank you in advance for your help! :)</p>
  
  <p>(Running MySQL 5.5.27)</p>