SQLLite
In [ ]:
import sqlite3
# Connecting to SQLite
conn = sqlite3.connect('example.db')
c = conn.cursor()
# Creating a table
c.execute('CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)')
# Inserting data
c.execute("INSERT INTO users (name, age) VALUES ('Alice', 25)")
conn.commit()
# Querying data
c.execute("SELECT * FROM users")
print(c.fetchall())
conn.close()
