{"description":"MySQL\u3067JSON\u3092\u6271\u3046\u5165\u9580\u3068\u3057\u3066 \u524d\u56de\u306e\u65e5\u8a18 \u3067\u306f\u6bd4\u8f03\u7684\u30b7\u30f3\u30d7\u30eb\u306a\u95a2\u6570\u7fa4\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001JSON \u5185\u306e\u914d\u5217\u90e8\u5206\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u3057\u3066\u8fd4\u3059 JSON_TABLE \u95a2\u6570\u3092\u8a66\u3057\u3066\u307f\u307e\u3059\u3002 JSON_TABLE() \u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3002 JSON_TABLE()\u306f\u3001JSON\u5185\u306e\u914d\u5217\u90e8\u5206\u3092\u5f15\u6570\u306b\u4e0e\u3048\u3066\u3001\u305d\u306e\u914d\u5217\u5185\u306e\u8981\u7d20\u3092\u30c6\u30fc\u30d6\u30eb\u5f62\u5f0f\u306b\u3057\u3066\u8fd4\u3057\u3066\u304f\u308c\u308b\u95a2\u6570\u3067\u3059*1\u3002\u300c1\u500b\u306eJSON\u30c7\u30fc\u30bf\u300d\u304b\u3089\u8907\u6570\u306e\u884c\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002 \u4ee5\u4e0b\u306f\u3001JSON_TABLE()\u95a2\u6570\u306e\u7b2c\u4e00\u5f15\u6570\u306b\u751f\u306eJSON\u914d\u5217\u3092\u305d\u306e\u307e\u307e\u4e0e\u3048\u3066\u307f\u305f\u4f8b\u3067\u3059\u3002 mysql> SELECT * FROM JSON_TABLE('[ '> { '> \"D\u2026","type":"rich","height":"190","provider_name":"Hatena Blog","image_url":null,"blog_url":"https://sakaik.hateblo.jp/","blog_title":"sakaik\u306e\u65e5\u3005\u96d1\u611f\uff5e(T)\u7de8","url":"https://sakaik.hateblo.jp/entry/20220728/mysql_json_first_try_2","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsakaik.hateblo.jp%2Fentry%2F20220728%2Fmysql_json_first_try_2\" title=\"MySQL\u3067JSON\u4f53\u9a13\uff08\u305d\u306e2\uff1aJSON_TABLE\u3092\u4f7f\u3046\uff09 - sakaik\u306e\u65e5\u3005\u96d1\u611f\uff5e(T)\u7de8\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","version":"1.0","title":"MySQL\u3067JSON\u4f53\u9a13\uff08\u305d\u306e2\uff1aJSON_TABLE\u3092\u4f7f\u3046\uff09","width":"100%","author_url":"https://blog.hatena.ne.jp/sakaik/","author_name":"sakaik","categories":["mysql"],"published":"2022-07-28 22:12:39"}