p261

use sqldb;
select json_object('name', name, 'height', height) AS 'json 값'
    from usertbl
    where height >= 180;

SET @json = 
'{ "usertbl" :
 [
    {"name" : "임재범", "hegiht" : 182},
    {"name" : "이승기", "hegiht" : 182},
    {"name" : "성시경", "hegiht" : 186}
 ]
}';    
SELECT JSON_VALID(@json);
SELECT JSON_SEARCH(@json, 'one', '성시경');
SELECT JSON_EXTRACT(@json, '$.userTBL[2].name');
SELECT JSON_INSERT(@json, '$.userTBL[0].mDate', '2009-09-09');
SELECT JSON_REPLACE(@json, '$.userTBL[0].name', '홍길동');
SELECT JSON_REMOVE(@json, '$.userTBL[0]');

 ??