{"width":"100%","author_name":"HTN20190109","height":"190","blog_title":"HTN20190109\u306e\u65e5\u8a18","type":"rich","blog_url":"https://htn20190109.hatenablog.com/","url":"https://htn20190109.hatenablog.com/entry/2023/02/19/024846","published":"2023-02-19 02:48:46","categories":["DB"],"image_url":null,"provider_url":"https://hatena.blog","version":"1.0","author_url":"https://blog.hatena.ne.jp/HTN20190109/","provider_name":"Hatena Blog","title":" JSON\u30c7\u30fc\u30bf\u3092\u6271\u3046","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","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>"}