x5a41eVm

1import sqlite3
2
3with sqlite3.connect("Timetable.db") as db:
4    cursor = db.cursor()
5
6cursor.execute('''
7CREATE TABLE IF NOT EXISTS students(
8studentID INTEGER PRIMARY KEY,
9username VARCHAR(20) NOT NULL,
10firstname VARCHAR(20) NOT NULL,
11surname VARCHAR(20) NOT NULL,
12password VARCHAR(20) NOT NULL);
13''')
14
15cursor.execute("SELECT * FROM students")
16print(cursor.fetchall())