#### 在MYSQL5.7以上，多了一個字段類型：json 原生的JSON優勢如下： 1. 存儲上類似text,可以存非常大的數據。 2. JSON有效性檢查：插入的數據必須是JSON類型的字符串才行。 3. 相比于傳統形式，不需要遍歷所有字符串才能找到數據。 4. 支持索引：通過虛擬列的功能可以對JSON中部分的數據進行索引。 建表 ~~~ CREATE TABLE json_test ( id INT (11) AUTO_INCREMENT PRIMARY KEY, person_desc JSON ) ENGINE INNODB; ~~~ 插入一條記錄： ~~~ INSERT INTO json_test(person_desc) VALUES ('{ "programmers": [{ "firstName": "Brett", "lastName": "McLaughlin", "email": "aaaa" }, { "firstName": "Jason", "lastName": "Hunter", "email": "bbbb" }, { "firstName": "Elliotte", "lastName": "Harold", "email": "cccc" }], "authors": [{ "firstName": "Isaac", "lastName": "Asimov", "genre": "sciencefiction" }, { "firstName": "Tad", "lastName": "Williams", "genre": "fantasy" }, { "firstName": "Frank", "lastName": "Peretti", "genre": "christianfiction" }], "musicians": [{ "firstName": "Eric", "lastName": "Clapton", "instrument": "guitar" }, { "firstName": "Sergei", "lastName": "Rachmaninoff", "instrument": "piano" }] }'); ~~~ 查看插入的這行JSON數據有哪些KEY： ~~~ SELECT id,json_keys(person_desc) as "keys" FROM json_test ~~~ ~~~ *************************** 1. row *************************** id: 1 keys: ["authors", "musicians", "programmers"] 1 row in set (0.00 sec) 可以看到里面有三個KEY，分別為authors，musicians，programmers。 ~~~