title: pivot/unpivot tables mysql
body: <p>can you make pivot/unpivot in mysql similar to ms sql server?</p>
  
  <p>thanks</p>
  
  <p>Here's a link to how SQL Pivot works: <a href="http://technet.microsoft.com/en-us/library/ms177410.aspx" rel="nofollow noreferrer">link text</a></p>