{"image_url":null,"blog_url":"https://kagasu.hatenablog.com/","author_url":"https://blog.hatena.ne.jp/kagasu/","width":"100%","published":"2018-06-24 21:06:30","blog_title":"\u5099\u5fd8\u9332","type":"rich","description":"\u2160. \u306f\u3058\u3081\u306b Python \u306e sqlite3 \u306f\u6a19\u6e96\u30e9\u30a4\u30d6\u30e9\u30ea\u3067\u3059\u3002 pip\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u306f\u3042\u308a\u307e\u305b\u3093\u3002 \u2161. \u30b5\u30f3\u30d7\u30eb\u30d7\u30ed\u30b0\u30e9\u30e0 #!/usr/bin/env python3 # coding: utf-8 import sqlite3 conn = sqlite3.connect('main2.sqlite3') c = conn.cursor() # create table c.execute('create table `accounts` (`id` integer, `name` text)') # conn.commit() # insert data = [ (\u2026","provider_url":"https://hatena.blog","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkagasu.hatenablog.com%2Fentry%2F2018%2F06%2F24%2F210630\" title=\"Python\u3067SQLite\u3092\u4f7f\u3046\u65b9\u6cd5 - \u5099\u5fd8\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["Python","SQLite"],"author_name":"kagasu","height":"190","url":"https://kagasu.hatenablog.com/entry/2018/06/24/210630","provider_name":"Hatena Blog","title":"Python\u3067SQLite\u3092\u4f7f\u3046\u65b9\u6cd5"}