· 4 years ago · Jan 10, 2021, 07:32 PM
1import sqlite3
2
3conn = sqlite3.connect('test.db')
4print("Opened database successfully");
5
6conn.execute('''
7CREATE TABLE IF NOT EXISTS team_data(team text,
8 country text,
9 season integer,
10 total_goals integer);''')
11
12conn.commit()
13
14print("Table created successfully");
15