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()