{"id":1055,"date":"2023-03-24T09:47:07","date_gmt":"2023-03-24T01:47:07","guid":{"rendered":""},"modified":"2023-03-24T09:47:07","modified_gmt":"2023-03-24T01:47:07","slug":"Python SQLite","status":"publish","type":"post","link":"https:\/\/bianchenghao6.com\/1055.html","title":{"rendered":"Python SQLite"},"content":{"rendered":"


\n <\/head>
\n <\/p>\n

\n

Python SQLite<\/h1>\n

\u641e\u61c2Python SQLite\u7684\u57fa\u672c\u64cd\u4f5c<\/span>\n <\/div>\n

Python\u5b89\u88c5sqlite3<\/h2>\n

\u67e5\u770b\u662fPython\u662f\u5426\u6709\u8be5\u5e93<\/h3>\n
\n \u4f7f\u7528http:\/\/django-china.cn\/topic\/413\/ \u67e5\u770b\u81ea\u5df1Python\u5e93\u7684\u8def\u5f84\uff0c\n <\/div>\n
\n
 >>> import site; site.getsitepackages()
 ['\/home\/user\/usr\/python\/python2.7\/lib\/python2.7\/site-packages', '\/home\/user\/usr\/python\/python2.7\/lib\/site-python'] <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u8fdb\u5165 \/home\/user\/usr\/python\/python2.7\/lib\/python2.7\/lib-dynload
\n   
\u770b\u770b\u662f\u5426\u6709_sqlite3.so\u8fd9\u4e2a\u6587\u4ef6\uff0c
\n   
\u53d1\u73b0\u6ca1\u6709\u8fd9\u4e2a\u6587\u4ef6\uff0c\u8bf4\u660e\u6ca1\u6709\u5b89\u88c5\u6b64\u6269\u5c55\u3002\n  <\/div>\n
\u5b89\u88c5SQLITE3<\/h3>\n
\n    \u4e0b\u8f7d sqlite-autoconf-3080401.tar.gz
\n   
 \u5728 https:\/\/sqlite.org\/download.html \u8fd9\u91cc\u4e0b\u8f7d\u3002
\n   
 \u5b89\u88c5\u65b9\u6cd5\u662f\uff1a
\n   
 \u89e3\u538b
\n   
 .\/configure --prefix=\/home\/user\/usr\/db\/sqlite
\n   
 make
\n   
 make install\n  <\/div>\n
\u91cd\u65b0\u5b89\u88c5python<\/h3>\n
\n    \u4e0d\u7ba1\u6709\u6ca1\u6709\u5b89\u88c5\u8fc7Python\uff0c\u8fd9\u91cc\u90fd\u5fc5\u987b\u91cd\u65b0\u8fdb\u884c\u5b89\u88c5\u3002
\n   
 \u7f16\u8f91 setup.py
\n   
 \u6dfb\u52a0sqlite\u7684\u641c\u7d22\u8def\u5f84\n  <\/div>\n
\u67e5\u770b\u662f\u5426\u5df2\u7ecf\u5b89\u88c5\u6210\u529f<\/h3>\n
\n    \u65b9\u6cd5\u4e00\uff1a\u5148\u770b\u4e0bLib\u662f\u5426\u5df2\u7ecf\u751f\u6210\n  <\/div>\n
\n    \u8fd8\u662f\u5728 \/home\/user\/usr\/python\/python2.7\/lib\/python2.7\/lib-dynload \u4e0b
\n   
\u53d1\u73b0\u4e86 _sqlite3.so \u6587\u4ef6\n  <\/div>\n
\n    \u65b9\u6cd5\u4e8c\uff1a\u4f7f\u7528python \u547d\u4ee4\n  <\/div>\n
\n
 >>> import sqlite3 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u53ef\u4ee5\u4f7f\u7528\u7531Gerhard Haring\u7f16\u5199\u7684sqlite3\u6a21\u5757\u5c06SQLite3\u4e0ePython\u96c6\u6210\u3002\u5b83\u63d0\u4f9b\u4e86\u4e00\u4e2a\u7b26\u5408PEP 249\u63cf\u8ff0\u7684DB-API 2.0\u89c4\u8303\u7684SQL\u63a5\u53e3\u3002\u4f60\u4e0d\u9700\u8981\u5355\u72ec\u5b89\u88c5\u6b64\u6a21\u5757\uff0c\u56e0\u4e3a\u5b83\u662f\u9ed8\u8ba4\u968fPython 2.5.x\u7248\u4e00\u8d77\u63d0\u4f9b\u7684\u3002
\n   
\u8981\u4f7f\u7528sqlite3\u6a21\u5757\uff0c\u5fc5\u987b\u9996\u5148\u521b\u5efa\u4e00\u4e2a\u4ee3\u8868\u6570\u636e\u5e93\u7684\u8fde\u63a5\u5bf9\u8c61\uff0c\u7136\u540e\u53ef\u4ee5\u9009\u62e9\u521b\u5efa\u4e00\u4e2a\u6e38\u6807\u5bf9\u8c61\uff0c\u8be5\u5bf9\u8c61\u5c06\u5e2e\u52a9\u4f60\u6267\u884c\u6240\u6709SQL\u8bed\u53e5\u3002\n  <\/div>\n
Python SQLite3\u6a21\u5757API<\/h2>\n
\n    \u4ee5\u4e0b\u662f\u91cd\u8981\u7684sqlite3\u6a21\u5757\u4f8b\u7a0b\uff0c\u8fd9\u4e9b\u4f8b\u7a0b\u53ef\u4ee5\u6ee1\u8db3\u4f60\u4ecePython\u7a0b\u5e8f\u4f7f\u7528SQLite\u6570\u636e\u5e93\u7684\u8981\u6c42\u3002\u5982\u679c\u4f60\u6b63\u5728\u5bfb\u627e\u66f4\u590d\u6742\u7684\u5e94\u7528\u7a0b\u5e8f\uff0c\u5219\u53ef\u4ee5\u67e5\u770bPython sqlite3\u6a21\u5757\u7684\u5b98\u65b9\u6587\u6863\u3002\n  <\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u7f16\u53f7<\/td>\nAPI & \u63cf\u8ff0<\/td>\n<\/tr>\n
1<\/td>\n sqlite3.connect(database [,timeout ,other optional arguments])<\/b>
 \u8be5API\u6253\u5f00\u4e0eSQLite\u6570\u636e\u5e93\u6587\u4ef6\u7684\u8fde\u63a5\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528\u201c\uff1amemory\uff1a\u201d\u6253\u5f00\u4e0e\u9a7b\u7559\u5728RAM\u4e2d\u800c\u4e0d\u662f\u78c1\u76d8\u4e0a\u7684\u6570\u636e\u5e93\u7684\u6570\u636e\u5e93\u8fde\u63a5\u3002\u5982\u679c\u6570\u636e\u5e93\u6210\u529f\u6253\u5f00\uff0c\u5b83\u5c06\u8fd4\u56de\u4e00\u4e2a\u8fde\u63a5\u5bf9\u8c61\u3002 <\/td>\n<\/tr>\n
2<\/td>\n connection.cursor([cursorClass])<\/b>
 \u6b64\u4f8b\u7a0b\u521b\u5efa\u4e00\u4e2a\u6e38\u6807\uff0c\u8be5\u6e38\u6807\u5c06\u5728\u6574\u4e2aPython\u6570\u636e\u5e93\u7f16\u7a0b\u4e2d\u4f7f\u7528\u3002\u6b64\u65b9\u6cd5\u63a5\u53d7\u5355\u4e2a\u53ef\u9009\u53c2\u6570cursorClass\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u5fc5\u987b\u662f\u6269\u5c55sqlite3.Cursor\u7684\u81ea\u5b9a\u4e49\u5149\u6807\u7c7b\u3002 <\/td>\n<\/tr>\n
3<\/td>\n cursor.execute(sql [, optional parameters])<\/b>
 \u8be5\u4f8b\u7a0b\u6267\u884c\u4e00\u6761SQL\u8bed\u53e5\u3002\u53ef\u4ee5\u5bf9SQL\u8bed\u53e5\u8fdb\u884c\u53c2\u6570\u5316\uff08\u5373\uff0c\u4f7f\u7528\u5360\u4f4d\u7b26\u4ee3\u66ffSQL\u6587\u5b57\uff09\u3002sqlite3\u6a21\u5757\u652f\u6301\u4e24\u79cd\u5360\u4f4d\u7b26\uff1a\u95ee\u53f7\u548c\u547d\u540d\u5360\u4f4d\u7b26\uff08\u547d\u540d\u6837\u5f0f\uff09\u3002
 \u4f8b\u5982\uff1a<\/b> \u2212 cursor.execute(\"insert into people values (?, ?)\", (who, age)) <\/td>\n<\/tr>\n
4<\/td>\n connection.execute(sql [, optional parameters])<\/b>
 \u6b64\u4f8b\u7a0b\u662f\u6e38\u6807\u5bf9\u8c61\u63d0\u4f9b\u7684\u4e0a\u8ff0execute\u65b9\u6cd5\u7684\u5feb\u6377\u65b9\u5f0f\uff0c\u5b83\u901a\u8fc7\u8c03\u7528cursor\u65b9\u6cd5\u521b\u5efa\u4e2d\u95f4\u6e38\u6807\u5bf9\u8c61\uff0c\u7136\u540e\u4f7f\u7528\u7ed9\u5b9a\u7684\u53c2\u6570\u8c03\u7528\u6e38\u6807\u7684execute\u65b9\u6cd5\u3002 <\/td>\n<\/tr>\n
5<\/td>\n cursor.executemany(sql, seq_of_parameters)<\/b>
 \u6b64\u4f8b\u7a0b\u9488\u5bf9\u5e8f\u5217sql\u4e2d\u627e\u5230\u7684\u6240\u6709\u53c2\u6570\u5e8f\u5217\u6216\u6620\u5c04\u6267\u884cSQL\u547d\u4ee4\u3002 <\/td>\n<\/tr>\n
6<\/td>\n connection.executemany(sql[, parameters])<\/b>
 \u6b64\u4f8b\u7a0b\u662f\u4e00\u79cd\u5feb\u6377\u65b9\u5f0f\uff0c\u5b83\u901a\u8fc7\u8c03\u7528cursor\u65b9\u6cd5\u521b\u5efa\u4e2d\u95f4\u5149\u6807\u5bf9\u8c61\uff0c\u7136\u540e\u4f7f\u7528\u7ed9\u5b9a\u7684\u53c2\u6570\u8c03\u7528cursor.s executemany\u65b9\u6cd5\u3002 <\/td>\n<\/tr>\n
7<\/td>\n cursor.executescript(sql_script)<\/b>
 \u6b64\u4f8b\u7a0b\u4ee5\u811a\u672c\u5f62\u5f0f\u4e00\u6b21\u6267\u884c\u591a\u4e2aSQL\u8bed\u53e5\u3002\u5b83\u9996\u5148\u53d1\u51faCOMMIT\u8bed\u53e5\uff0c\u7136\u540e\u6267\u884c\u4f5c\u4e3a\u53c2\u6570\u83b7\u53d6\u7684SQL\u811a\u672c\u3002\u6240\u6709SQL\u8bed\u53e5\u90fd\u5e94\u4ee5\u534a\u5192\u53f7\uff08;\uff09\u5206\u9694\u3002 <\/td>\n<\/tr>\n
8<\/td>\n connection.executescript(sql_script)<\/b>
 \u8be5\u4f8b\u7a0b\u662f\u4e00\u79cd\u5feb\u6377\u65b9\u5f0f\uff0c\u5b83\u901a\u8fc7\u8c03\u7528cursor\u65b9\u6cd5\u6765\u521b\u5efa\u4e2d\u95f4\u5149\u6807\u5bf9\u8c61\uff0c\u7136\u540e\u4f7f\u7528\u7ed9\u5b9a\u7684\u53c2\u6570\u8c03\u7528\u5149\u6807\u7684executescript\u65b9\u6cd5\u3002 <\/td>\n<\/tr>\n
9<\/td>\n connection.total_changes()<\/b>
 \u6b64\u4f8b\u7a0b\u8fd4\u56de\u81ea\u6253\u5f00\u6570\u636e\u5e93\u8fde\u63a5\u4ee5\u6765\u5df2\u88ab\u4fee\u6539\uff0c\u63d2\u5165\u6216\u5220\u9664\u7684\u6570\u636e\u5e93\u884c\u7684\u603b\u6570\u3002 <\/td>\n<\/tr>\n
10<\/td>\n connection.commit()<\/b>
 \u6b64\u65b9\u6cd5\u63d0\u4ea4\u5f53\u524d\u4e8b\u52a1\u3002\u5982\u679c\u4e0d\u8c03\u7528\u6b64\u65b9\u6cd5\uff0c\u5219\u4ece\u5176\u4ed6\u6570\u636e\u5e93\u8fde\u63a5\u4e2d\u770b\u4e0d\u5230\u81ea\u4e0a\u6b21\u8c03\u7528commit\uff08\uff09\u4ee5\u6765\u6240\u505a\u7684\u4efb\u4f55\u64cd\u4f5c\u3002 <\/td>\n<\/tr>\n
11<\/td>\n connection.rollback()<\/b>
 \u81ea\u4e0a\u6b21\u8c03\u7528commit\uff08\uff09\u4ee5\u6765\uff0c\u6b64\u65b9\u6cd5\u5c06\u56de\u6eda\u5bf9\u6570\u636e\u5e93\u7684\u6240\u6709\u66f4\u6539\u3002 <\/td>\n<\/tr>\n
12<\/td>\n connection.close()<\/b>
 \u6b64\u65b9\u6cd5\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\u3002\u8bf7\u6ce8\u610f\uff0c\u8fd9\u4e0d\u4f1a\u81ea\u52a8\u8c03\u7528commit\uff08\uff09\u3002\u5982\u679c\u53ea\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\u800c\u6ca1\u6709\u5148\u8c03\u7528commit\uff08\uff09\uff0c\u5219\u66f4\u6539\u5c06\u4e22\u5931\uff01 <\/td>\n<\/tr>\n
13<\/td>\n cursor.fetchone()<\/b>
 \u6b64\u65b9\u6cd5\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u96c6\u7684\u4e0b\u4e00\u884c\uff0c\u8fd4\u56de\u5355\u4e2a\u5e8f\u5217\uff0c\u5982\u679c\u6ca1\u6709\u66f4\u591a\u6570\u636e\u53ef\u7528\uff0c\u5219\u8fd4\u56deNone\u3002 <\/td>\n<\/tr>\n
14<\/td>\n cursor.fetchmany([size = cursor.arraysize])<\/b>
 \u8be5\u4f8b\u7a0b\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u7684\u4e0b\u4e00\u7ec4\u884c\uff0c\u5e76\u8fd4\u56de\u4e00\u4e2a\u5217\u8868\u3002\u5f53\u6ca1\u6709\u66f4\u591a\u884c\u53ef\u7528\u65f6\uff0c\u5c06\u8fd4\u56de\u4e00\u4e2a\u7a7a\u5217\u8868\u3002\u8be5\u65b9\u6cd5\u5c1d\u8bd5\u83b7\u53d6\u7531size\u53c2\u6570\u6307\u793a\u7684\u5c3d\u53ef\u80fd\u591a\u7684\u884c\u3002 <\/td>\n<\/tr>\n
15<\/td>\n cursor.fetchall()<\/b>
 \u8be5\u4f8b\u7a0b\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u7684\u6240\u6709\uff08\u5269\u4f59\uff09\u884c\uff0c\u5e76\u8fd4\u56de\u4e00\u4e2a\u5217\u8868\u3002\u5982\u679c\u6ca1\u6709\u53ef\u7528\u7684\u884c\uff0c\u5219\u8fd4\u56de\u4e00\u4e2a\u7a7a\u5217\u8868\u3002 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SQLite\u5efa\u7acb\u8fde\u63a5<\/h2>\n
\n    \u8981\u5efa\u7acb\u4e0eSQLite Open\u547d\u4ee4\u63d0\u793a\u7b26\u7684\u8fde\u63a5\uff0c\u6d4f\u89c8\u5b89\u88c5SQLite\u7684\u4f4d\u7f6e\uff0c\u7136\u540e\u6267\u884c\u547d\u4ee4sqlite3\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
  Python SQLite_https:\/\/bianchenghao6.com_\u3010Python3 \u6559\u7a0b\u3011_\u7b2c1\u5f20 <\/p>\n
\u4f7f\u7528Python\u5efa\u7acb\u8fde\u63a5<\/h2>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528SQLite3 python\u6a21\u5757\u4e0eSQLite2\u6570\u636e\u5e93\u8fdb\u884c\u901a\u4fe1\u3002\u4e3a\u6b64\uff0c\u9996\u5148\u9700\u8981\u5efa\u7acb\u4e00\u4e2a\u8fde\u63a5\uff08\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u5bf9\u8c61\uff09\u3002
\n   
\u8981\u4f7f\u7528python\u4e0eSQLite3\u6570\u636e\u5e93\u5efa\u7acb\u8fde\u63a5\uff0c\u4f60\u9700\u8981-\n  <\/div>\n
  \u4f7f\u7528import\u8bed\u53e5\u5bfc\u5165sqlite3\u6a21\u5757\u3002<\/span>
\n  connect\uff08\uff09\u65b9\u6cd5\u5c06\u4f60\u9700\u8981\u8fde\u63a5\u7684\u6570\u636e\u5e93\u7684\u540d\u79f0\u4f5c\u4e3a\u53c2\u6570\u63a5\u53d7\uff0c\u5e76\u8fd4\u56de\u4e00\u4e2aConnection\u5bf9\u8c61\u3002<\/span> <\/p>\n
\u5b9e\u4f8b<\/h3>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 conn = sqlite3.connect<\/span>('example.db'<\/span>)
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u6267\u884c\u7ed3\u679c\uff1a<\/h3>\n
\n
 print(\"Connection established ..........\"<\/span>)
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite\u521b\u5efa\u8868<\/h2>\n
\n    \u4f7f\u7528SQLite CREATE TABLE\u8bed\u53e5\uff0c\u4f60\u53ef\u4ee5\u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u8868\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n    \u4ee5\u4e0b\u662f\u5728SQLite\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u8868\u7684\u8bed\u6cd5-\n  <\/div>\n
\n
 CREATE TABLE database_name.table_name<\/span>(
    column1 datatype PRIMARY KEY(one or <\/span>more columns),
    column2 datatype,
    column3 datatype,
    .....
    columnN datatype
 );
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4ee5\u4e0bSQLite\u67e5\u8be2\/\u8bed\u53e5\u5728SQLite\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a
\n   CRICKETERS<\/b>\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u8ba9\u6211\u4eec\u518d\u521b\u5efa\u4e00\u4e2a\u8868OdiStats\uff0c\u7528\u4e8e\u63cf\u8ff0CRICKETERS\u8868\u4e2d\u6bcf\u4e2a\u7403\u5458\u7684\u4e00\u65e5\u677f\u7403\u7edf\u8ba1\u6570\u636e\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE ODIStats (
    First_Name VARCHAR(255),
    Matches INT,
    Runs INT,
    AVG FLOAT,
    Centuries INT,
    HalfCenturies INT 
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528.tables\u547d\u4ee4\u83b7\u53d6SQLite\u6570\u636e\u5e93\u4e2d\u6570\u636e\u5e93\u4e2d\u7684\u8868\u5217\u8868\u3002\u521b\u5efa\u8868\u683c\u540e\uff0c\u5982\u679c\u4f60\u53ef\u4ee5\u9a8c\u8bc1\u8868\u683c\u5217\u8868\uff0c\u5219\u53ef\u4ee5\u5728\u5176\u4e2d\u89c2\u5bdf\u5230\u65b0\u521b\u5efa\u7684\u8868\u683c\uff0c\u5982\u4e0b\u6240\u793a\uff1a\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> . tables
 CRICKETERS ODIStats
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u4f7f\u7528Python\u521b\u5efa\u8868<\/h2>\n
\n    Cursor\u5bf9\u8c61\u5305\u542b\u6267\u884c\u67e5\u8be2\u548c\u83b7\u53d6\u6570\u636e\u7b49\u7684\u6240\u6709\u65b9\u6cd5\u3002\u8fde\u63a5\u7c7b\u7684cursor\u65b9\u6cd5\u8fd4\u56de\u4e00\u4e2a\u5149\u6807\u5bf9\u8c61\u3002
\n   
 \u56e0\u6b64\uff0c\u8981\u4f7f\u7528python\u5728SQLite\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u8868-\n  <\/div>\n
  \u4f7f\u7528connect\uff08\uff09\u65b9\u6cd5\u4e0e\u6570\u636e\u5e93\u5efa\u7acb\u8fde\u63a5\u3002<\/span>
\n  \u73b0\u5728\uff0c\u4f7f\u7528Cursor\u7c7b\u7684execute\uff08\uff09\u65b9\u6cd5\u6267\u884cCREATE TABLE\u8bed\u53e5\u3002<\/span>
\n  \u901a\u8fc7\u5728\u4e0a\u9762\u521b\u5efa\u7684\u8fde\u63a5\u5bf9\u8c61\u4e0a\u8c03\u7528cursor()\u65b9\u6cd5\u6765\u521b\u5efa\u6e38\u6807\u5bf9\u8c61\u3002<\/span> <\/p>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4ee5\u4e0bPython\u7a0b\u5e8f\u5728SQLite3\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aEmployee\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5\u5230sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u5220\u9664\u5df2\u5b58\u5728\u7684\u8868
<\/span> cursor.execute<\/span>(\"DROP TABLE if <\/span>EXISTS EMPLOYEE\"<\/span>)
 # \u6309\u8981\u6c42\u521b\u5efa\u8868
<\/span> sql =''<\/span><\/span>'CREATE TABLE EMPLOYEE(
    FIRST_NAME CHAR(20) not <\/span>NULL,
    LAST_NAME CHAR(20),
    AGE INT,
    SEX CHAR(1),
    INCOME FLOAT
 )'''
 cursor.execute<\/span>(sql)
 print(\"Table created successfully........\"<\/span>)
 # \u63d0\u4ea4
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
Output<\/h3>\n
\n
 Table created successfully........
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite\u63d2\u5165\u6570\u636e<\/h2>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528INSERT INTO\u8bed\u53e5\u5c06\u65b0\u884c\u6dfb\u52a0\u5230SQLite\u7684\u73b0\u6709\u8868\u4e2d\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u4f60\u9700\u8981\u6307\u5b9a\u8868\u7684\u540d\u79f0\uff0c\u5217\u540d\u79f0\u548c\u503c\uff08\u4e0e\u5217\u540d\u79f0\u7684\u987a\u5e8f\u76f8\u540c\uff09\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n    \u4ee5\u4e0b\u662fINSERT\u8bed\u53e5\u7684\u5efa\u8bae\u8bed\u6cd5-\n  <\/div>\n
\n
 INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)
    VALUES (value1, value2, value3,...valueN);
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5176\u4e2d\uff0ccolumn1\uff0ccolumn2\uff0ccolumn3\uff0c..\u662f\u8868\u7684\u5217\u540d\uff0c\u800cvalue1\uff0cvalue2\uff0cvalue3\uff0c...\u662f\u4f60\u9700\u8981\u63d2\u5165\u8868\u4e2d\u7684\u503c\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528CREATE TABLE\u8bed\u53e5\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u79f0\u4e3aCRICKETERS\u7684\u8868\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0bPostgreSQL\u8bed\u53e5\u5728\u4e0a\u9762\u521b\u5efa\u7684\u8868\u4e2d\u63d2\u5165\u4e00\u884c\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS (First_Name, Last_Name, Age, Place_Of_Birth, Country) 
    values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span>, 'India'<\/span>);
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5728\u4f7f\u7528INSERT INTO\u8bed\u53e5\u63d2\u5165\u8bb0\u5f55\u65f6\uff0c\u5982\u679c\u4f60\u8df3\u8fc7\u4efb\u4f55\u5217\u540d\uff0c\u5219\u5c06\u63d2\u5165\u8be5\u8bb0\u5f55\uff0c\u5728\u4f60\u8df3\u8fc7\u7684\u5217\u4e0a\u7559\u4e0b\u7a7a\u767d\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS (First_Name, Last_Name, Country) 
    values ('Jonathan'<\/span>, 'Trott'<\/span>, 'SouthAfrica'<\/span>);
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u4f60\u4f20\u9012\u7684\u503c\u7684\u987a\u5e8f\u4e0e\u8868\u4e2d\u5b83\u4eec\u5404\u81ea\u7684\u5217\u540d\u76f8\u540c\uff0c\u5219\u4e5f\u53ef\u4ee5\u5728\u4e0d\u6307\u5b9a\u5217\u540d\u7684\u60c5\u51b5\u4e0b\u5c06\u8bb0\u5f55\u63d2\u5165\u8868\u4e2d\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi'<\/span>, 'India'<\/span><\/span>);
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5c06\u8bb0\u5f55\u63d2\u5165\u8868\u540e\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528SELECT\u8bed\u53e5\u9a8c\u8bc1\u5176\u5185\u5bb9\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> select * from cricketers;\r\nShikhar  |Dhawan     | 33 | Delhi | India\r\nJonathan |Trott      |    |       | SouthAfrica\r\nKumara   |Sangakkara | 41 | Matale| Srilanka\r\nVirat    |Kohli      | 30 | Delhi | India\r\nRohit    |Sharma     | 32 | Nagpur| India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\u4f7f\u7528Python\u63d2\u5165\u6570\u636e<\/h2>\n
\n    \u8981\u5c06\u8bb0\u5f55\u6dfb\u52a0\u5230SQLite\u6570\u636e\u5e93\u4e2d\u7684\u73b0\u6709\u8868\u4e2d-\n  <\/div>\n
  \u5bfc\u5165sqlite3\u5305\u3002<\/span>
\n  \u901a\u8fc7\u5c06\u6570\u636e\u5e93\u540d\u79f0\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9\u5b83\uff0c\u4f7f\u7528connect\uff08\uff09\u65b9\u6cd5\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u5bf9\u8c61\u3002<\/span>
\n  cursor()\u65b9\u6cd5\u8fd4\u56de\u4f7f\u7528\u4f60\u53ef\u4ee5\u4e0esqlite3\u7684\u901a\u4fe1\u7684\u5149\u6807\u5bf9\u8c61\u3002\u901a\u8fc7\u8c03\u7528\uff08\u4e0a\u9762\u521b\u5efa\u7684\uff09Connection\u5bf9\u8c61\u4e0a\u7684cursor\uff08\uff09\u5bf9\u8c61\u6765\u521b\u5efa\u5149\u6807\u5bf9\u8c61\u3002<\/span>
\n  \u7136\u540e\uff0c\u901a\u8fc7\u5c06INSERT\u8bed\u53e5\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9\u6e38\u6807\u5bf9\u8c61\uff0c\u4ece\u800c\u8c03\u7528execute\uff08\uff09\u65b9\u6cd5\u3002<\/span> <\/p>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4ee5\u4e0bpython\u793a\u4f8b\u5c06\u8bb0\u5f55\u63d2\u5165\u5230\u540d\u4e3aEMPLOYEE\u7684\u8868\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # Preparing SQL queries to INSERT a record into the database.
<\/span> cursor.execute<\/span>(''<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>'INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Ramya'<\/span>, 'Rama Priya'<\/span>, 27, 'F'<\/span><\/span><\/span>, 9000)'''
 )
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Tripthi'<\/span>, 'Mishra'<\/span>, 24, 'F', 6000)''')
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 print(\"Records inserted........\"<\/span>)
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u6784<\/h3>\n
\n
 Records inserted........
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
 SQLite\u67e5\u8be2\u6570\u636e<\/h2>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528SELECT\u67e5\u8be2\u4eceSQLite\u8868\u4e2d\u68c0\u7d22\u6570\u636e\u3002\u8be5\u67e5\u8be2\/\u8bed\u53e5\u4ee5\u8868\u683c\u5f62\u5f0f\u8fd4\u56de\u6307\u5b9a\u5173\u7cfb\uff08\u8868\uff09\u7684\u5185\u5bb9\uff0c\u79f0\u4e3a\u7ed3\u679c\u96c6\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n    \u4ee5\u4e0b\u662fSQLite\u4e2dSELECT\u8bed\u53e5\u7684\u8bed\u6cd5-\n  <\/div>\n
\n
 SELECT column1, column2, columnN from <\/span>table_name;
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u6211\u4eec\u4f7f\u7528INSERT\u8bed\u53e5\u5c065\u6761\u8bb0\u5f55\u63d2\u5165\u5176\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span><\/span>, 'India'<\/span><\/span><\/span>);
 sqlite> insert into CRICKETERS values('Jonathan'<\/span>, 'Trott'<\/span>, 38, 'CapeTown'<\/span>, 'SouthAfrica'<\/span>);
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi', 'India');
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    SELECT\u67e5\u8be2\u4e4b\u540e\uff0c\u4eceCRICKETERS\u8868\u4e2d\u68c0\u7d22FIRST_NAME\uff0cLAST_NAME\u548cCOUNTRY\u5217\u7684\u503c\u3002\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT FIRST_NAME, LAST_NAME, COUNTRY FROM CRICKETERS;\r\nShikhar   |Dhawan       |India\r\nJonathan  |Trott        |SouthAfrica\r\nKumara    |Sangakkara   |Srilanka\r\nVirat     |Kohli        |India\r\nRohit     |Sharma       |India\r\nsqlite><\/pre>\n
<\/span><\/code>\n  <\/div>\n
\n    \u5982\u4f60\u6240\u89c1\uff0cSQLite\u6570\u636e\u5e93\u7684SELECT\u8bed\u53e5\u4ec5\u8fd4\u56de\u6307\u5b9a\u8868\u7684\u8bb0\u5f55\u3002\u4e3a\u4e86\u83b7\u5f97\u683c\u5f0f\u5316\u7684\u8f93\u51fa\uff0c\u4f60\u9700\u8981\u5728SELECT\u8bed\u53e5\u4e4b\u524d\u4f7f\u7528\u76f8\u5e94\u7684\u547d\u4ee4\u8bbe\u7f6e\u6807\u5934\u548c\u6a21\u5f0f\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> .header on\r\nsqlite> .mode column\r\nsqlite> SELECT FIRST_NAME, LAST_NAME, COUNTRY FROM CRICKETERS;\r\nFirst_Name   Last_Name    Country\r\n----------   ----------   ----------\r\nShikhar      Dhawan       India\r\nJonathan     Trott        SouthAfric\r\nKumara       Sangakkara   rilanka\r\nVirat        Kohli        India\r\nRohit        Sharma       India<\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u5982\u679c\u8981\u68c0\u7d22\u6bcf\u4e2a\u8bb0\u5f55\u7684\u6240\u6709\u5217\uff0c\u5219\u9700\u8981\u7528\u201c *\u201d\u66ff\u6362\u5217\u540d\uff0c\u5982\u4e0b\u6240\u793a\uff1a\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> .header on\r\nsqlite> .mode column\r\nsqlite> SELECT * FROM CRICKETERS;\r\nFirst_Name   Last_Name    Age        Place_Of_Birth   Country\r\n----------   ----------   -------    --------------   ----------\r\nShikhar      Dhawan       33         Delhi            India\r\nJonathan     Trott        38         CapeTown         SouthAfric\r\nKumara       Sangakkara   41         Matale           Srilanka\r\nVirat        Kohli        30         Delhi            India\r\nRohit        Sharma       32         Nagpur           India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5728SQLite\u4e2d\uff0c\u5217\u7684\u5bbd\u5ea6\u662f10\u4e2a\u8d85\u51fa\u8be5\u5bbd\u5ea6\u7684\u503c\uff08\u8bf7\u6ce8\u610f\u4e0a\u8868\u4e2d\u7b2c\u4e8c\u884c\u7684\u56fd\u5bb6\/\u5730\u533a\u5217\uff09\u3002\u4f60\u53ef\u4ee5\u5728\u68c0\u7d22\u8868\u5185\u5bb9\u4e4b\u524d\uff0c\u4f7f\u7528.width\u547d\u4ee4\u5c06\u6bcf\u5217\u7684\u5bbd\u5ea6\u8bbe\u7f6e\u4e3a\u6240\u9700\u503c\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> .width 10, 10, 4, 10, 13\r\nsqlite> SELECT * FROM CRICKETERS;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   --------\r\nShikhar      Dhawan       33     Delhi        India\r\nJonathan     Trott        38     CapeTown     SouthAfrica\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nVirat        Kohli        30     Delhi        India\r\nRohit        Sharma       32     Nagpur       India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\u4f7f\u7528Python\u68c0\u7d22\u6570\u636e<\/h2>\n
\n    \u4efb\u4f55\u6570\u636e\u5e93\u4e0a\u7684READ\u64cd\u4f5c\u610f\u5473\u7740\u8981\u4ece\u6570\u636e\u5e93\u4e2d\u83b7\u53d6\u4e00\u4e9b\u6709\u7528\u7684\u4fe1\u606f\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528sqlite python\u6a21\u5757\u63d0\u4f9b\u7684fetch\uff08\uff09\u65b9\u6cd5\u4eceMYSQL\u83b7\u53d6\u6570\u636e\u3002\n  <\/div>\n
\n    sqlite3.Cursor\u7c7b\u63d0\u4f9b\u4e86\u4e09\u79cd\u65b9\u6cd5\uff0c\u5206\u522b\u662ffetchall\uff08\uff09\uff0cfetchmany\uff08\uff09\u548cfetchone\uff08\uff09\uff0c\u5176\u4e2d\uff0c\n  <\/div>\n
  fetchall()\u65b9\u6cd5\u68c0\u7d22\u67e5\u8be2\u7ed3\u679c\u96c6\u4e2d\u7684\u6240\u6709\u884c\uff0c\u5e76\u5c06\u5b83\u4eec\u4f5c\u4e3a\u5143\u7ec4\u5217\u8868\u8fd4\u56de\u3002\uff08\u5982\u679c\u6211\u4eec\u5728\u68c0\u7d22\u5230\u51e0\u884c\u4e4b\u540e\u6267\u884c\u6b64\u64cd\u4f5c\uff0c\u5b83\u5c06\u8fd4\u56de\u5269\u4f59\u7684\u884c\uff09\u3002<\/span>
\n  fetchone()\u65b9\u6cd5\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u4e0b\u4e00\u884c\uff0c\u5e76\u5c06\u5176\u4f5c\u4e3a\u5143\u7ec4\u8fd4\u56de\u3002<\/span>
\n  fetchmany()\u65b9\u6cd5\u7c7b\u4f3c\u4e8efetchone\uff08\uff09\uff0c\u4f46\u662f\u5b83\u68c0\u7d22\u67e5\u8be2\u7ed3\u679c\u96c6\u4e2d\u7684\u4e0b\u4e00\u7ec4\u884c\uff0c\u800c\u4e0d\u662f\u5355\u884c\u3002<\/span> <\/p>\n
\n   \u6ce8\u610f\uff1a<\/span>\u7ed3\u679c\u96c6\u662f\u4f7f\u7528\u6e38\u6807\u5bf9\u8c61\u67e5\u8be2\u8868\u65f6\u8fd4\u56de\u7684\u5bf9\u8c61\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4e0b\u9762\u7684\u793a\u4f8b\u4f7f\u7528SELECT\u67e5\u8be2\u83b7\u53d6EMPLOYEE\u8868\u7684\u6240\u6709\u884c\uff0c\u5e76\u6700\u521d\u4ece\u83b7\u5f97\u7684\u7ed3\u679c\u96c6\u4e2d\u83b7\u53d6\u6570\u636e\uff0c\u9996\u5148\u4f7f\u7528fetchone\uff08\uff09\u65b9\u6cd5\u68c0\u7d22\u7b2c\u4e00\u884c\uff0c\u7136\u540e\u4f7f\u7528fetchall\uff08\uff09\u65b9\u6cd5\u83b7\u53d6\u5176\u4f59\u884c\u3002
\n   
\u4ee5\u4e0bPython\u7a0b\u5e8f\u6f14\u793a\u4e86\u5982\u4f55\u4ece\u4e0a\u9762\u7684\u793a\u4f8b\u4e2d\u521b\u5efa\u7684COMPANY\u8868\u4e2d\u83b7\u53d6\u5e76\u663e\u793a\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u68c0\u7d22\u6570\u636e
<\/span> cursor.execute<\/span>(''<\/span><\/span>'SELECT * from <\/span>EMPLOYEE'<\/span>'')
 # \u6b63\u5728\u4ece\u8868\u4e2d\u83b7\u53d6\u7b2c\u4e00\u884c
<\/span><\/span> result = cursor.fetchone<\/span>();
 print(result)
 result = cursor.fetchall<\/span>();
 print(result)
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u679c\uff1a<\/h3>\n
\n
 ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span><\/span><\/span>, 9000.0)
 [
    ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000.0),
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300.0),
    ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000.0),
    ('Tripthi'<\/span>, 'Mishra'<\/span>, 24, 'F', 6000.0)
 ]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite Where\u67e5\u8be2<\/h2>\n
\n    \u5982\u679c\u8981\u5728SQLite\u4e2d\u83b7\u53d6\uff0c\u5220\u9664\u6216\u66f4\u65b0\u8868\u7684\u7279\u5b9a\u884c\uff0c\u5219\u9700\u8981\u4f7f\u7528where\u5b50\u53e5\u6307\u5b9a\u6761\u4ef6\u4ee5\u8fc7\u6ee4\u8be5\u64cd\u4f5c\u7684\u8868\u884c\u3002
\n   
\u4f8b\u5982\uff0c\u5982\u679c\u4f60\u6709\u4e00\u6761\u5e26where\u5b50\u53e5\u7684SELECT\u8bed\u53e5\uff0c\u5219\u4ec5\u68c0\u7d22\u6ee1\u8db3\u6307\u5b9a\u6761\u4ef6\u7684\u884c\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n
 SELECT column1, column2, columnN
 from <\/span>table_name
 WHERE [search_condition]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528\u6bd4\u8f83\u6216\u903b\u8f91\u8fd0\u7b97\u7b26\u6307\u5b9asearch_condition\u3002\u4f8b\u5982>\uff0c<\uff0c=\uff0cLIKE\uff0cNOT\u7b49\u3002\u4ee5\u4e0b\u793a\u4f8b\u5c06\u4f7f\u8fd9\u4e2a\u6982\u5ff5\u66f4\u6e05\u695a\u3002\n  <\/div>\n
\u4f8b\u5982<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u6211\u4eec\u4f7f\u7528INSERT\u8bed\u53e5\u5c065\u6761\u8bb0\u5f55\u63d2\u5165\u5176\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span><\/span>, 'India'<\/span><\/span><\/span>);
 sqlite> insert into CRICKETERS values('Jonathan'<\/span>, 'Trott'<\/span>, 38, 'CapeTown'<\/span>, 'SouthAfrica'<\/span>);
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi', 'India');
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0bSELECT\u8bed\u53e5\u68c0\u7d22\u5e74\u9f84\u5927\u4e8e35\u7684\u8bb0\u5f55-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS WHERE AGE > 35;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   -----------\r\nJonathan     Trott        38     CapeTown     SouthAfrica\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\u4f7f\u7528Python\u7684\u5b50\u53e5<\/h2>\n
\n    Cursor\u5bf9\u8c61\/\u7c7b\u5305\u542b\u6267\u884c\u67e5\u8be2\u548c\u83b7\u53d6\u6570\u636e\u7b49\u7684\u6240\u6709\u65b9\u6cd5\u3002\u8fde\u63a5\u7c7b\u7684cursor\u65b9\u6cd5\u8fd4\u56de\u4e00\u4e2a\u5149\u6807\u5bf9\u8c61\u3002
\n   
 \u56e0\u6b64\uff0c\u8981\u4f7f\u7528python\u5728SQLite\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u8868-\n  <\/div>\n
\n    Therefore, to create a table in SQLite database using python \u2212\n  <\/div>\n
  \u4f7f\u7528connect\uff08\uff09\u65b9\u6cd5\u4e0e\u6570\u636e\u5e93\u5efa\u7acb\u8fde\u63a5\u3002<\/span>
\n  \u901a\u8fc7\u5728\u4e0a\u9762\u521b\u5efa\u7684\u8fde\u63a5\u5bf9\u8c61\u4e0a\u8c03\u7528cursor\uff08\uff09\u65b9\u6cd5\u6765\u521b\u5efa\u6e38\u6807\u5bf9\u8c61\u3002<\/span>
\n  \u73b0\u5728\uff0c\u4f7f\u7528Cursor\u7c7b\u7684execute\uff08\uff09\u65b9\u6cd5\u6267\u884cCREATE TABLE\u8bed\u53e5\u3002<\/span> <\/p>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4e0b\u9762\u7684\u793a\u4f8b\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aEmployee\u7684\u8868\u5e76\u586b\u5145\u5b83\u3002\u7136\u540e\u4f7f\u7528where\u5b50\u53e5\u68c0\u7d22\u5e74\u9f84\u5c0f\u4e8e23\u7684\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u5220\u9664\u5df2\u5b58\u5728\u7684\u8868
<\/span> cursor.execute<\/span>(\"DROP TABLE if <\/span>EXISTS EMPLOYEE\"<\/span>)
 sql = ''<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>'CREATE TABLE EMPLOYEE(
    FIRST_NAME CHAR(20) not <\/span>NULL,
    LAST_NAME CHAR(20),
    AGE INT,
    SEX CHAR(1),
    INCOME FLOAT
 )'''
 cursor.execute<\/span>(sql)
 # \u586b\u5145\u8868
<\/span> cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span><\/span><\/span>, 9000)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000)''')
 cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Tripthi'<\/span>, 'Mishra'<\/span>, 24, 'F', 6000)''')
 # \u4f7f\u7528where\u5b50\u53e5\u68c0\u7d22\u7279\u5b9a\u8bb0\u5f55
<\/span> cursor.execute<\/span>(\"SELECT * from <\/span>EMPLOYEE WHERE AGE <23\"<\/span>) 
 print(cursor.fetchall<\/span>())
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8fd0\u884c\u7ed3\u679c\uff1a<\/h3>\n
\n
 [('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span>, 6000.0)]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite Order by<\/h2>\n
\n    \u4f7f\u7528SELECT\u67e5\u8be2\u83b7\u53d6\u6570\u636e\u65f6\uff0c\u4f60\u5c06\u4ee5\u63d2\u5165\u8bb0\u5f55\u7684\u987a\u5e8f\u83b7\u5f97\u8bb0\u5f55\u3002
\n   
\u4f60\u53ef\u4ee5\u4f7f\u7528Order By\u5b50\u53e5\u6309\u6240\u9700\u987a\u5e8f\uff08\u5347\u5e8f\u6216\u964d\u5e8f\uff09\u5bf9\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u6b64\u5b50\u53e5\u4ee5\u5347\u5e8f\u5bf9\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\uff0c\u5982\u679c\u9700\u8981\u6309\u964d\u5e8f\u6392\u5217\u5b83\u4eec\uff0c\u5219\u9700\u8981\u663e\u5f0f\u4f7f\u7528\u201c DESC\u201d\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n
 SELECT column-list
 from <\/span>table_name
 [WHERE condition]
 [ORDER BY column1, column2, .. columnN] [ASC | DESC];
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
Example<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u6211\u4eec\u4f7f\u7528INSERT\u8bed\u53e5\u5c065\u6761\u8bb0\u5f55\u63d2\u5165\u5176\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span><\/span>, 'India'<\/span><\/span><\/span>);
 sqlite> insert into CRICKETERS values('Jonathan'<\/span>, 'Trott'<\/span>, 38, 'CapeTown'<\/span>, 'SouthAfrica'<\/span>);
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi', 'India');
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0bSELECT\u8bed\u53e5\u6309\u5e74\u9f84\u7684\u5347\u5e8f\u68c0\u7d22CRICKETERS\u8868\u7684\u884c-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS ORDER BY AGE;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   -----------\r\nVirat        Kohli        30     Delhi        India\r\nRohit        Sharma       32     Nagpur       India\r\nShikhar      Dhawan       33     Delhi        India\r\nJonathan     Trott        38     CapeTown     SouthAfrica\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528\u591a\u4e2a\u5217\u6765\u5bf9\u8868\u7684\u8bb0\u5f55\u8fdb\u884c\u6392\u5e8f\u3002\u4ee5\u4e0bSELECT\u8bed\u53e5\u6839\u636eAGE\u548cFIRST_NAME\u5217\u5bf9CRICKETERS\u8868\u7684\u8bb0\u5f55\u8fdb\u884c\u6392\u5e8f\u3002\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS ORDER BY AGE, FIRST_NAME;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   -------------\r\nVirat        Kohli        30     Delhi        India\r\nRohit        Sharma       32     Nagpur       India\r\nShikhar      Dhawan       33     Delhi        India\r\nJonathan     Trott        38     CapeTown     SouthAfrica\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cORDER BY\u5b50\u53e5\u5c06\u8868\u7684\u8bb0\u5f55\u6309\u5347\u5e8f\u6392\u5e8f\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528DESC\u5c06\u7ed3\u679c\u6309\u964d\u5e8f\u6392\u5217-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS ORDER BY AGE DESC;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   -------------\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nJonathan     Trott        38     CapeTown     SouthAfrica\r\nShikhar      Dhawan       33     Delhi        India\r\nRohit        Sharma       32     Nagpur       India\r\nVirat        Kohli        30     Delhi        India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\u4f7f\u7528Python\u7684ORDER BY\u5b50\u53e5<\/h2>\n
\n    \u8981\u6309\u7279\u5b9a\u987a\u5e8f\u68c0\u7d22\u8868\u7684\u5185\u5bb9\uff0c\u8bf7\u5728\u6e38\u6807\u5bf9\u8c61\u4e0a\u8c03\u7528execute\uff08\uff09\u65b9\u6cd5\uff0c\u5e76\u5c06SELECT\u8bed\u53e5\u4e0eORDER BY\u5b50\u53e5\u4e00\u8d77\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9\u5b83\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5728\u4ee5\u4e0b\u793a\u4f8b\u4e2d\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u5177\u6709\u540d\u79f0\u548cEmployee\u7684\u8868\uff0c\u586b\u5145\u8be5\u8868\uff0c\u7136\u540e\u4f7f\u7528ORDER BY\u5b50\u53e5\u6309\u5176\u5e74\u9f84\u7684\uff08\u5347\u5e8f\uff09\u987a\u5e8f\u68c0\u7d22\u5176\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>psycopg2
 # \u5efa\u7acb\u8fde\u63a5
<\/span> conn = psycopg2.connect<\/span>(
    database=\"mydb\"<\/span>, user='postgres'<\/span>, password='password'<\/span>, host='127.0.0.1'<\/span>, port= '5432'<\/span>
 )
 conn.autocommit = True<\/span>
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 #\u5220\u9664\u5df2\u5b58\u5728\u7684\u8868
<\/span> cursor.execute<\/span>(\"DROP TABLE if <\/span>EXISTS EMPLOYEE\"<\/span>)
 # \u521b\u5efa\u8868
<\/span> sql = ''<\/span><\/span><\/span><\/span>'CREATE TABLE EMPLOYEE(
    FIRST_NAME CHAR(20) not <\/span>NULL,
    LAST_NAME CHAR(20),
    AGE INT, SEX CHAR(1),
    INCOME INT,
    CONTACT INT
 )'''
 cursor.execute<\/span>(sql)
 # \u586b\u5145\u8868
<\/span><\/span> cursor.execute<\/span>(
    '''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) 
    VALUES ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span><\/span><\/span>, 9000),
    ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000), 
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300), 
    ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000),
    ('Tripthi'<\/span>, 'Mishra'<\/span>, 24, 'F', 6000)''')
 conn.commit<\/span>()
 #Retrieving specific records using the ORDER BY clause
<\/span> cursor.execute<\/span>(\"SELECT * from <\/span>EMPLOYEE ORDER BY AGE\"<\/span>)
 print(cursor.fetchall<\/span>())
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u679c\uff1a<\/h3>\n
\n
 [
    ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000, None),
    ('Tripthi'<\/span>, 'Mishra'<\/span>, 24, 'F'<\/span><\/span><\/span>, 6000, None),
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300, None),
    ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000, None),
    ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F', 9000, None)
 ]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite\u66f4\u65b0\u8868<\/h2>\n
\n    UPDATE\u5bf9\u4efb\u4f55\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u90fd\u610f\u5473\u7740\u4fee\u6539\u8868\u4e2d\u4e00\u4e2a\u6216\u591a\u4e2a\u8bb0\u5f55\u7684\u503c\uff0c\u8fd9\u4e9b\u503c\u5df2\u7ecf\u5728\u6570\u636e\u5e93\u4e2d\u53ef\u7528\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528UPDATE\u8bed\u53e5\u66f4\u65b0SQLite\u4e2d\u73b0\u6709\u8bb0\u5f55\u7684\u503c\u3002
\n   
\u8981\u66f4\u65b0\u7279\u5b9a\u7684\u884c\uff0c\u4f60\u9700\u8981\u4e0e\u5176\u4e00\u8d77\u4f7f\u7528WHERE\u5b50\u53e5\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n
 UPDATE table_name
 SET column1 = value1, column2 = value2...., columnN = valueN
 WHERE [condition];
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u6211\u4eec\u4f7f\u7528INSERT\u8bed\u53e5\u5c065\u6761\u8bb0\u5f55\u63d2\u5165\u5176\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span><\/span>, 'India'<\/span><\/span><\/span>);
 sqlite> insert into CRICKETERS values('Jonathan'<\/span>, 'Trott'<\/span>, 38, 'CapeTown'<\/span>, 'SouthAfrica'<\/span>);
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi', 'India');
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4e0b\u9762\u7684\u8bed\u53e5\u4fee\u6539\u7684\u677f\u7403\u8fd0\u52a8\u5458\uff0c\u4ed6\u7684\u540d\u5b57\u662f\u5e74\u9f84Shikhar\u7684 -\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> UPDATE CRICKETERS SET AGE = 45 WHERE FIRST_NAME = 'Shikhar'<\/span> ;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u4f60\u68c0\u7d22FIRST_NAME\u662fShikhar\u7684\u8bb0\u5f55\uff0c\u5219\u4f1a\u89c2\u5bdf\u5230\u5e74\u9f84\u503c\u5df2\u66f4\u6539\u4e3a45-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS WHERE FIRST_NAME = 'Shikhar';\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   --------\r\nShikhar      Dhawan       45     Delhi        India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u5982\u679c\u4f60\u5c1a\u672a\u4f7f\u7528WHERE\u5b50\u53e5\uff0c\u5219\u6240\u6709\u8bb0\u5f55\u7684\u503c\u90fd\u5c06\u66f4\u65b0\u3002\u4ee5\u4e0bUPDATE\u8bed\u53e5\u4f7fCRICKETERS\u8868\u4e2d\u7684\u6240\u6709\u8bb0\u5f55\u7684\u5bff\u547d\u589e\u52a01-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> UPDATE CRICKETERS SET AGE = AGE+1;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u4f7f\u7528SELECT\u547d\u4ee4\u68c0\u7d22\u8868\u7684\u5185\u5bb9\uff0c\u5219\u53ef\u4ee5\u770b\u5230\u66f4\u65b0\u540e\u7684\u503c\u4e3a-\n  <\/div>\n
\n
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   -------------\r\nShikhar      Dhawan       46     Delhi        India\r\nJonathan     Trott        39     CapeTown     SouthAfrica\r\nKumara       Sangakkara   42     Matale       Srilanka\r\nVirat        Kohli        31     Delhi        India\r\nRohit        Sharma       33     Nagpur       India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\u4f7f\u7528Python\u66f4\u65b0\u73b0\u6709\u8bb0\u5f55<\/h2>\n
\n    To add records to an existing table in SQLite database \u2212\n  <\/div>\n
  \u5bfc\u5165sqlite3\u5305\u3002<\/span>
\n  \u901a\u8fc7\u5c06\u6570\u636e\u5e93\u540d\u79f0\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9\u5b83\uff0c\u4f7f\u7528connect\uff08\uff09\u65b9\u6cd5\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u5bf9\u8c61\u3002<\/span>
\n  cursor()\u65b9\u6cd5\u8fd4\u56de\u4f7f\u7528\u4f60\u53ef\u4ee5\u4e0esqlite3\u7684\u901a\u4fe1\u7684\u5149\u6807\u5bf9\u8c61\u3002\u901a\u8fc7\u8c03\u7528\uff08\u4e0a\u9762\u521b\u5efa\u7684\uff09Connection\u5bf9\u8c61\u4e0a\u7684cursor\uff08\uff09\u5bf9\u8c61\u6765\u521b\u5efa\u5149\u6807\u5bf9\u8c61\u3002<\/span>
\n  \u7136\u540e\uff0c\u901a\u8fc7\u5411\u6e38\u6807\u5bf9\u8c61\u4f20\u9012UPDATE\u8bed\u53e5\u4f5c\u4e3a\u53c2\u6570\u6765\u8c03\u7528execute\uff08\uff09\u65b9\u6cd5\u3002<\/span> <\/p>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5728Python\u793a\u4f8b\u4e2d\uff0c\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aEMPLOYEE\u7684\u8868\uff0c\u5411\u5176\u4e2d\u63d2\u51655\u6761\u8bb0\u5f55\uff0c\u5e76\u4f7f\u6240\u6709\u7537\u6027\u96c7\u5458\u7684\u5e74\u9f84\u589e\u52a01-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 #\u5220\u9664\u5df2\u5b58\u5728\u7684\u8868
<\/span> cursor.execute<\/span>(\"DROP TABLE if <\/span>EXISTS EMPLOYEE\"<\/span>)
 # \u6309\u8981\u6c42\u521b\u5efa\u8868
<\/span> sql =''<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>'CREATE TABLE EMPLOYEE(
    FIRST_NAME CHAR(20) not <\/span>NULL,
    LAST_NAME CHAR(20),
    AGE INT,
    SEX CHAR(1),
    INCOME FLOAT
 )'''
 cursor.execute<\/span>(sql)
 # \u63d2\u5165\u6570\u636e
<\/span> cursor.execute<\/span>('''INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME)
 VALUES ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span><\/span><\/span>, 9000),
    ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000), 
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300), 
    ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000),
    ('Tripthi'<\/span>, 'Mishra'<\/span>, 24, 'F', 6000)''')
 conn.commit<\/span>()
 # \u6b63\u5728\u83b7\u53d6\u66f4\u65b0\u524d\u7684\u6240\u6709\u884c
<\/span> print(\"Contents of the Employee table: \"<\/span>)
 cursor.execute<\/span>('''SELECT * from <\/span>EMPLOYEE'<\/span><\/span>'')
 print(cursor.fetchall<\/span>())
 # \u66f4\u65b0\u8bb0\u5f55
<\/span> sql = '''UPDATE EMPLOYEE SET AGE=AGE+1 WHERE SEX = '<\/span>M' '<\/span>''
 cursor.execute<\/span>(sql)
 print(\"Table updated...... \"<\/span>)
 # \u6b63\u5728\u83b7\u53d6\u66f4\u65b0\u540e\u7684\u6240\u6709\u884c
<\/span> print(\"Contents of the Employee table after the update operation: \"<\/span>)
 cursor.execute<\/span>('''SELECT * from <\/span>EMPLOYEE''')
 print(cursor.fetchall<\/span>())
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u679c\uff1a<\/h3>\n
\n
 Contents of the Employee table:
 [
    ('Ramya'<\/span><\/span>, 'Rama priya'<\/span><\/span>, 27, 'F'<\/span><\/span><\/span><\/span><\/span><\/span>, 9000.0), 
    ('Vinay'<\/span><\/span>, 'Battacharya'<\/span><\/span>, 20, 'M'<\/span><\/span><\/span><\/span>, 6000.0), 
    ('Sharukh'<\/span><\/span>, 'Sheik'<\/span><\/span>, 25, 'M', 8300.0), 
    ('Sarmista'<\/span><\/span>, 'Sharma'<\/span><\/span>, 26, 'F', 10000.0), 
    ('Tripthi'<\/span><\/span>, 'Mishra'<\/span><\/span>, 24, 'F', 6000.0)
 ]
 Table updated......
 Contents of the Employee table after the update operation:
 [
    ('Ramya', 'Rama priya', 27, 'F', 9000.0), 
    ('Vinay', 'Battacharya', 21, 'M', 6000.0), 
    ('Sharukh', 'Sheik', 26, 'M', 8300.0), 
    ('Sarmista', 'Sharma', 26, 'F', 10000.0), 
    ('Tripthi', 'Mishra', 24, 'F', 6000.0)
 ]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite\u5220\u9664\u6570\u636e<\/h2>\n
\n    \u8981\u4eceSQLite\u8868\u4e2d\u5220\u9664\u8bb0\u5f55\uff0c\u4f60\u9700\u8981\u4f7f\u7528DELETE FROM\u8bed\u53e5\u3002\u8981\u5220\u9664\u7279\u5b9a\u8bb0\u5f55\uff0c\u4f60\u9700\u8981\u4e0e\u5176\u4e00\u8d77\u4f7f\u7528WHERE\u5b50\u53e5\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n
 DELETE from <\/span>table_name [WHERE Clause]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u4f8b\u5982\uff1a<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u6211\u4eec\u4f7f\u7528INSERT\u8bed\u53e5\u5c065\u6761\u8bb0\u5f55\u63d2\u5165\u5176\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span><\/span>, 'India'<\/span><\/span><\/span>);
 sqlite> insert into CRICKETERS values('Jonathan'<\/span>, 'Trott'<\/span>, 38, 'CapeTown'<\/span>, 'SouthAfrica'<\/span>);
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi', 'India');
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0b\u8bed\u53e5\u5220\u9664\u59d3\u201c Sangakkara\u201d\u7684\u677f\u7403\u8fd0\u52a8\u5458\u7684\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> DELETE from <\/span>CRICKETERS WHERE LAST_NAME = 'Sangakkara'<\/span>;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u4f7f\u7528SELECT\u8bed\u53e5\u68c0\u7d22\u8868\u7684\u5185\u5bb9\uff0c\u5219\u7531\u4e8e\u6211\u4eec\u5df2\u5220\u9664\u4e00\u6761\u8bb0\u5f55\uff0c\u56e0\u6b64\u53ea\u80fd\u770b\u52304\u6761\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   --------\r\nShikhar      Dhawan       46     Delhi        India\r\nJonathan     Trott        39     CapeTown     SouthAfrica\r\nVirat        Kohli        31     Delhi        India\r\nRohit        Sharma       33     Nagpur       India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u5982\u679c\u6267\u884c\u4e0d\u5e26WHERE\u5b50\u53e5\u7684DELETE FROM\u8bed\u53e5\uff0c\u5219\u5c06\u5220\u9664\u6307\u5b9a\u8868\u4e2d\u7684\u6240\u6709\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> DELETE from <\/span>CRICKETERS;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u7531\u4e8e\u5df2\u5220\u9664\u6240\u6709\u8bb0\u5f55\uff0c\u56e0\u6b64\uff0c\u5982\u679c\u5c1d\u8bd5\u68c0\u7d22CRICKETERS\u8868\u7684\u5185\u5bb9\uff0c\u5219\u4f7f\u7528SELECT\u8bed\u53e5\uff0c\u4f60\u5c06\u83b7\u5f97\u4e00\u4e2a\u7a7a\u7ed3\u679c\u96c6\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> SELECT * from <\/span>CRICKETERS;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u4f7f\u7528Python\u5220\u9664\u6570\u636e<\/h2>\n
\n    \u8981\u5c06\u8bb0\u5f55\u6dfb\u52a0\u5230SQLite\u6570\u636e\u5e93\u4e2d\u7684\u73b0\u6709\u8868\u4e2d-\n  <\/div>\n
  \u5bfc\u5165sqlite3\u5305\u3002<\/span>
\n  \u901a\u8fc7\u5c06\u6570\u636e\u5e93\u540d\u79f0\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9\u5b83\uff0c\u4f7f\u7528connect\uff08\uff09\u65b9\u6cd5\u521b\u5efa\u4e00\u4e2a\u8fde\u63a5\u5bf9\u8c61\u3002<\/span>
\n  cursor()\u65b9\u6cd5\u8fd4\u56de\u4f7f\u7528\u4f60\u53ef\u4ee5\u4e0esqlite3\u7684\u901a\u4fe1\u7684\u5149\u6807\u5bf9\u8c61\u3002\u901a\u8fc7\u8c03\u7528\uff08\u4e0a\u9762\u521b\u5efa\u7684\uff09Connection\u5bf9\u8c61\u4e0a\u7684cursor\uff08\uff09\u5bf9\u8c61\u6765\u521b\u5efa\u5149\u6807\u5bf9\u8c61\u3002<\/span>
\n  \u7136\u540e\uff0c\u901a\u8fc7\u5c06\u6e38\u6807\u5bf9\u8c61\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9DELETE\u8bed\u53e5\uff0c\u4ece\u800c\u5728\u6e38\u6807\u5bf9\u8c61\u4e0a\u8c03\u7528execute\uff08\uff09\u65b9\u6cd5\u3002<\/span> <\/p>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4ee5\u4e0bpython\u793a\u4f8b\u4eceEMPLOYEE\u8868\u4e2d\u5220\u9664\u5e74\u9f84\u503c\u5927\u4e8e25\u7684\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u68c0\u7d22\u8868\u7684\u5185\u5bb9
<\/span> print(\"Contents of the table: \"<\/span>)
 cursor.execute<\/span>(''<\/span><\/span><\/span><\/span>'SELECT * from <\/span>EMPLOYEE'<\/span>'')
 print(cursor.fetchall<\/span>())
 # \u5220\u9664\u8bb0\u5f55
<\/span> cursor.execute<\/span>('''DELETE from <\/span>EMPLOYEE WHERE AGE > 25'<\/span>'')
 # \u5220\u9664\u540e\u68c0\u7d22\u6570\u636e
<\/span> print(\"Contents of the table after delete operation \"<\/span>)
 cursor.execute<\/span>(\"SELECT * from <\/span>EMPLOYEE\"<\/span>)
 print(cursor.fetchall<\/span>())
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u679c\uff1a<\/h3>\n
\n
 Contents of the table:
 [
    ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span><\/span><\/span><\/span>, 9000.0), 
    ('Vinay'<\/span><\/span>, 'Battacharya'<\/span><\/span>, 21, 'M'<\/span><\/span><\/span>, 6000.0), 
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 26, 'M', 8300.0), 
    ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000.0), 
    ('Tripthi'<\/span><\/span>, 'Mishra'<\/span><\/span>, 24, 'F', 6000.0)
 ]
 Contents of the table after delete operation
 [
    ('Vinay', 'Battacharya', 21, 'M', 6000.0), 
    ('Tripthi', 'Mishra', 24, 'F', 6000.0)
 ]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite\u5220\u9664\u8868<\/h2>\n
\n    \u4f60\u53ef\u4ee5\u4f7f\u7528DROP TABLE\u8bed\u53e5\u5220\u9664\u6574\u4e2a\u8868\u3002\u4f60\u53ea\u9700\u8981\u6307\u5b9a\u8981\u5220\u9664\u7684\u8868\u7684\u540d\u79f0\u5373\u53ef\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n
 DROP TABLE table_name;
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e24\u4e2a\u540d\u4e3aCRICKETERS\u548cEMPLOYEES\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255), Last_Name VARCHAR(255), Age int, 
    Place_Of_Birth VARCHAR(255), Country <\/span>VARCHAR(255)
 );
 sqlite> CREATE TABLE EMPLOYEE(
    FIRST_NAME CHAR(20) not <\/span>NULL, LAST_NAME CHAR(20), AGE INT, 
    SEX CHAR(1), INCOME FLOAT
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u73b0\u5728\uff0c\u5982\u679c\u4f60\u4f7f\u7528.tables\u547d\u4ee4\u9a8c\u8bc1\u8868\u5217\u8868\uff0c\u5219\u53ef\u4ee5\u5728\u5176\u4e2d\uff08\u5217\u8868\uff09\u770b\u5230\u4e0a\u9762\u521b\u5efa\u7684\u8868\uff0c\u5982\u4e0b\u6240\u793a\uff1a\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> .tables
 CRICKETERS EMPLOYEE
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0b\u8bed\u53e5\u4ece\u6570\u636e\u5e93\u4e2d\u5220\u9664\u540d\u4e3aEmployee\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> DROP table employee;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u7531\u4e8e\u5df2\u5220\u9664Employee\u8868\uff0c\u56e0\u6b64\uff0c\u5982\u679c\u518d\u6b21\u68c0\u7d22\u8868\u5217\u8868\uff0c\u5219\u53ea\u80fd\u89c2\u5bdf\u5176\u4e2d\u7684\u4e00\u4e2a\u8868\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> .tables
 CRICKETERS
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u4f60\u5c1d\u8bd5\u518d\u6b21\u5220\u9664Employee\u8868\uff0c\u5219\u7531\u4e8e\u5df2\u5c06\u5176\u5220\u9664\uff0c\u4f60\u5c06\u6536\u5230\u4e00\u6761\u9519\u8bef\u6d88\u606f\uff0c\u63d0\u793a\u201c\u65e0\u6b64\u7c7b\u8868\u201d\uff0c\u5982\u4e0b\u6240\u793a-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> DROP table employee;
 Error: no such table: employee
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u82e5\u8981\u89e3\u51b3\u6b64\u95ee\u9898\uff0c\u53ef\u4ee5\u5c06IF EXISTS\u5b50\u53e5\u4e0eDELETE\u8bed\u53e5\u4e00\u8d77\u4f7f\u7528\u3002\u5982\u679c\u5b58\u5728\u8be5\u8868\uff0c\u5219\u5c06\u5176\u5220\u9664\uff0c\u5426\u5219\u5c06\u8df3\u8fc7DELETE\u64cd\u4f5c\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> DROP table if <\/span>EXISTS employee;
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u4f7f\u7528Python\u5220\u9664\u8868<\/h2>\n
\n    \u4f60\u53ef\u4ee5\u5728\u4efb\u4f55\u65f6\u5019\u4f7f\u7528MYSQL\u7684DROP\u8bed\u53e5\u5220\u9664\u8868\uff0c\u4f46\u662f\u5728\u5220\u9664\u4efb\u4f55\u73b0\u6709\u8868\u65f6\u8981\u975e\u5e38\u5c0f\u5fc3\uff0c\u56e0\u4e3a\u4e22\u5931\u7684\u6570\u636e\u5728\u5220\u9664\u8868\u540e\u5c06\u65e0\u6cd5\u6062\u590d\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u8981\u4f7f\u7528python\u4eceSQLite3\u6570\u636e\u5e93\u4e2d\u5220\u9664\u8868\uff0c\u8bf7\u5728\u6e38\u6807\u5bf9\u8c61\u4e0a\u8c03\u7528execute\uff08\uff09\u65b9\u6cd5\uff0c\u5e76\u5c06drop\u8bed\u53e5\u4f5c\u4e3a\u53c2\u6570\u4f20\u9012\u7ed9\u8be5\u5bf9\u8c61\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u5220\u9664\u5df2\u5b58\u5728\u7684\u8868
 <\/span> cursor.execute<\/span>(\"DROP TABLE emp\"<\/span>)
 print(\"Table dropped... \"<\/span>)
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u679c\uff1a<\/h3>\n
\n
 Table dropped...
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite Limit<\/h2>\n
\n    \u5728\u83b7\u53d6\u8bb0\u5f55\u65f6\uff0c\u5982\u679c\u4f60\u60f3\u901a\u8fc7\u7279\u5b9a\u6570\u91cf\u9650\u5236\u5b83\u4eec\uff0c\u53ef\u4ee5\u4f7f\u7528SQLite\u7684LIMIT\u5b50\u53e5\u6765\u5b9e\u73b0\u3002\n  <\/div>\n
\u8bed\u6cd5<\/h3>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 SELECT column1, column2, columnN
 from <\/span>table_name
 LIMIT [no of rows]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u5982\u679c\u6211\u4eec\u4f7f\u7528INSERT\u8bed\u53e5\u5c065\u6761\u8bb0\u5f55\u63d2\u5165\u5176\u4e2d-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> insert into CRICKETERS values('Shikhar'<\/span>, 'Dhawan'<\/span>, 33, 'Delhi'<\/span><\/span>, 'India'<\/span><\/span><\/span>);
 sqlite> insert into CRICKETERS values('Jonathan'<\/span>, 'Trott'<\/span>, 38, 'CapeTown'<\/span>, 'SouthAfrica'<\/span>);
 sqlite> insert into CRICKETERS values('Kumara'<\/span>, 'Sangakkara'<\/span>, 41, 'Matale'<\/span>, 'Srilanka'<\/span>);
 sqlite> insert into CRICKETERS values('Virat'<\/span>, 'Kohli'<\/span>, 30, 'Delhi', 'India');
 sqlite> insert into CRICKETERS values('Rohit'<\/span>, 'Sharma'<\/span>, 32, 'Nagpur'<\/span>, 'India');
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0b\u8bed\u53e5\u4f7f\u7528LIMIT\u5b50\u53e5\u68c0\u7d22Cricketers\u8868\u7684\u524d3\u6761\u8bb0\u5f55-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS LIMIT 3;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   -------------\r\nShikhar      Dhawan       33     Delhi        India\r\nJonathan     Trott        38     CapeTown     SouthAfrica\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\n    \u5982\u679c\u4f60\u9700\u8981\u9650\u5236\u4ece\u7b2cn\u8bb0\u5f55\uff08\u4e0d\u662f1\u5f00\u59cb\u8bb0\u5f55ST\uff09\uff0c\u4f60\u53ef\u4ee5\u8fd9\u6837\u505a\uff0c\u4f7f\u7528\u5e26\u6709LIMIT\u4e00\u8d77\u62b5\u6d88\u3002\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT * FROM CRICKETERS LIMIT 3 OFFSET 2;\r\nFirst_Name   Last_Name    Age    Place_Of_B   Country\r\n----------   ----------   ----   ----------   --------\r\nKumara       Sangakkara   41     Matale       Srilanka\r\nVirat        Kohli        30     Delhi        India\r\nRohit        Sharma       32     Nagpur       India\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
Python LIMIT \u7528\u6cd5<\/h2>\n
\n    \u5982\u679c\u901a\u8fc7\u4f20\u9012SELECT\u67e5\u8be2\u548cLIMIT\u5b50\u53e5\u5728\u6e38\u6807\u5bf9\u8c61\u4e0a\u8c03\u7528execute\uff08\uff09\u65b9\u6cd5\uff0c\u5219\u53ef\u4ee5\u68c0\u7d22\u6240\u9700\u6570\u91cf\u7684\u8bb0\u5f55\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u4ee5\u4e0bpython\u793a\u4f8b\u4f7f\u7528LIMIT\u5b50\u53e5\u68c0\u7d22EMPLOYEE\u8868\u7684\u524d\u4e24\u4e2a\u8bb0\u5f55\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u68c0\u7d22\u5355\u884c
<\/span> sql = ''<\/span><\/span>'SELECT * from <\/span>EMPLOYEE LIMIT 3'<\/span>''
 # \u6267\u884c\u67e5\u8be2
<\/span> cursor.execute<\/span>(sql)
 # \u83b7\u53d6\u6570\u636e
<\/span> result = cursor.fetchall<\/span>();
 print(result)
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8f93\u51fa\u7ed3\u679c\uff1a<\/h3>\n
\n
 [
    ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span>, 9000.0), 
    ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000.0), 
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300.0)
 ]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite join\u8fde\u63a5<\/h2>\n
\n    \u5c06\u6570\u636e\u5206\u4e3a\u4e24\u4e2a\u8868\u540e\uff0c\u53ef\u4ee5\u4f7f\u7528\u8054\u63a5\u4ece\u8fd9\u4e24\u4e2a\u8868\u4e2d\u83b7\u53d6\u7ec4\u5408\u8bb0\u5f55\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h3>\n
\n    \u5047\u8bbe\u6211\u4eec\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3aCRICKETERS\u7684\u8868-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE CRICKETERS (
    First_Name VARCHAR(255),
    Last_Name VARCHAR(255),
    Age int,
    Place_Of_Birth VARCHAR(255),
    Country <\/span>VARCHAR(255)
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u8ba9\u6211\u4eec\u518d\u521b\u5efa\u4e00\u4e2a\u8868OdiStats\uff0c\u7528\u4e8e\u63cf\u8ff0CRICKETERS\u8868\u4e2d\u6bcf\u4e2a\u7403\u5458\u7684\u4e00\u65e5\u677f\u7403\u7edf\u8ba1\u6570\u636e\u3002\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 sqlite> CREATE TABLE ODIStats (
    First_Name VARCHAR(255),
    Matches INT,
    Runs INT,
    AVG FLOAT,
    Centuries INT,
    HalfCenturies INT
 );
 sqlite>
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\n    \u4ee5\u4e0b\u8bed\u53e5\u68c0\u7d22\u7ed3\u5408\u8fd9\u4e24\u4e2a\u8868\u4e2d\u7684\u503c\u7684\u6570\u636e-\n  <\/div>\n
\n
 
\r\n# Filename : example.py<\/span>\r\n# Copyright : 2020 By Lidihuo<\/span>\r\n# Author by : www.lidihuo.com<\/span>\r\n# Date : 2020-08-15<\/span>\r\nsqlite> SELECT\r\n   Cricketers.First_Name, Cricketers.Last_Name, Cricketers.Country,\r\n   OdiStats.matches, OdiStats.runs, OdiStats.centuries, OdiStats.halfcenturies\r\n   from Cricketers INNER JOIN OdiStats ON Cricketers.First_Name = OdiStats.First_Name;\r\nFirst_Name  Last_Name   Country  Matches  Runs   Centuries   HalfCenturies\r\n----------  ----------  -------  -------  ----   ---------   -------------- \r\nShikhar     Dhawan      Indi     133      5518   17          27\r\nJonathan    Trott       Sout     68       2819   4           22\r\nKumara      Sangakkara  Sril     404      14234  25          93\r\nVirat       Kohli       Indi     239      11520  43          54\r\nRohit       Sharma      Indi     218      8686   24          42\r\nsqlite><\/pre>\n
 <\/span><\/code>\n  <\/div>\n
\u4f7f\u7528Python\u52a0\u5165\u5b50\u53e5<\/h2>\n
\n    \u4ee5\u4e0bSQLite\u793a\u4f8b\uff0c\u4f7f\u7528python\u6f14\u793a\u4e86JOIN\u5b50\u53e5-\n  <\/div>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 # \u68c0\u7d22\u6570\u636e
<\/span> sql = ''<\/span><\/span>'SELECT * from <\/span>EMP INNER JOIN CONTACT ON EMP.CONTACT = CONTACT.ID'<\/span>''
 # \u6267\u884c\u67e5\u8be2
<\/span> cursor.execute<\/span>(sql)
 # \u6b63\u5728\u4ece\u8868\u4e2d\u83b7\u53d6\u7b2c\u4e00\u884c
<\/span> result = cursor.fetchall<\/span>();
 print(result)
 # \u5728\u6570\u636e\u5e93\u4e2d\u63d0\u4ea4\u66f4\u6539
<\/span> conn.commit<\/span>()
 # \u5173\u95ed\u8fde\u63a5
<\/span> conn.close<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u8fd0\u884c\u7ed3\u679c\uff1a<\/h3>\n
\n
 [
    ('Ramya'<\/span>, 'Rama priya'<\/span>, 27, 'F'<\/span><\/span>, 9000.0, 101, 101, 'Krishna@mymail.com'<\/span><\/span>, 'Hyderabad'<\/span>), 
    ('Vinay'<\/span>, 'Battacharya'<\/span>, 20, 'M'<\/span><\/span>, 6000.0, 102, 102,'Raja@mymail.com'<\/span><\/span>, 'Vishakhapatnam'<\/span>), 
    ('Sharukh'<\/span>, 'Sheik'<\/span>, 25, 'M', 8300.0, 103, 103, 'Krishna@mymail.com', 'Pune'<\/span>), 
    ('Sarmista'<\/span>, 'Sharma'<\/span>, 26, 'F', 10000.0, 104, 104, 'Raja@mymail.com', 'Mumbai'<\/span>)
 ]
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
SQLite\u6e38\u6807<\/h2>\n
\n    sqlite3.Cursor\u7c7b\u662f\u4e00\u4e2a\u5b9e\u4f8b\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528\u8be5\u5b9e\u4f8b\u8c03\u7528\u6267\u884cSQLite\u8bed\u53e5\u7684\u65b9\u6cd5\uff0c\u4ece\u67e5\u8be2\u7684\u7ed3\u679c\u96c6\u4e2d\u83b7\u53d6\u6570\u636e\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528Connection\u5bf9\u8c61\/\u7c7b\u7684cursor\uff08\uff09\u65b9\u6cd5\u521b\u5efaCursor\u5bf9\u8c61\u3002\n  <\/div>\n
\u5b9e\u4f8b<\/h2>\n
\n
 # Filename : example.py<\/span>
# Copyright : 2020 By Lidihuo<\/span>
# Author by : www.lidihuo.com<\/span>
# Date : 2020-08-15<\/span>
 import <\/span>sqlite3
 # \u8fde\u63a5sqlite
<\/span> conn = sqlite3.connect<\/span>('example.db'<\/span>)
 # \u4f7f\u7528cursor()\u65b9\u6cd5\u521b\u5efa\u6e38\u6807\u5bf9\u8c61
<\/span> cursor = conn.cursor<\/span>()
 <\/span><\/code><\/pre>\n<\/p><\/div>\n
\u65b9\u6cd5<\/h2>\n
\n    \u4ee5\u4e0b\u662fCursor\u7c7b\/\u5bf9\u8c61\u63d0\u4f9b\u7684\u5404\u79cd\u65b9\u6cd5\u3002\n  <\/div>\n\n\n\n\n\n\n\n\n
\u65b9\u6cd5<\/td>\n\u63cf\u8ff0<\/td>\n<\/tr>\n
execute()<\/td>\n \u8be5\u4f8b\u7a0b\u6267\u884c\u4e00\u6761SQL\u8bed\u53e5\u3002\u53ef\u4ee5\u5bf9SQL\u8bed\u53e5\u8fdb\u884c\u53c2\u6570\u5316\uff08\u5373\uff0c\u4f7f\u7528\u5360\u4f4d\u7b26\u4ee3\u66ffSQL\u6587\u5b57\uff09\u3002psycopg2\u6a21\u5757\u4f7f\u7528\uff05s\u7b26\u53f7\u652f\u6301\u5360\u4f4d\u7b26 \u4f8b\u5982\uff1acursor.execute(\"insert into people values (%s, %s)\", (who, age)) <\/td>\n<\/tr>\n
executemany()<\/td>\n \u6b64\u4f8b\u7a0b\u9488\u5bf9\u5e8f\u5217sql\u4e2d\u627e\u5230\u7684\u6240\u6709\u53c2\u6570\u5e8f\u5217\u6216\u6620\u5c04\u6267\u884cSQL\u547d\u4ee4\u3002 <\/td>\n<\/tr>\n
fetchone()<\/td>\n \u6b64\u65b9\u6cd5\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u96c6\u7684\u4e0b\u4e00\u884c\uff0c\u8fd4\u56de\u5355\u4e2a\u5e8f\u5217\uff0c\u5982\u679c\u6ca1\u6709\u66f4\u591a\u6570\u636e\u53ef\u7528\uff0c\u5219\u8fd4\u56deNone\u3002 <\/td>\n<\/tr>\n
fetchmany()<\/td>\n \u8be5\u4f8b\u7a0b\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u7684\u4e0b\u4e00\u7ec4\u884c\uff0c\u5e76\u8fd4\u56de\u4e00\u4e2a\u5217\u8868\u3002\u5f53\u6ca1\u6709\u66f4\u591a\u884c\u53ef\u7528\u65f6\uff0c\u5c06\u8fd4\u56de\u4e00\u4e2a\u7a7a\u5217\u8868\u3002\u8be5\u65b9\u6cd5\u5c1d\u8bd5\u83b7\u53d6\u7531size\u53c2\u6570\u6307\u793a\u7684\u5c3d\u53ef\u80fd\u591a\u7684\u884c\u3002 <\/td>\n<\/tr>\n
fetchall()<\/td>\n \u8be5\u4f8b\u7a0b\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\u7684\u6240\u6709\uff08\u5269\u4f59\uff09\u884c\uff0c\u5e76\u8fd4\u56de\u4e00\u4e2a\u5217\u8868\u3002\u5982\u679c\u6ca1\u6709\u53ef\u7528\u7684\u884c\uff0c\u5219\u8fd4\u56de\u4e00\u4e2a\u7a7a\u5217\u8868\u3002 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u5c5e\u6027<\/h2>\n
\n    \u4ee5\u4e0b\u662fCursor\u7c7b\u7684\u5c5e\u6027-\n  <\/div>\n\n\n\n\n\n\n\n\n
\u65b9\u6cd5<\/td>\n\u63cf\u8ff0<\/td>\n<\/tr>\n
arraySize<\/td>\n\n
\n        \u8fd9\u662f\u4e00\u4e2a\u8bfb\/\u5199\u5c5e\u6027\uff0c\u4f60\u53ef\u4ee5\u8bbe\u7f6efetchmany()\u65b9\u6cd5\u8fd4\u56de\u7684\u884c\u6570\u3002\n      <\/div>\n<\/td>\n<\/tr>\n
description<\/td>\n\n
\n        \u8fd9\u662f\u4e00\u4e2a\u53ea\u8bfb\u5c5e\u6027\uff0c\u5b83\u8fd4\u56de\u5305\u542b\u7ed3\u679c\u96c6\u4e2d\u5217\u8bf4\u660e\u7684\u5217\u8868\u3002\n      <\/div>\n<\/td>\n<\/tr>\n
lastrowid<\/td>\n\n
\n        \u8fd9\u662f\u4e00\u4e2a\u53ea\u8bfb\u5c5e\u6027\uff0c\u5982\u679c\u8868\u4e2d\u6709\u4efb\u4f55\u81ea\u52a8\u9012\u589e\u7684\u5217\uff0c\u5b83\u5c06\u8fd4\u56de\u5728\u4e0a\u4e00\u6b21INSERT\u6216UPDATE\u64cd\u4f5c\u4e2d\u4e3a\u8be5\u5217\u751f\u6210\u7684\u503c\u3002\n      <\/div>\n<\/td>\n<\/tr>\n
rowcount<\/td>\n\n
\n        \u5982\u679c\u6267\u884cSELECT\u548cUPDATE\u64cd\u4f5c\uff0c\u5219\u8fd4\u56de\u8fd4\u56de\/\u66f4\u65b0\u7684\u884c\u6570\u3002\n      <\/div>\n<\/td>\n<\/tr>\n
connection<\/td>\n\n
\n        \u6b64\u53ea\u8bfb\u5c5e\u6027\u63d0\u4f9bCursor\u5bf9\u8c61\u4f7f\u7528\u7684SQLite\u6570\u636e\u5e93\u8fde\u63a5\u3002\n      <\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/body>
\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"Python SQLitezh-cn","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[126],"tags":[],"class_list":["post-1055","post","type-post","status-publish","format-standard","hentry","category-python3"],"_links":{"self":[{"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/posts\/1055"}],"collection":[{"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/comments?post=1055"}],"version-history":[{"count":0,"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/posts\/1055\/revisions"}],"wp:attachment":[{"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/media?parent=1055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/categories?post=1055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bianchenghao6.com\/wp-json\/wp\/v2\/tags?post=1055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}