title: Reforming table structure of columns possible?
body: <p>I have bee at this all day. I have played around with a lot of MySQL code and I am either inept, or not very good at coding.. </p>
  
  <p><strong>I have a table</strong></p>
  
  <pre><code>name     id       type      amount
  =================================
  apple    21       cars      67
  apple    21       bikes     85
  apple    21       skates    557
  apple    21       pajs      56
  orange   34       bikes     345
  orange   34       disks     678
  orange   34       cars      234
  orange   34       pajs      5678
  </code></pre>
  
  <p><strong>I want to write a query that will bring back the table in this form</strong></p>
  
  <pre><code>name    id cars bikes skates pajas disks
  =========================================
  apple   21 67   85    557    56    0    
  orange  34 234  345   0      5678  678
  </code></pre>
  
  <p>I really just have no clue where to start. Sorry if this is noobie question but MySQL is really hard to conceptualize sometimes.</p>