{"width":"100%","image_url":null,"author_url":"https://blog.hatena.ne.jp/takuya_1st/","provider_name":"Hatena Blog","height":"190","blog_url":"https://takuya-1st.hatenablog.jp/","blog_title":"\u305d\u308c\u30de\u30b0\u3067\uff01","description":"mysql\u306a\u3089 show create table \u3092\u66f8\u3051\u3070\u3044\u3044\u3093\u3060\u3051\u3069\u3002SQLite\u3092\u4f7f\u3046\u3068\u305d\u308c\u304c\u3067\u304d\u306a\u3044\u3002\u56f0\u3063\u305f\u306e\u4f55\u3068\u304b\u3059\u308b\u3002 sqlite_master \u304b\u3089SELECT\u3059\u308b SELECT * from sqlite_master; master\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020 SQLITE\u306e\u30c6\u30fc\u30d6\u30eb\u7ba1\u7406\u30c6\u30fc\u30d6\u30eb\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3002 |type|name|tbl_name|rootpage|sql| type \u30c6\u30fc\u30d6\u30eb\u306a\u3089table \u3063\u3066\u66f8\u3044\u3066\u3042\u308b\u3002 name tbl_name \u540d\u524d table\u540d rootpage sql create table\u6587 \u95a2\u6570\u306b\u3057\u3066\u307f\u305f\u3002 <?php function get_c\u2026","type":"rich","title":"PDO\u306eSQLite\u3067\u30ab\u30e9\u30e0\u540d\u3084\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u53d6\u3063\u305f\u308a\u3059\u308b","version":"1.0","published":"2012-04-19 17:22:04","url":"https://takuya-1st.hatenablog.jp/entry/20120419/1334823724","categories":["php"],"provider_url":"https://hatena.blog","author_name":"takuya_1st","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftakuya-1st.hatenablog.jp%2Fentry%2F20120419%2F1334823724\" title=\"PDO\u306eSQLite\u3067\u30ab\u30e9\u30e0\u540d\u3084\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u53d6\u3063\u305f\u308a\u3059\u308b - \u305d\u308c\u30de\u30b0\u3067\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}