· 6 years ago · Jun 05, 2019, 02:48 AM
1import sqlite3
2
3connection = sqlite3.connect('data.db')
4
5cursor = connection.cursor()
6
7create_table = "CREATE TABLE IF NOT EXISTS items (name text PRIMARY KEY, price real)"
8cursor.execute(create_table)
9
10connection.commit()
11
12connection.close()