title: MySQL JSON object insert
body: <p>I have the following JSON:</p>
  
  <pre><code> {
      "params" : {
          "A" : 200.5,
          "B" : 70.2
      }
   }
  </code></pre>
  
  <p>And the following table:</p>
  
  <pre><code>CREATE TABLE `params` (
     `param` varchar(255),
     `value` float
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>Is there a way to make mysql function with one insert query without using "while do" directly to insert all the parameters into table like this:</p>
  
  <pre><code> -------+-------
  | param | value |
  |-------+-------|
  |     A |  200.5|
  |     B |   70.2|
   ---------------
  </code></pre>