· 6 years ago · Nov 21, 2019, 01:12 AM
1import sqlite3
2
3conn = sqlite3.connect("computer_cards.db")
4
5create_sql = "CREATE TABLE IF NOT EXISTS first (player1, player2)"
6conn.execute(create_sql)
7conn.commit
8
9insert_sql = "INSERT INTO first(player1, player2) VALUES ('{}','{}')".\
10 format('Joe','')
11conn.execute(insert_sql)
12conn.commit
13
14res = conn.execute("SELECT * FROM first")
15res_list = res.fetchall()
16print(res_list)
17
18conn.close()