title: Changing a row into a column in mysql
body: <p>I have a query in mysql which returns the following:</p>
  
  <pre><code>Amount1    Amount2    Amount3    
      0.1        0.3        0.6
  </code></pre>
  
  <p>I need the data in the following format:</p>
  
  <pre><code>Amount1   0.1
  Amount2   0.3
  Amount3   0.6
  </code></pre>
  
  <p>The query always return a single row with three columns. How can I change the format?</p>
  
  <p>Thanks</p>