title: How to separate 1 record to multiple records?
body: <p>I want to use SQL to separate 1 record to multiple records</p>
  
  <p>Original Table:</p>
  
  <pre><code>+---------+------+------+------+
  | orderid | qty1 | qty2 | qty3 |
  +---------+------+------+------+
  | 1234    | 5    | 6    | 7    |
  +---------+------+------+------+
  </code></pre>
  
  <p>I want to split to :</p>
  
  <pre><code>+---------+------+------+------+
  | orderid | qty1 | qty2 | qty3 |
  +---------+------+------+------+
  | 1234    | 5    |      |      |
  +---------+------+------+------+
  | 1234    |      | 6    |      |
  +---------+------+------+------+
  | 1234    |      |      | 7    |
  +---------+------+------+------+
  </code></pre>
  
  <p>How to do this, please help me,thanks!</p>