{"height":"190","author_name":"devillikeaangel","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkkkw.hatenablog.jp%2Fentry%2Fmysql%2Fshow-engine-each-tables\" title=\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5404\u30c6\u30fc\u30d6\u30eb\u306e\u30a8\u30f3\u30b8\u30f3\u3092\u8868\u793a\u3059\u308b\u65b9\u6cd5 - kikukawa&#39;s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","url":"https://kkkw.hatenablog.jp/entry/mysql/show-engine-each-tables","description":"\u6bce\u56de\u8abf\u3079\u3066\u3044\u308b\u306e\u3067\u81ea\u5206\u7528\u30e1\u30e2 mysql> use information_schema; mysql> select table_name, engine from tables where table_schema = 'foo'; \u3064\u3044\u3067\u306b\u3001engine\u3092\u5909\u3048\u308balter\u6587 mysql> ALTER TABLE 'bar' ENGINE = InnoDB; foo\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d bar\u306f\u30c6\u30fc\u30d6\u30eb\u540d","provider_url":"https://hatena.blog","categories":["MySQL"],"title":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5404\u30c6\u30fc\u30d6\u30eb\u306e\u30a8\u30f3\u30b8\u30f3\u3092\u8868\u793a\u3059\u308b\u65b9\u6cd5","published":"2015-04-14 10:00:00","width":"100%","image_url":null,"blog_url":"https://kkkw.hatenablog.jp/","blog_title":"kikukawa's diary","author_url":"https://blog.hatena.ne.jp/devillikeaangel/","version":"1.0","type":"rich"}