title: MySQL 5.7 JSON column update
body: <p>I am using MySQL 5.7. I have a table with a JSON column.</p>
  
  <pre><code>MySQL [test_db]&gt; select * from mytable;
  +----+-------+---------------------+
  | id | name  | hobby               |
  +----+-------+---------------------+
  |  1 | Rahul | {"Game": "Cricket"} |
  |  2 | Sam   | null                |
  +----+-------+---------------------+
  </code></pre>
  
  <p>Here, for row id = 2, I want to insert a data. I did -</p>
  
  <pre><code>update mytable set hobby = JSON_SET(hobby, '$.Game', 'soccer') where id = 2;
  Query OK, 1 row affected (0.01 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  </code></pre>
  
  <p>It seems like data inserted properly, But when I checked </p>
  
  <pre><code>MySQL [test_db]&gt; select * from mytable;
  +----+-------+---------------------+
  | id | name  | hobby               |
  +----+-------+---------------------+
  |  1 | Rahul | {"Game": "Cricket"} |
  |  2 | Sam   | null                |
  +----+-------+---------------------+
  </code></pre>
  
  <p>data is not inserted, Can anybody give some hint, what I am missing here.</p>
  
  <p>Thanks.</p>