{"provider_name":"Hatena Blog","version":"1.0","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2023%2F02%2F19%2F024846\" title=\" JSON\u30c7\u30fc\u30bf\u3092\u6271\u3046 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","width":"100%","blog_title":"HTN20190109\u306e\u65e5\u8a18","type":"rich","published":"2023-02-19 02:48:46","title":" JSON\u30c7\u30fc\u30bf\u3092\u6271\u3046","image_url":null,"url":"https://htn20190109.hatenablog.com/entry/2023/02/19/024846","author_url":"https://blog.hatena.ne.jp/HTN20190109/","author_name":"HTN20190109","categories":["DB"],"blog_url":"https://htn20190109.hatenablog.com/","description":"MySQL (8.0.31)http://atudc.blogspot.com/2018/09/rdbmsoraclesql-servermysqljson.html -- 1. \u30c6\u30b9\u30c8\u30c6\u30fc\u30d6\u30eb\u3068\u30c7\u30fc\u30bf\u4f5c\u6210 drop table tab1; create table tab1 ( col1 bigint, col2 json, constraint tab1pk primary key (col1)); insert into tab1 values (1,'{ \"col21\" : 1, \"col22\" : \"A\", \"col23\" : [{\"col231\" : \"123\", \"col232\"\u2026"}