python3操作mysql用什么库 Python 访问 MySQL 数据库可以使用哪些第三方实现...
\u5982\u4f55\u7528python3\u8fde\u63a5mysql\u6570\u636e\u5e93\u5728 Python \u8bed\u8a00\u73af\u5883\u4e0b\u6211\u4eec\u8fd9\u6837\u8fde\u63a5\u6570\u636e\u5e93\u3002
In [1]: from mysql import connector
In [2]: cnx = connector.connect(host="172.16.192.100",port=3306,user="appuser",password="xxxxxx")
\u4f46\u662f\u8fde\u63a5\u6570\u636e\u5e93\u7684\u80cc\u540e\u53d1\u751f\u4e86\u4ec0\u4e48\u5462\uff1f
\u7b54\u6848
\u5f53\u6211\u4eec\u901a\u8fc7\u9a71\u52a8\u7a0b\u5e8f\uff08mysql-connector-python,pymysql\uff09\u8fde\u63a5 MySQL \u670d\u52a1\u7aef\u7684\u65f6\u5019\uff0c\u5c31\u662f\u628a\u8fde\u63a5\u53c2\u6570\u4f20\u9012\u7ed9\u9a71\u52a8\u7a0b\u5e8f\uff0c\u9a71\u52a8\u7a0b\u5e8f\u518d\u6839\u636e\u53c2\u6570\u4f1a\u53d1\u8d77\u5230 MySQL \u670d\u52a1\u7aef\u7684 TCP \u8fde\u63a5\u3002\u5f53 TCP \u8fde\u63a5\u5efa\u7acb\u4e4b\u540e\u9a71\u52a8\u7a0b\u5e8f\u4e0e\u670d\u52a1\u7aef\u4e4b\u95f4\u4f1a\u6309\u7279\u5b9a\u7684\u683c\u5f0f\u548c\u6b21\u5e8f\u4ea4\u6362\u6570\u636e\u5305\uff0c\u6570\u636e\u5305\u7684\u683c\u5f0f\u548c\u53d1\u9001\u6b21\u5e8f\u7531 MySQL \u534f\u8bae \u89c4\u5b9a\u3002MySQL \u534f\u8bae\uff1ahttps://dev.mysql.com/doc/internals/en/client-server-protocol.html\u6574\u4e2a\u8fde\u63a5\u7684\u8fc7\u7a0b\u4e2d MySQL \u670d\u52a1\u7aef\u4e0e\u9a71\u52a8\u7a0b\u5e8f\u4e4b\u95f4\uff0c\u6309\u5982\u4e0b\u7684\u6b21\u5e8f\u53d1\u9001\u4e86\u8fd9\u4e9b\u5305\u3002
MySQL \u670d\u52a1\u7aef\u5411\u5ba2\u6237\u7aef\u53d1\u9001\u4e00\u4e2a\u63e1\u624b\u5305\uff0c\u5305\u91cc\u8bb0\u5f55\u4e86 MySQL-Server \u7684\u7248\u672c\uff0c\u9ed8\u8ba4\u7684\u6388\u6743\u63d2\u4ef6\uff0c\u5bc6\u7801\u76d0\u503c\uff08auth-data\uff09\u3002
2. MySQL \u5ba2\u6237\u7aef\u53d1\u51fa ssl \u8fde\u63a5\u8bf7\u6c42\u5305\uff08\u5982\u679c\u6709\u5fc5\u8981\u7684\u8bdd\uff09\u3002
3. MySQL \u5ba2\u6237\u7aef\u53d1\u51fa\u63e1\u624b\u5305\u7684\u54cd\u5e94\u5305\uff0c\u8fd9\u4e2a\u5305\u65f6\u8bb0\u5f55\u4e86\u7528\u6237\u540d\uff0c\u5bc6\u7801\u52a0\u5bc6\u540e\u7684\u4e32\uff0c\u5ba2\u6237\u7aef\u5c5e\u6027\uff0c\u7b49\u7b49\u5176\u5b83\u4fe1\u606f\u3002
4. MySQL \u670d\u52a1\u7aef\u53d1\u51fa\u54cd\u5e94\u5305\uff0c\u8fd9\u4e2a\u5305\u91cc\u8bb0\u5f55\u4e86\u767b\u5f55\u662f\u5426\u6210\u529f\uff0c\u5982\u679c\u6ca1\u6709\u6210\u529f\u4e5f\u4f1a\u7ed9\u51fa\u9519\u8bef\u4fe1\u606f\u3002
MySQLdbMySQLdb\u662f Python \u8fde\u63a5 MySQL \u6700\u6d41\u884c\u7684\u4e00\u4e2a\u9a71\u52a8\uff0c\u5f88\u591a\u6846\u67b6\u90fd\u4e5f\u662f\u57fa\u4e8e\u6b64\u5e93\u8fdb\u884c\u5f00\u53d1\uff0c\u9057\u61be\u7684\u662f\u5b83\u53ea\u652f\u6301 Python2.x\uff0c\u5b83\u662f\u57fa\u4e8eC\u5f00\u53d1\u7684\u5e93\uff0c\u548cWindows \u5e73\u53f0\u7684\u517c\u5bb9\u6027\u4e0d\u53cb\u597d\uff0c\u73b0\u5728\u57fa\u672c\u4e0d\u63a8\u8350\u4f7f\u7528\uff0c\u53d6\u4ee3\u7684\u662f\u5b83\u7684\u884d\u751f\u7248\u672c\u3002mysqlclient\u7531\u4e8e MySQLdb \u5e74\u4e45\u5931\u4fee\uff0c\u540e\u6765\u51fa\u73b0\u4e86\u5b83\u7684 Fork \u7248\u672c mysqlclient\uff0c\u5b8c\u5168\u517c\u5bb9 MySQLdb\uff0c\u540c\u65f6\u652f\u6301 Python3.x\uff0c\u662f Django ORM\u7684\u4f9d\u8d56\u5de5\u5177\uff0c\u5982\u679c\u4f60\u60f3\u4f7f\u7528\u539f\u751f SQL \u6765\u64cd\u4f5c\u6570\u636e\u5e93\uff0c\u90a3\u4e48\u63a8\u8350\u6b64\u9a71\u52a8\u3002PyMySQLPyMySQL\u662f\u7eaf Python \u5b9e\u73b0\u7684\u9a71\u52a8\uff0c\u901f\u5ea6\u4e0a\u6bd4\u4e0d\u4e0a MySQLdb\uff0c\u6700\u5927\u7684\u7279\u70b9\u53ef\u80fd\u5c31\u662f\u5b83\u7684\u5b89\u88c5\u65b9\u5f0f\u6ca1\u90a3\u4e48\u7e41\u7410\uff0c\u540c\u65f6\u4e5f\u517c\u5bb9 MySQLdb\u3002SQLAlchemySQLAlchemy\u662f\u4e00\u79cd\u65e2\u652f\u6301\u539f\u751f SQL\uff0c\u53c8\u652f\u6301 ORM \u7684\u5de5\u5177\uff0c\u5b83\u975e\u5e38\u63a5\u8fd1 Java \u4e2d\u7684 Hibernate \u6846\u67b6\u3002\u6709\u5173Python\u8bbf\u95eeMySQL\u6570\u636e\u5e93\u5168\u90e8\u5185\u5bb9\u7684\u5b66\u4e60\uff0c\u6211\u90fd\u662f\u901a\u8fc7\u9ed1\u9a6c\u7a0b\u5e8f\u5458\u7684\u89c6\u9891\u5b66\u7684\u3002\u770b\u5b8c\u4e4b\u540e\u7acb\u9a6c\u51b3\u5b9a\u53bb\u57f9\u8bad\u4e86\u3002\u4f60\u53ef\u4ee5\u641c\u641c\uff0c\u90fd\u662f\u514d\u8d39\u8d44\u6e90\u3002\u9ed1\u9a6c\u89c6\u9891\u5e93\u91cc\u9762\u641c\u7d22\u4e00\u4e0b\uff0c\u627e\u4e0d\u5230\u7684\u8bdd\u5b98\u7f51\u5f39\u51fa\u6765\u7684\u5bf9\u8bdd\u6846\u95ee\u4e00\u4e0b\u5c31\u4e0d\u4f1a\u8ff7\u8def\u4e86\u3002
python3使用PyMysql连接mysql数据库python语言的3 x完全不向前兼容,导致我们在python2 x中可以正常使用的库,到了python3就用不了了 比如说mysqldb目前MySQLdb并不支持python3
python语言的3.x完全不向前兼容,导致我们在python2.x中可以正常使用的库,到了python3就用不了了.比如说mysqldb
目前MySQLdb并不支持python3.x ， Python3.x连接MySQL的方案有：oursql, PyMySQL, myconnpy 等
下面来说下python3如何安装和使用pymysql，另外两个方案我会在以后再讲。
1.pymysql安装
pymysql就是作为python3环境下mysqldb的替代物,进入命令行,使用pip安装pymysql
pip install pymysql3
2.pymysql使用
如果想使用mysqldb的方式，那么直接在py文件的开头加入如下两行代码即可。
#引入pymysql
import pymysql
#当成是mysqldb一样使用，当然也可以不写这句，那就按照pymysql的方式
pymysql.install_as_MySQLdb()
绛旓細2銆乸ymysql瀹夎鏂规硶涓猴細瑙ｅ帇涓嬭浇鐨勬枃浠讹紝鍦╟md涓繍琛: python setup.py install銆傛楠屽畨瑁呭畨瑁呮槸鍚︽垚鍔熺殑鏂规硶锛歩mport pymysql 銆 濡傛灉涓嶆姤閿 璇存槑瀹夎鎴愬姛銆3銆乵ysql瀹夎鐩綍涓篋:/phpStudy/MySQL銆備负閬垮厤鏇村閰嶇疆闂锛屽彲鍦ㄥ惎鍔╬hpstudy鍚庯紝灏嗗叾璁句负绯荤粺鏈嶅姟 4銆佸熀鏈鎿嶄綔锛氾紙1锛夊鍏ymysql: import...
绛旓細python3鍙戝竷浠ユ潵锛岃幏鍙栦簡骞垮ぇ绋嬪簭鍛樹滑鐨勫樊璇勶紝璇翠笉绋冲畾锛屽張鏄笉鍏煎浠涔堢殑锛屼笉杩囧樊璇勫綊宸瘎锛宲ython3鏃㈢劧宸茬粡鍙戝竷锛岃偗瀹氭槸涓秼鍔匡紝浣鍦╬ython3.4閲岄潰锛浣跨敤鍘熸潵python2.7鐨刴ysqldb宸茬粡涓嶈兘杩炴帴mysql鏁版嵁搴撲簡锛屾瘮杈冧护浜虹籂缁擄紝涓嶈繃鎴戜滑鍙互浣跨敤pymysql锛屾潵瀹屾垚杩炴帴mysql鐨閲嶄换锛屾楠ゅ涓嬶細搴忓彿鎻忚堪 1鍘籫ithub涓...
绛旓細step3. 瀹夎锛歝d MySQL-python-1.2.3python setup.py build 杩欓噷鏈夋姤閿欙細EnvironmentError: mysql_config not found 瑙ｅ喅鏂规硶鏄細棣栧厛鎵惧埌 mysql_config 鐨勪綅缃甪ind / -name mysql_config 鎵惧埌涔嬪悗 鎷疯礉璇ヨ矾寰/usr/local/mysql-5.7.10-osx10.9-x86_64/bin/mysql_config 鐒跺悗淇敼 setup_posix.py ...
绛旓細1锛塸ython setup.py build 鑻ユ湭鎴愬姛鐨勮瘽锛岄渶鎵嬪姩瀹夎setuptools锛歴udo apt-get install python-setuptools2锛塻udo python setup.py install 5銆佹祴璇 python >>> import MySQLdb 娌℃湁閿欒锛屽垯琛ㄧず瀹夎鎴愬姛浜嗐浣跨敤python鎿嶄綔MySQL 浣跨敤python杩炴帴MySQL锛屽垱寤烘暟鎹簱锛屽垱寤鸿〃鏍硷紝鎻掑叆/鏌ヨ鏁版嵁銆俻ython_mysql.py...
绛旓細)#鍏抽棴娓告爣 conn.close()#閲婃斁鏁版嵁搴撹祫婧 except Exception :print("鍙戠敓寮傚父")result 锛欴:\python\python.exe D:/pythonide/pythonprojectworkspace/python/mysql.py ID: 1 name锛 dd gender锛 male ID: 2 name锛 ss gender锛 female Process finished with exit code 0 ...
绛旓細鎵撳紑鎺у埗闈㈡澘鎵惧埌绠＄悊宸ュ叿锛屽鏋滃湪鎺у埗闈㈡澘涓嬬湅涓嶅埌绠＄悊宸ュ叿锛屽彲浠ラ夋嫨绐楀彛鍙充笂瑙鐨鏌ョ湅鏂瑰紡锛岀偣鍑诲掍笁瑙掍笅鎷夎彍鍗曪紝閫夋嫨閲岄潰鐨勨滃皬鍥炬爣鈥濓紝灏卞彲浠ョ湅鍒板涓嬪浘鏍峰紡鐨勬樉绀烘柟寮忥紝鍦ㄩ噷闈㈡壘鍒扳滅鐞嗗伐鍏封濄
绛旓細1銆侀鍏堜笅杞mysql 鏁版嵁搴擄紝鎴戝畨瑁鐨鏄痬ysql5.1鐗堟湰锛岀洿鎺ュ畨瑁呭氨琛岋紝浣嗘槸濡傛灉浠ュ悗浣犳兂鍦ㄦ暟鎹簱閲屾樉绀轰腑鏂囩殑璇濓紝瑕佹妸瀛楃闆嗚缃负gb2312 2銆侀厤缃暟鎹簮odbc銆 mysql-connector-odbc-3.51.20-win32.exe锛堣繖鏄痬ysql鏁版嵁婧恉obc瀹夎绋嬪簭锛夛紝閰嶇疆odbc杩囩▼鍙互鍙傝 http://jingyan.baidu.com/article/8065...
绛旓細濡傛灉浣犱簡瑙QLite鎴栧叾瀹冩暟鎹┍鍔鐨勬搷浣鏂瑰紡,鍙渶瑕佹敼鍙樿繛鎺ュ湴鍧瀛楃涓插睘鎬у嵆鍙 app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://user:password@localhost/mydatabase'娉ㄦ剰鏇挎崲鐪熷疄鐨勮处鍙/瀵嗙爜/鍦板潃/鏁版嵁搴撳悕.瀹樻柟鏂囨。鍦板潃: http://flask-sqlalchemy.pocoo.org/2.1/ ...
绛旓細3銆佸叧闂暟鎹簱杩炴帴1銆丮ySQL鏁版嵁搴撹鐢∕ySQLdb妯″潡,浣哖ython鐢ㄦ潵閾炬帴MySQL鐨绗笁鏂瑰簱MySQLdb涓嶆敮鎸Python3.x鐗瑰埆璇存槑:鎴戝湪鎴戠殑鐢佃剳涓婂疄楠屾椂,鎴戠殑python鏄2.7.2鐗堟湰,瀹夎瀵瑰簲鐗堟湰鐨凪ySQLdb涔嬪悗鐩存帴鍙互杩愯,骞朵笌鏁版嵁搴撹繛鎺ユ垚鍔,鎵浠ュ鏋滃ぇ瀹朵篃鍍忔垜涓鏍烽『鍒╃殑璇,涓嬮潰鐨勫氨涓嶉渶瑕佺湅浜,鐩存帴璺宠繃,鐪嬬2鐐瑰浣曟墽琛宻ql璇彞...
绛旓細浣犻兘绂讳笉寮瑕佸拰鏁版嵁搴撴墦浜ら亾锛岃 MySQL 鍙堟槸鏈娴佽鐨勪竴绉嶆暟鎹簱锛岃繖绡囨枃绔犱粙缁 Python 鎿嶄綔 MySQL 鐨鍑犵鏂瑰紡锛屼綘鍙互鍦ㄥ疄闄呭紑鍙戣繃绋嬩腑鏍规嵁瀹為檯鎯呭喌鍚堢悊閫夋嫨銆1銆丮ySQL-pythonMySQL-python 鍙堝彨 MySQLdb锛屾槸 Python 杩炴帴 MySQL 鏈娴佽鐨勪竴涓┍鍔紝寰堝妗嗘灦閮戒篃鏄熀浜庢搴撹繘琛屽紑鍙戯紝閬楁喚鐨勬槸瀹冨彧鏀寔 ...
