python sqlite3 database
import sqlite3 # Create database conn = sqlite3.connect('tablename.db') c = conn.cursor() c.execute('''CREATE TABLE tablename(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, number REAL)''') conn.commit() conn.close() # Insert Values conn = sqlite3.connect('tablename.db') c = conn.cursor() c.execute("INSERT INTO tablename VALUES (?, ?)", (name, number)) conn.commit() conn.close() # Read Values conn = sqlite3.connect('tablename.db') c = conn.cursor() for row in c.execute('SELECT * FROM tablename'): print(row) number = [row[2] for row in c.execute('SELECT * FROM tablename')] conn.close()