ptYxxDW9

1import sqlite3
2
3
4conn = sqlite3.connect('users.db')
5
6c = conn.cursor()
7
8c.execute('''
9CREATE TABLE IF NOT EXISTS User(
10findex int primary key,
11username text,
12email text,
13preference text)
14''')
15
16findex = 3
17username = "dichong"
18email = "dichong@gmail.com"
19preference = "111111"
20
21c.execute('''
22INSERT INTO User(findex,username,email,preference)VALUES(?,?,?,?)
23''',(findex,username,email,preference))
24
25t = (3,)
26c.execute('SELECT * FROM User WHERE findex=?',t)
27
28print(c.fetchone())
29
30conn.commit()
31conn.close()