# single cur.execute("INSERT INTO users (name, email) VALUES (?, ?)", ("Alice", "alice@example.com")) # multiple users = [("Bob","bob@example.com"), ("Eve","eve@example.com")] cur.executemany("INSERT INTO users (name, email) VALUES (?, ?)", users)
# Automatic commit/rollback with context manager def safe_insert_user(username, email, age): try: with conn: cursor.execute(''' INSERT INTO users (username, email, age) VALUES (?, ?, ?) ''', (username, email, age)) return True except sqlite3.IntegrityError as e: print(f"Error: e") return False sqlite3 tutorial query python fixed
SQLite3 comes built-in with Python. No additional installation needed! # single cur