1.SELECT
import sqlite3
conn = sqlite3.connect('example.db')
cur = conn.cursor()
cur.execute("SELECT * FROM stocks WHERE symbol = '%s'" % symbol)
data = cur.fetchall()
conn.close()
2.UPDATE
import sqlite3
conn = sqlite3.connect('example.db')
cur = conn.cursor()
cur.execute("update xxx")
conn.commit()
conn.close()