cvGMKU3g

1import sqlite3
2
3with sqlite3.connect("Quiz.db") as db:
4    cursor = db.cursor()
5    
6cursor.execute("""
7CREATE TABLE IF NOT EXISTS user(
8userID 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("""
16INSERT INTO user(username,firstname,surname,password)
17VALUES("test_user","bob","smith","mrbob")
18""")
19db.commit()
20
21cursor.execute("SELECT * FROM user")
22print(cursor.fetchall())
23
24