René's URL Explorer Experiment


Title: sqlite3 --- SQLite 資料庫的 DB-API 2.0 介面 — Python 3.14.0 說明文件

direct link

Domain: python.github.io

readthedocs-addons-api-version1

Links:

https://www.python.org/
目錄https://python.github.io/python-docs-zh-tw/contents.html
sqlite3 --- SQLite 資料庫的 DB-API 2.0 介面https://python.github.io/python-docs-zh-tw/library/sqlite3.html
教學https://python.github.io/python-docs-zh-tw/library/sqlite3.html#tutorial
Referencehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#reference
Module functionshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-functions
Module constantshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-constants
Connection 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#connection-objects
Cursor 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#cursor-objects
Row 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#row-objects
Blob 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#blob-objects
PrepareProtocol 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#prepareprotocol-objects
例外https://python.github.io/python-docs-zh-tw/library/sqlite3.html#exceptions
SQLite and Python typeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite-and-python-types
Default adapters and converters (deprecated)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#default-adapters-and-converters-deprecated
命令列介面https://python.github.io/python-docs-zh-tw/library/sqlite3.html#command-line-interface
How-to guideshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-guides
How to use placeholders to bind values in SQL querieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries
How to adapt custom Python types to SQLite valueshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-adapt-custom-python-types-to-sqlite-values
How to write adaptable objectshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-write-adaptable-objects
How to register adapter callableshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-register-adapter-callables
How to convert SQLite values to custom Python typeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-convert-sqlite-values-to-custom-python-types
Adapter and converter recipeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#adapter-and-converter-recipes
How to use connection shortcut methodshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-connection-shortcut-methods
How to use the connection context managerhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-the-connection-context-manager
How to work with SQLite URIshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-work-with-sqlite-uris
How to create and use row factorieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-create-and-use-row-factories
如何處理非 UTF-8 的文字編碼https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-handle-non-utf-8-text-encodings
解釋https://python.github.io/python-docs-zh-tw/library/sqlite3.html#explanation
Transaction controlhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control
Transaction control via the autocommit attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control-via-the-autocommit-attribute
Transaction control via the isolation_level attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control-via-the-isolation-level-attribute
dbm --- Unix "databases" 的介面https://python.github.io/python-docs-zh-tw/library/dbm.html
資料壓縮與保存https://python.github.io/python-docs-zh-tw/library/archiving.html
回報錯誤https://python.github.io/python-docs-zh-tw/bugs.html
顯示原始碼 https://github.com/python/cpython/blob/main/Doc/library/sqlite3.rst?plain=1
索引https://python.github.io/python-docs-zh-tw/genindex.html
模組https://python.github.io/python-docs-zh-tw/py-modindex.html
下一頁https://python.github.io/python-docs-zh-tw/library/archiving.html
上一頁https://python.github.io/python-docs-zh-tw/library/dbm.html
Pythonhttps://www.python.org/
3.14.0 Documentationhttps://python.github.io/python-docs-zh-tw/index.html
Python 標準函式庫 (Standard Library)https://python.github.io/python-docs-zh-tw/library/index.html
資料持久性 (Data Persistence)https://python.github.io/python-docs-zh-tw/library/persistence.html
sqlite3 --- SQLite 資料庫的 DB-API 2.0 介面https://python.github.io/python-docs-zh-tw/library/sqlite3.html
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-sqlite3
Lib/sqlite3/https://github.com/python/cpython/tree/3.14/Lib/sqlite3/
PEP 249https://peps.python.org/pep-0249/
SQLitehttps://sqlite.org/
optional modulehttps://python.github.io/python-docs-zh-tw/glossary.html#term-optional-module
可選模組的需求https://python.github.io/python-docs-zh-tw/using/configure.html#optional-module-requirements
教學https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-tutorial
Referencehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-reference
How-to guideshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howtos
解釋https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-explanation
https://www.sqlite.orghttps://www.sqlite.org
https://www.w3schools.com/sql/https://www.w3schools.com/sql/
PEP 249https://peps.python.org/pep-0249/
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#tutorial
cursorshttps://en.wikipedia.org/wiki/Cursor_(databases)
transactionshttps://en.wikipedia.org/wiki/Database_transaction
sqlite3.connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
con.cursor()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.cursor
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
flexible typinghttps://www.sqlite.org/flextypegood.html
cur.execute(...)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
The Schema Tablehttps://www.sqlite.org/schematab.html
cur.execute(...)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
res.fetchone()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchone
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
cur.execute(...)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
Transaction controlhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-controlling-transactions
con.commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
cur.execute(...)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
res.fetchall()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchall
listhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#list
cur.executemany(...)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executemany
string formattinghttps://python.github.io/python-docs-zh-tw/tutorial/inputoutput.html#tut-formatting
SQL injection attackshttps://en.wikipedia.org/wiki/SQL_injection
How to use placeholders to bind values in SQL querieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
con.close()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.close
How-to guideshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howtos
How to use placeholders to bind values in SQL querieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
How to adapt custom Python types to SQLite valueshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-adapters
How to convert SQLite values to custom Python typeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-converters
How to use the connection context managerhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-connection-context-manager
How to create and use row factorieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-row-factory
解釋https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-explanation
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#reference
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-functions
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
path-like objecthttps://python.github.io/python-docs-zh-tw/glossary.html#term-path-like-object
SQLite database existing only in memoryhttps://sqlite.org/inmemorydb.html
floathttps://python.github.io/python-docs-zh-tw/library/functions.html#float
OperationalErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.OperationalError
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
natively supported by SQLitehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
register_converter()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.register_converter
PARSE_DECLTYPEShttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
PARSE_COLNAMEShttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_COLNAMES
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
Connection.isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
Transaction control via the isolation_level attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-isolation-level
Connection.autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
threadsafetyhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.threadsafety
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
How to work with SQLite URIshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-uri-tricks
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
PEP 249https://peps.python.org/pep-0249/
Connection.autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
Transaction control via the autocommit attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
稽核事件https://python.github.io/python-docs-zh-tw/library/sys.html#auditing
稽核事件https://python.github.io/python-docs-zh-tw/library/sys.html#auditing
path-like objecthttps://python.github.io/python-docs-zh-tw/glossary.html#term-path-like-object
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.complete_statement
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
Lib/sqlite3/__main__.pyhttps://github.com/python/cpython/tree/3.14/Lib/sqlite3/__main__.py
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.enable_callback_tracebacks
sys.stderrhttps://python.github.io/python-docs-zh-tw/library/sys.html#sys.stderr
unraisable hook handlerhttps://python.github.io/python-docs-zh-tw/library/sys.html#sys.unraisablehook
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.register_adapter
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
type that SQLite natively understandshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.register_converter
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-constants
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
Transaction control via the isolation_level attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-isolation-level
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
PARSE_COLNAMEShttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_COLNAMES
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_COLNAMES
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
PARSE_DECLTYPEShttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_OK
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DENY
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_IGNORE
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
Connection.set_authorizer()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.set_authorizer
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.apilevel
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.paramstyle
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.sqlite_version
stringhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.sqlite_version_info
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
integershttps://python.github.io/python-docs-zh-tw/library/functions.html#int
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.threadsafety
threading modehttps://sqlite.org/threadsafe.html
執行緒安全https://peps.python.org/pep-0249/#threadsafety
SQLITE_THREADSAFEhttps://sqlite.org/compile.html#threadsafe
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_DEFENSIVE
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_DQS_DDL
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_DQS_DML
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_FKEY
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_QPSG
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_TRIGGER
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_ENABLE_VIEW
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_RESET_DATABASE
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_TRIGGER_EQP
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_TRUSTED_SCHEMA
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DBCONFIG_WRITABLE_SCHEMA
Connection.setconfig()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.setconfig
getconfig()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.getconfig
https://www.sqlite.org/c3ref/c_dbconfig_defensive.htmlhttps://www.sqlite.org/c3ref/c_dbconfig_defensive.html
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#connection-objects
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
sqlite3.connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
Transaction controlhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-controlling-transactions
How to use connection shortcut methodshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-connection-shortcuts
How to use the connection context managerhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-connection-context-manager
ResourceWarninghttps://python.github.io/python-docs-zh-tw/library/exceptions.html#ResourceWarning
close()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.close
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.cursor
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.blobopen
Blobhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
OperationalErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.OperationalError
Blobhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob
Blobhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.rollback
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.close
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.execute
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.executemany
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
executemany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executemany
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.executescript
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
executescript()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executescript
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.create_function
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
callbackhttps://python.github.io/python-docs-zh-tw/glossary.html#term-callback
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
a type natively supported by SQLitehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
deterministichttps://sqlite.org/deterministic.html
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.create_aggregate
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
classhttps://python.github.io/python-docs-zh-tw/glossary.html#term-class
a type natively supported by SQLitehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.create_window_function
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
classhttps://python.github.io/python-docs-zh-tw/glossary.html#term-class
a type natively supported by SQLitehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
NotSupportedErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.NotSupportedError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.create_collation
stringhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
integerhttps://python.github.io/python-docs-zh-tw/library/functions.html#int
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.interrupt
OperationalErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.OperationalError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.set_authorizer
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
SQLITE_OKhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_OK
SQLITE_DENYhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_DENY
SQLITE_IGNOREhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.SQLITE_IGNORE
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.set_progress_handler
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.set_trace_callback
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
Cursor.execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
transaction managementhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-controlling-transactions
enable_callback_tracebacks()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.enable_callback_tracebacks
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.enable_load_extension
--enable-loadable-sqlite-extensionshttps://python.github.io/python-docs-zh-tw/using/configure.html#cmdoption-enable-loadable-sqlite-extensions
稽核事件https://python.github.io/python-docs-zh-tw/library/sys.html#auditing
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.load_extension
enable_load_extension()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.enable_load_extension
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
Loading an Extensionhttps://www.sqlite.org/loadext.html#loading_an_extension
稽核事件https://python.github.io/python-docs-zh-tw/library/sys.html#auditing
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.iterdump
iteratorhttps://python.github.io/python-docs-zh-tw/glossary.html#term-iterator
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
如何處理非 UTF-8 的文字編碼https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-encoding
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.backup
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
callbackhttps://python.github.io/python-docs-zh-tw/glossary.html#term-callback
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
floathttps://python.github.io/python-docs-zh-tw/library/functions.html#float
如何處理非 UTF-8 的文字編碼https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-encoding
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.getlimit
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
SQLite limit categoryhttps://www.sqlite.org/c3ref/c_limit_attached.html
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.setlimit
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
SQLite limit categoryhttps://www.sqlite.org/c3ref/c_limit_attached.html
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.getconfig
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
SQLITE_DBCONFIG codehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-dbconfig-constants
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.setconfig
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
SQLITE_DBCONFIG codehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-dbconfig-constants
boolhttps://python.github.io/python-docs-zh-tw/library/functions.html#bool
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.serialize
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.deserialize
serializedhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.serialize
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
OperationalErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.OperationalError
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
OverflowErrorhttps://python.github.io/python-docs-zh-tw/library/exceptions.html#OverflowError
len(data)https://python.github.io/python-docs-zh-tw/library/functions.html#len
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
PEP 249https://peps.python.org/pep-0249/
PEP 249https://peps.python.org/pep-0249/
commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
rollback()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.rollback
autocommit modehttps://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
rollback()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.rollback
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
PEP 249https://peps.python.org/pep-0249/
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
Transaction control via the autocommit attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-autocommit
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.in_transaction
autocommit modehttps://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
legacy transaction handling modehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-isolation-level
SQLite transaction behaviourhttps://www.sqlite.org/lang_transaction.html#deferred_immediate_and_exclusive_transactions
implicit transaction managementhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-isolation-level
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.row_factory
row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.row_factory
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
How to create and use row factorieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-row-factory
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.text_factory
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
如何處理非 UTF-8 的文字編碼https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-encoding
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.total_changes
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#cursor-objects
database cursorhttps://en.wikipedia.org/wiki/Cursor_(databases)
Connection.cursor()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.cursor
connection shortcut methodshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-connection-shortcuts
iteratorshttps://python.github.io/python-docs-zh-tw/glossary.html#term-iterator
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
placeholdershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
sequencehttps://python.github.io/python-docs-zh-tw/glossary.html#term-sequence
How to use placeholders to bind values in SQL querieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
named placeholdershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
named placeholdershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
executescript()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executescript
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executemany
parameterizedhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
iterablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-iterable
How to use placeholders to bind values in SQL querieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
named placeholdershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
RETURNING clauseshttps://www.sqlite.org/lang_returning.html
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
named placeholdershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-placeholders
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executescript
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
stringhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchone
row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.row_factory
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchmany
listhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#list
arraysizehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.arraysize
fetchmany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchmany
ValueErrorhttps://python.github.io/python-docs-zh-tw/library/exceptions.html#ValueError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchall
listhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#list
arraysizehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.arraysize
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.close
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.setinputsizes
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.setoutputsize
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.arraysize
fetchmany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.fetchmany
ValueErrorhttps://python.github.io/python-docs-zh-tw/library/exceptions.html#ValueError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.connection
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
con.cursor()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.cursor
connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.connection
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.description
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.lastrowid
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
executemany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executemany
executescript()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executescript
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.rowcount
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
executemany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executemany
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.row_factory
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
sqlite3.Rowhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Row
callablehttps://python.github.io/python-docs-zh-tw/glossary.html#term-callable
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
Connection.row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.row_factory
Connection.row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.row_factory
How to create and use row factorieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-row-factory
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#row-objects
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Row
row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.row_factory
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
len()https://python.github.io/python-docs-zh-tw/library/functions.html#len
mappinghttps://python.github.io/python-docs-zh-tw/glossary.html#term-mapping
How to create and use row factorieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-howto-row-factory
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Row.keys
listhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#list
stringshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
Cursor.descriptionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.description
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#blob-objects
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob
Blobhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob
file-like objecthttps://python.github.io/python-docs-zh-tw/glossary.html#term-file-like-object
len(blob)https://python.github.io/python-docs-zh-tw/library/functions.html#len
sliceshttps://python.github.io/python-docs-zh-tw/glossary.html#term-slice
Blobhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob
context managerhttps://python.github.io/python-docs-zh-tw/glossary.html#term-context-manager
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob.close
Errorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Error
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob.read
read()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob.read
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob.write
ValueErrorhttps://python.github.io/python-docs-zh-tw/library/exceptions.html#ValueError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob.tell
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Blob.seek
os.SEEK_SEThttps://python.github.io/python-docs-zh-tw/library/os.html#os.SEEK_SET
os.SEEK_CURhttps://python.github.io/python-docs-zh-tw/library/os.html#os.SEEK_CUR
os.SEEK_ENDhttps://python.github.io/python-docs-zh-tw/library/os.html#os.SEEK_END
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#prepareprotocol-objects
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PrepareProtocol
PEP 246https://peps.python.org/pep-0246/
adapt themselveshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-conform
native SQLite typeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#exceptions
PEP 249https://peps.python.org/pep-0249/
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Warning
Exceptionhttps://python.github.io/python-docs-zh-tw/library/exceptions.html#Exception
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Error
excepthttps://python.github.io/python-docs-zh-tw/reference/compound_stmts.html#except
Exceptionhttps://python.github.io/python-docs-zh-tw/library/exceptions.html#Exception
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Error.sqlite_errorcode
SQLite APIhttps://sqlite.org/rescode.html
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Error.sqlite_errorname
SQLite APIhttps://sqlite.org/rescode.html
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.InterfaceError
Errorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Error
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
Errorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Error
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DataError
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.OperationalError
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.IntegrityError
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.InternalError
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.NotSupportedError
create_function()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.create_function
DatabaseErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.DatabaseError
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite-and-python-types
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
floathttps://python.github.io/python-docs-zh-tw/library/functions.html#float
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
inthttps://python.github.io/python-docs-zh-tw/library/functions.html#int
floathttps://python.github.io/python-docs-zh-tw/library/functions.html#float
text_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.text_factory
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
object adaptershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-adapters
convertershttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-converters
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#default-adapters-and-converters-deprecated
Adapter and converter recipeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-adapter-converter-recipes
datetime.datehttps://python.github.io/python-docs-zh-tw/library/datetime.html#datetime.date
stringshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
ISO 8601https://en.wikipedia.org/wiki/ISO_8601
datetime.datetimehttps://python.github.io/python-docs-zh-tw/library/datetime.html#datetime.datetime
declaredhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-converters
datetime.datehttps://python.github.io/python-docs-zh-tw/library/datetime.html#datetime.date
datetime.datetimehttps://python.github.io/python-docs-zh-tw/library/datetime.html#datetime.datetime
datetime.datetimehttps://python.github.io/python-docs-zh-tw/library/datetime.html#datetime.datetime
register_converter()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.register_converter
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#command-line-interface
-mhttps://python.github.io/python-docs-zh-tw/using/cmdline.html#cmdoption-m
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#cmdoption-python-m-sqlite3-h-v-filename-sql-h
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#cmdoption-python-m-sqlite3-h-v-filename-sql-v
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-guides
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries
SQL injection attackshttps://en.wikipedia.org/wiki/SQL_injection
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
sequencehttps://python.github.io/python-docs-zh-tw/glossary.html#term-sequence
ProgrammingErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.ProgrammingError
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
PEP 249https://peps.python.org/pep-0249/
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-adapt-custom-python-types-to-sqlite-values
Python types SQLite natively understandshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-types
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-write-adaptable-objects
PrepareProtocolhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PrepareProtocol
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-register-adapter-callables
register_adapter()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.register_adapter
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-convert-sqlite-values-to-custom-python-types
byteshttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#bytes
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
PARSE_DECLTYPEShttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_DECLTYPES
PARSE_COLNAMEShttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.PARSE_COLNAMES
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#adapter-and-converter-recipes
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-connection-shortcut-methods
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.execute
executemany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.executemany
executescript()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.executescript
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-the-connection-context-manager
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
withhttps://python.github.io/python-docs-zh-tw/reference/compound_stmts.html#with
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
contextlib.closing()https://python.github.io/python-docs-zh-tw/library/contextlib.html#contextlib.closing
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-work-with-sqlite-uris
OperationalErrorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.OperationalError
SQLite URI documentationhttps://www.sqlite.org/uri.html
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-create-and-use-row-factories
tuplehttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#tuple
sqlite3.Rowhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Row
row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.row_factory
Cursorhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
Connection.row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.row_factory
row_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.row_factory
dicthttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#dict
named tuplehttps://python.github.io/python-docs-zh-tw/glossary.html#term-named-tuple
dataclasshttps://python.github.io/python-docs-zh-tw/library/dataclasses.html#dataclasses.dataclass
namedtuplehttps://python.github.io/python-docs-zh-tw/library/collections.html#collections.namedtuple
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-handle-non-utf-8-text-encodings
strhttps://python.github.io/python-docs-zh-tw/library/stdtypes.html#str
text_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.text_factory
flexible typinghttps://www.sqlite.org/flextypegood.html
Connectionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection
text_factoryhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.text_factory
Unicode HOWTOhttps://python.github.io/python-docs-zh-tw/howto/unicode.html#unicode-howto
Unicode HOWTOhttps://python.github.io/python-docs-zh-tw/howto/unicode.html#unicode-howto
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#explanation
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control
Transaction control via the autocommit attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-autocommit
Transaction control via the isolation_level attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-isolation-level
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control-via-the-autocommit-attribute
Connection.autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
PEP 249https://peps.python.org/pep-0249/
connect()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.connect
Connection.commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
Connection.rollback()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.rollback
close()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.close
autocommit modehttps://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
Connection.commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
Connection.rollback()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.rollback
PEP 249https://peps.python.org/pep-0249/
Connection.autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
Connection.in_transactionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.in_transaction
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
Connection.isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
Transaction control via the isolation_level attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-isolation-level
https://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control-via-the-isolation-level-attribute
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
Transaction control via the autocommit attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3-transaction-control-autocommit
Connection.autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
LEGACY_TRANSACTION_CONTROLhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.LEGACY_TRANSACTION_CONTROL
Connection.isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
execute()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.execute
executemany()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executemany
commit()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.commit
rollback()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.rollback
SQLite transaction behaviourhttps://www.sqlite.org/lang_transaction.html#deferred_immediate_and_exclusive_transactions
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
autocommit modehttps://www.sqlite.org/lang_transaction.html#implicit_versus_explicit_transactions
in_transactionhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.in_transaction
executescript()https://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Cursor.executescript
isolation_levelhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.isolation_level
autocommithttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite3.Connection.autocommit
目錄https://python.github.io/python-docs-zh-tw/contents.html
sqlite3 --- SQLite 資料庫的 DB-API 2.0 介面https://python.github.io/python-docs-zh-tw/library/sqlite3.html
教學https://python.github.io/python-docs-zh-tw/library/sqlite3.html#tutorial
Referencehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#reference
Module functionshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-functions
Module constantshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#module-constants
Connection 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#connection-objects
Cursor 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#cursor-objects
Row 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#row-objects
Blob 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#blob-objects
PrepareProtocol 物件https://python.github.io/python-docs-zh-tw/library/sqlite3.html#prepareprotocol-objects
例外https://python.github.io/python-docs-zh-tw/library/sqlite3.html#exceptions
SQLite and Python typeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#sqlite-and-python-types
Default adapters and converters (deprecated)https://python.github.io/python-docs-zh-tw/library/sqlite3.html#default-adapters-and-converters-deprecated
命令列介面https://python.github.io/python-docs-zh-tw/library/sqlite3.html#command-line-interface
How-to guideshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-guides
How to use placeholders to bind values in SQL querieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-placeholders-to-bind-values-in-sql-queries
How to adapt custom Python types to SQLite valueshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-adapt-custom-python-types-to-sqlite-values
How to write adaptable objectshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-write-adaptable-objects
How to register adapter callableshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-register-adapter-callables
How to convert SQLite values to custom Python typeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-convert-sqlite-values-to-custom-python-types
Adapter and converter recipeshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#adapter-and-converter-recipes
How to use connection shortcut methodshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-connection-shortcut-methods
How to use the connection context managerhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-use-the-connection-context-manager
How to work with SQLite URIshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-work-with-sqlite-uris
How to create and use row factorieshttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-create-and-use-row-factories
如何處理非 UTF-8 的文字編碼https://python.github.io/python-docs-zh-tw/library/sqlite3.html#how-to-handle-non-utf-8-text-encodings
解釋https://python.github.io/python-docs-zh-tw/library/sqlite3.html#explanation
Transaction controlhttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control
Transaction control via the autocommit attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control-via-the-autocommit-attribute
Transaction control via the isolation_level attributehttps://python.github.io/python-docs-zh-tw/library/sqlite3.html#transaction-control-via-the-isolation-level-attribute
dbm --- Unix "databases" 的介面https://python.github.io/python-docs-zh-tw/library/dbm.html
資料壓縮與保存https://python.github.io/python-docs-zh-tw/library/archiving.html
回報錯誤https://python.github.io/python-docs-zh-tw/bugs.html
顯示原始碼 https://github.com/python/cpython/blob/main/Doc/library/sqlite3.rst?plain=1
索引https://python.github.io/python-docs-zh-tw/genindex.html
模組https://python.github.io/python-docs-zh-tw/py-modindex.html
下一頁https://python.github.io/python-docs-zh-tw/library/archiving.html
上一頁https://python.github.io/python-docs-zh-tw/library/dbm.html
Pythonhttps://www.python.org/
3.14.0 Documentationhttps://python.github.io/python-docs-zh-tw/index.html
Python 標準函式庫 (Standard Library)https://python.github.io/python-docs-zh-tw/library/index.html
資料持久性 (Data Persistence)https://python.github.io/python-docs-zh-tw/library/persistence.html
sqlite3 --- SQLite 資料庫的 DB-API 2.0 介面https://python.github.io/python-docs-zh-tw/library/sqlite3.html
版權所有https://python.github.io/python-docs-zh-tw/copyright.html
歷史與授權條款https://python.github.io/license.html
敬請捐贈。https://www.python.org/psf/donations/
發現 bughttps://python.github.io/bugs.html
Sphinxhttps://www.sphinx-doc.org/

Viewport: width=device-width, initial-scale=1.0


URLs of crawlers that visited me.