sqlite3_database_quickstart_create_table_insert_query.py

1import sqlite3
2
3# Connect to a database (or create one if it doesn't exist)
4con = sqlite3.connect("tutorial.db")
5
6# Create a cursor object to execute SQL commands
7cur = con.cursor()
8
9# Create a table
10cur.execute("CREATE TABLE movie(title, year, score)")
11
12# Insert data into the table
13cur.execute("""
14    INSERT INTO movie VALUES
15        ('Monty Python and the Holy Grail', 1975, 8.2),
16        ('And Now for Something Completely Different', 1971, 7.5)
17""")
18
19# Save (commit) the changes
20con.commit()
21
22# Query the database
23res = cur.execute("SELECT score FROM movie")
24print(res.fetchone())
25
26# Close the connection
27con.close()