title: Update mysql table using data from json file
body: <p>I am complete new to json and thefore struggling to work with.</p>
  
  <p>I have a list of id's stored in a id field of a mysql table.</p>
  
  <p>For example id field contains these values</p>
  
  <ol>
  <li>100001</li>
  <li>100002</li>
  <li>100003</li>
  </ol>
  
  <p>The json file containes properties of these id's, like this.</p>
  
  <pre><code>{"100001":{"person":{"name":"John","age":"32,"address":"123 street"}},
  {"100002":{"person":{"name":"jenny","age":"22,"address":"100 street"}},
  {"100003":{"person":{"name":"james","age":"25,"address":"200 street"}}
  </code></pre>
  
  <p>My intention is to update the name, age and address fields in the mysql table with the data in json file using the id as a conditon in the where clause.</p>
  
  <p>But I have no idea where to even start. </p>
  
  <p>Can someone who know's what they doing, please direct me.</p>
  
  <p>Thanks in advance.</p>