title: SQL Primary Key Increment
body: <p>How can I have a primary key that auto increments?
  for example: when I insert something at the field name, the field id should be assign a value that is +1 that the last one.</p>
  
  <pre>
  id, name
   1, test1
   2, test2
  </pre>
  
  <p>so I insert the name something like testX and the id should be auto assigned as 3</p>
  
  <p>how can i do that?</p>