duckdb_in_memory_connect_create_table_and_query.py

1import duckdb
2
3# Connect to an in-memory database
4con = duckdb.connect(database=':memory:')
5
6# Execute a query to create a table and insert data
7con.execute("CREATE TABLE items (item VARCHAR, value INTEGER)")
8con.execute("INSERT INTO items VALUES ('apple', 42), ('banana', 84)")
9
10# Query the database and fetch the result
11result = con.execute("SELECT * FROM items").fetchall()
12
13# Print the result
14print(result)