{"width":"100%","blog_url":"https://coffee-guhaw.hateblo.jp/","published":"2025-07-18 00:00:00","author_name":"coffee_kabu","provider_name":"Hatena Blog","type":"rich","blog_title":"Bus error\u3068Segmentation fault\u306b\u56f0\u3063\u305f\u3089\u898b\u308b\u30d6\u30ed\u30b0","provider_url":"https://hatena.blog","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcoffee-guhaw.hateblo.jp%2Fentry%2F2025%2F07%2F18%2F000000\" title=\"\u3010python3\u3011\u65e2\u5b58\u306esqlite3\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092python3\u3067\u8aad\u307f\u8fbc\u3080 - Bus error\u3068Segmentation fault\u306b\u56f0\u3063\u305f\u3089\u898b\u308b\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://coffee-guhaw.hateblo.jp/entry/2025/07/18/000000","categories":["python"],"image_url":null,"author_url":"https://blog.hatena.ne.jp/coffee_kabu/","height":"190","title":"\u3010python3\u3011\u65e2\u5b58\u306esqlite3\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092python3\u3067\u8aad\u307f\u8fbc\u3080","description":"\u307e\u305a\u306f\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u53d6\u5f97\u3059\u308b teminal\u3067sqlite3 something.db sqlite> .table\u3067\u8868\u793a\u3059\u308b\u306e\u304c\u901a\u5e38\u306e\u65b9\u6cd5python\u3060\u3051\u3067\u3082\u30c6\u30fc\u30d6\u30eb\u540d\u306f\u898b\u308c\u308b\u25a0 \u53c2\u8003 : python\u3067sqlite\u306e\u30c6\u30fc\u30d6\u30eb\u540d\u53d6\u5f97import sqlite3 filepath=\"something.db\" conn = sqlite3.connect(filepath) cur = conn.cursor()# table\u4e00\u89a7\u3092\u53d6\u5f97\u3059\u308b tables=[] cur.execute(\"select name from sqlite_master where type='table'\") for\u2026"}