{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2022%2F01%2F09%2F024720\" title=\"\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u8907\u5408\u578b\u914d\u5217 - 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>","blog_url":"https://htn20190109.hatenablog.com/","url":"https://htn20190109.hatenablog.com/entry/2022/01/09/024720","description":"MySQL (8.0.26)\u914d\u5217\u306f\u306a\u3044\u6a21\u69d8\u306e\u305f\u3081\u3001\u30c6\u30f3\u30dd\u30e9\u30ea\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u7528\u3059\u308b drop procedure proc1;delimiter //create procedure proc1()begin drop temporary table if exists ar1; create temporary table if not exists ar1(col1 int,col2 varchar(1000) ); insert into ar1 values(100,'AAA'); insert into ar1 values(200,'BBB'); select * from ar1; \u2026","published":"2022-01-09 02:47:20","author_name":"HTN20190109","width":"100%","height":"190","version":"1.0","categories":["DB"],"provider_name":"Hatena Blog","image_url":null,"provider_url":"https://hatena.blog","type":"rich","blog_title":"HTN20190109\u306e\u65e5\u8a18","author_url":"https://blog.hatena.ne.jp/HTN20190109/","title":"\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u8907\u5408\u578b\u914d\u5217"}