MySQL | JSON型の使い方(検索, 抽出, 挿入, 更新, 置換) - わくわくBank

INSERT INTO `json_users` VALUES ('{"name": "tanaka", "gender": 1, "options": {"x": 100, "y": 200}}'), ('{"name": "yamada", "gender": 2, "options": {"x": 300}}'), ('{"name": "suzuki", "gender": 1, "options": {"x": 100, "y": 200, "z": [1, 3, 4]}}'); mysql> INSERT INTO `json_users` -> VALUES -> ('{"name": "tanaka", "gender": 1, "options": {"x": 100, "y": 200}}'), -> ('{"name": "yamada", "gender": 2,

[tettekete37564]

しらそん