title: How to insert JSON data into a dynamic column MySQL?
body: <p>Im simply trying to insert json data into a dynamic column. </p>
  
  <p>Data looks like follows:</p>
  
  <pre><code>"{"Fields": {
      "CompanyCode": "1",
      "FiscalYear": "2014",
      "CalYear": "2014",
      "CalPeriod": "1",
      "MinPostDate": "2014-01-14T00:00:00",
      "MaxPostDate": "2014-01-14T00:00:00",
      "CreditDebitInd": "H"
    }
  }"
  </code></pre>
  
  <p>Query is like this:</p>
  
  <pre><code> INSERT INTO jsontest (ID, Text) VALUES(DEFAULT, 'JsonHere');
  </code></pre>
  
  <p>ID is an ID which is the PK and it auto increments.
  Text is a BLOB</p>