· 10 years ago · Sep 10, 2016, 08:30 PM
1import sqlite3
2
3conn = sqlite3.connect("test.sqlite3")
4conn.execute("""
5create table if not exists hello (
6 id integer primary key autoincrement,
7 name varchar(100)
8)
9""")
10
11conn.execute("""
12insert into hello ( name ) values (
13"A NAME!"
14);
15""")
16conn.commit()
17
18cursor = conn.execute("""
19select * from hello;
20""")
21
22for r in cursor.fetchall():
23 print r