title: output content of a table as one line in mysql sql
body: <p>I need to output a purchase order into one line that has product and quantity of each product.</p>
  
  <p>say </p>
  
  <blockquote>
    <p>select product, quantity from order;</p>
  </blockquote>
  
  <p>outputs</p>
  
  <pre><code>product A , 2
  product B , 3
  product C , 7
  </code></pre>
  
  <p>I need the output to be in one line:</p>
  
  <pre><code>product A,2,product B,3,product C, 7
  </code></pre>
  
  <p>Can this be achieved using mysql sql ?</p>