title: I can't make a manually output of my table using mysql
body: <p>I have transactions table,</p>
  <pre><code>id transaction_date status
  1  2020-01-01       Shipped
  2  2020-02-01       Shipped
  3  2020-02-01       Cancelled
  </code></pre>
  <p>I wish to convert this like a pivot table in excel, so it looks like below</p>
  <pre><code>Date       SHIPPED CANCELLED PROCESSING
  2020-01-01 1       0         0
  2020-02-01 1       1         0
  </code></pre>
  <p>I'm completely clueless in approaching this. What function should I use?</p>