# Create SQLite Database
import sqlite3
db = sqlite3.connect('student.db')
# Create Table
#db.execute('CREATE TABLE student (name text, id int)')
#db.commit()
# Insert Data
#db.execute('INSERT INTO student (name,id) values (?,?)',('Ryan',1001))
#db.execute('INSERT INTO student (name,id) values (?,?)',('Janic',2001))
#db.execute('INSERT INTO student (name,id) values (?,?)',('Janiccc',2003))
#db.commit()
# Read Data
list = db.execute('SELECT * FROM student ORDER BY id')
for i in list:
print(i)
# Update Data
#db.execute('UPDATE student SET name=? WHERE id=?',('Janice',2001))
#db.commit()
# Delete Data
#db.execute('DELETE FROM student WHERE id = 2003’)
#db.commit()
# Drop Table
#db.execute('DROP TABLE student_info')
#db.commit()