# -*- coding: utf-8 -*- import sqlite3 from contextlib import closing dbname = 'database.db' with closing(sqlite3.connect(dbname)) as conn: c = conn.cursor() # executeメソッドでSQL文を実行する create_table = '''create table users (id int, name varchar(64), age int, gender varchar(32))''' c.execute(create_table) # SQL文に値をセットする場合は,Pythonのformatメソッドなどは使わずに, # セットしたい場所に?を記述し,executeメソッドの第2引数に?に当てはめる値を # タプルで渡す.
![Pythonでsqlite - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/9658abeb0e1dc5a58e713a62d1c79e72fd02745d/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-1150d8b18a7c15795b701a55ae908f94.png%3Fixlib%3Drb-1.2.2%26w%3D1200%26mark%3Dhttps%253A%252F%252Fqiita-user-contents.imgix.net%252F~text%253Fixlib%253Drb-1.2.2%2526w%253D840%2526h%253D380%2526txt%253DPython%2525E3%252581%2525A7sqlite%2526txt-color%253D%252523333%2526txt-font%253DAvenir-Black%2526txt-size%253D54%2526txt-clip%253Dellipsis%2526txt-align%253Dcenter%25252Cmiddle%2526s%253D896bc295566b2fb6fc643552ebee40e1%26mark-align%3Dcenter%252Cmiddle%26blend%3Dhttps%253A%252F%252Fqiita-user-contents.imgix.net%252F~text%253Fixlib%253Drb-1.2.2%2526w%253D840%2526h%253D500%2526txt%253D%252540mas9612%2526txt-color%253D%252523333%2526txt-font%253DAvenir-Black%2526txt-size%253D45%2526txt-align%253Dright%25252Cbottom%2526s%253Dbac44eda6029ab89fb04a797882b0888%26blend-align%3Dcenter%252Cmiddle%26blend-mode%3Dnormal%26s%3D409d9b65a1ea681ca831384b3fe53f73)