title: MySQL Grouping rows by a shared ID
body: <p>Say I have</p>
  
  <pre><code>ID | PRODUCT
   1 |  Apples
   1 | Oranges
   1 | Bananas
   2 | Walnuts
   2 | Almonds
   3 | Steak
   3 | Chicken
  </code></pre>
  
  <p>Is this possible to have this type of setup in MySQL? I created a test table, and made an ID column with primary index and auto incrementing. When I try to insert a couple rows all having the same ID, mysql returns an error.</p>
  
  <p>Is this possible to do in mysql?</p>