pip install sqlite3
import sqlite3
conn = sqlite3.connect('university.db')
c = conn.cursor()
c.execute('''CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER,
major TEXT
);''')
conn.commit()
conn.close()
def add_student(name, age, major):
conn = sqlite3.connect('university.db')
c = conn.cursor()
c.execute("INSERT INTO students (name, age, major) VALUES (?, ?, ?)", (name, age, major))
conn.commit()
conn.close()
add_student('Alice', 22, 'Computer Science')
add_student('Bob', 23, 'Physics')
def get_student_by_major(major):
conn = sqlite3.connect('university.db')
c = conn.cursor()
c.execute("SELECT * FROM students WHERE major=?", (major,))
rows = c.fetchall()
for row in rows:
print(row)
conn.close()
get_student_by_major('Computer Science')
