Python SQLite Module
SQLite database — connect, execute, commit, fetchone, fetchall, Row. This category documents 15 Python sqlite module entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example. The entries include: sqlite3.connect(), sqlite3.Connection.execute(), sqlite3.Connection.cursor(), sqlite3.Cursor.execute(), sqlite3.Cursor.executemany(), sqlite3.Cursor.fetchone(), sqlite3.Cursor.fetchall(), sqlite3.Cursor.fetchmany(), sqlite3.Connection.commit(), sqlite3.Connection.rollback(), sqlite3.Connection.close(), sqlite3.Row, sqlite3.Connection.executescript(), sqlite3.Connection.total_changes(), sqlite3.Cursor.description. sqlite3.connect() connects to an SQLite database file (or creates it). Returns a Connection object. sqlite3.Connection.execute() executes a single SQL statement and returns a Cursor. sqlite3.Connection.cursor() creates a Cursor object for database operations. sqlite3.Cursor.execute() executes a SQL statement with optional parameter substitution. sqlite3.Cursor.executemany() executes a SQL statement against all parameter sequences. You can also search across every category from the search page, browse the complete A–Z index, or try any example in the Python playground.