title: SQL Insert JSON into table column
body: <p>while searching for a way to insert array into single db columns, I found an article about inserting JSON string. However it wasn't explained how. I tried to search and find the way with no success.</p>
  <p><strong>I have the following table:</strong></p>
  <pre><code>+---------+----------------+----+
  |  Name   |      Type      |    |
  +---------+----------------+----+
  | id      | int            | AI |
  | name    | String         |    |
  | address | JSON(longtext) |    |
  +---------+----------------+----+
  </code></pre>
  <p>What i want to do is insert a Json arry in the <code>address</code> column. like:</p>
  <pre><code>+----+-----------+------------------------------------------+
  | id |   name    |                 address                  |
  +----+-----------+------------------------------------------+
  |  1 | User name | [{street: &quot;street address&quot;, city: &quot;Berlin&quot;}] |
  +----+-----------+------------------------------------------+
  </code></pre>
  <p>I thought about inserting the JSON as String but im not sure if this a good idea. Any suggestions?</p>