1 Answer
20
import sqlite3
# Connect to database
conn = sqlite3.connect('database.db')
cursor = conn.cursor()
# Create table
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
email TEXT UNIQUE
)
''')
# Insert data
cursor.execute('INSERT INTO users (name, email) VALUES (?, ?)',
('John', 'john@example.com'))
conn.commit()
# Query data
cursor.execute('SELECT * FROM users')
rows = cursor.fetchall()
for row in rows:
print(row)
conn.close()
F
Silver
•
169 rep
Your Answer
You need to be logged in to answer questions.
Log In to Answer