import sqlite3 as db

# Start a database connection.
conn = db.connect("example.db")

# Start a cursor called "cur"
#       This is going to help us insert and query in the DB
cur = conn.cursor()    

# First we drop the table students, if it exists. 
cur.execute("""DROP TABLE IF EXISTS students""")
conn.commit()

cur.execute("""CREATE TABLE students (
            student_id          INT,
            first               TEXT,
            last                TEXT,
            year                INT)""")

cur.execute("""INSERT INTO students VALUES (1234, "A", "B", 3)""")
conn.commit() 

cur.execute("""INSERT INTO students VALUES (2345, "C", "D", 2)""")
conn.commit() 

cur.execute("""INSERT INTO students VALUES (3456, "A", "F", 2)""")
conn.commit() 

cur.execute("""SELECT * FROM students;""")  
for row in cur:
    print (row)

conn.close()