title: How to split JSON file into multiple rows in SQL
body: <p>Suppose now i have some table</p>
  <pre class="lang-none prettyprint-override"><code>studentId studentScore ScoreDetail     StudentName Phone  classId Subject     
  1          50          (a json value)  Doe         911    01      math
  </code></pre>
  <p>the json file is like</p>
  <pre><code>{
    &quot;DetailList&quot;: [
      {
        &quot;source&quot;: &quot;homework&quot;,
        &quot;count&quot;: 30,
        &quot;user_id&quot;: 1,
        &quot;order_id&quot;: &quot;: 0
      },
      {
        &quot;source&quot;: &quot;homework&quot;,
        &quot;count&quot;: 20,
        &quot;user_id&quot;: 1,
        &quot;order_id&quot;: &quot;: 0&quot;
      }
    ],
    &quot;TotalScoreCount&quot;: 50
  }
  </code></pre>
  <p>How do i make it into this</p>
  <pre class="lang-none prettyprint-override"><code>studentId   Score  ScoreSource  StudentName Phone  classId Subject
      1         30     homework       Doe       911    01      math
      1         20     homework       Doe       911    01      math
  ...
  </code></pre>
  <p>Let's say i have 10 student</p>