如何使用Python3.4连接MySQL 如何使用Python3.4连接MySQL
\u5982\u4f55\u4f7f\u7528Python3.4\u8fde\u63a5MySQLMySQLdb\u53ea\u652f\u6301Python2.*\uff0c\u8fd8\u4e0d\u652f\u63013.*
\u53ef\u4ee5\u7528PyMySQL\u4ee3\u66ff\u3002\u5b89\u88c5\u65b9\u6cd5\uff1apip install PyMySQL
\u7136\u540e\u5728\u9700\u8981\u7684\u9879\u76ee\u4e2d\uff0c\u628a __init__.py\u4e2d\u6dfb\u52a0\u4e24\u884c\uff1a
import pymysql
pymysql.install_as_MySQLdb()
\u5c31\u53ef\u4ee5\u7528 import MySQLdb\u4e86\u3002\u5176\u4ed6\u7684\u65b9\u6cd5\u4e0eMySQLdb\u4e00\u6837\u3002
\u5e8f\u53f7 \u63cf\u8ff0
1 \u53bbgithub\u4e0a\u4e0b\u8f7dpymysql\u7684\u5b89\u88c5\u5305pymysql
2 \u89e3\u538b\u5230\u67d0\u4e2a\u76d8\u7b26\u4e0b
3 \u6253\u5f00cmd\u7a97\u53e3\uff08win\u73af\u5883\u4e0b\uff09\uff0c\u8fdb\u5165pymysql\u7684\u6839\u76ee\u5f55\u4e0b\u6267\u884c\u547d\u4ee4\uff0cpython setup.py install
4 \u5728\u7a0b\u5e8f\u91cc\uff0c\u5bfc\u5165pymysql
5 \u5f00\u59cb\u8fde\u63a5\u6570\u636e\u5e93
\u6570\u636e\u5e93\u64cd\u4f5c\u7684API\u6587\u6863\u8fde\u63a5:http://legacy.python.org/dev/peps/pep-0249/ \u4ee3\u7801\u5982\u4e0b\uff1a
Python\u4ee3\u7801
__author__ = 'qindongliang'
#\u5bfc\u5165pymysql\u7684\u5305
import pymysql
try:
#\u83b7\u53d6\u4e00\u4e2a\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u6ce8\u610f\u5982\u679c\u662fUTF-8\u7c7b\u578b\u7684\uff0c\u9700\u8981\u5236\u5b9a\u6570\u636e\u5e93
conn=pymysql.connect(host='localhost',user='root',passwd='qin',db='person',port=3306,charset='utf8')
cur=conn.cursor()#\u83b7\u53d6\u4e00\u4e2a\u6e38\u6807
cur.execute('select * from person')
data=cur.fetchall()
for d in data :
#\u6ce8\u610fint\u7c7b\u578b\u9700\u8981\u4f7f\u7528str\u51fd\u6570\u8f6c\u4e49
print("ID: "+str(d[0])+' \u540d\u5b57\uff1a '+d[1]+" \u6027\u522b\uff1a "+d[2])
cur.close()#\u5173\u95ed\u6e38\u6807
conn.close()#\u91ca\u653e\u6570\u636e\u5e93\u8d44\u6e90
except Exception :print("\u53d1\u751f\u5f02\u5e38")
\u7ed3\u679c\u5982\u4e0b\uff1a Java\u4ee3\u7801
D:\python\python.exe D:/pythonide/pythonprojectworkspace/python/mysql.py
ID: 1 \u540d\u5b57\uff1a \u79e6\u5929 \u6027\u522b\uff1a \u7537
ID: 2 \u540d\u5b57\uff1a \u738b\u6676 \u6027\u522b\uff1a \u5973
Process finished with exit code 0
\u539f\u6587 http://qindongliang1922.iteye.com/blog/2096512
\u8865\u5145\u8bf4\u660e\uff1a
mysqldb\u4f5c\u4e3apython\u8fde\u63a5mysql\u6570\u636e\u5e93\u7684\u5de5\u5177\uff0c\u4f46\u662fmysqldb\u76ee\u524d\u652f\u6491\u7684\u7248\u672c\u8f83\u4f4e\uff0c\u5b89\u88c5\u5931\u8d25\u3002\u6240\u4ee5\u624d\u5c1d\u8bd5pymysql,\u8fd9\u4e2a\u6bd4\u8f83\u7b80\u5355\u6613\u7528
\u8f6f\u4ef6\u4e0b\u8f7d\u5730\u5740\uff1a
python3.2.5:https://www.python.org/ftp/python/3.2.5/python-3.2.5.msi
pymysql3.0.5:https://pypi.python.org/packages/source/P/PyMySQL3/PyMySQL3-0.5.tar.gz
mysql:http://www.phpstudy.net/phpstudy/phpStudyLite.zip(\u4e3a\u4e86\u65b9\u4fbf\u5b89\u88c5\uff0c\u6211\u8fd9\u91cc\u9009\u62e9phpstudy)
1\u3001python\u5b89\u88c5\u76ee\u5f55\u8bbe\u5b9a\u4e3ad:/python32
2\u3001pymysql\u5b89\u88c5\u65b9\u6cd5\u4e3a\uff1a\u89e3\u538b\u4e0b\u8f7d\u7684\u6587\u4ef6\uff0c\u5728cmd\u4e2d\u8fd0\u884c: python setup.py install\u3002
\u68c0\u9a8c\u5b89\u88c5\u5b89\u88c5\u662f\u5426\u6210\u529f\u7684\u65b9\u6cd5\uff1aimport pymysql \u3002 \u5982\u679c\u4e0d\u62a5\u9519 \u8bf4\u660e\u5b89\u88c5\u6210\u529f\u3002
3\u3001mysql\u5b89\u88c5\u76ee\u5f55\u4e3aD:/phpStudy/MySQL\u3002\u4e3a\u907f\u514d\u66f4\u591a\u914d\u7f6e\u95ee\u9898\uff0c\u53ef\u5728\u542f\u52a8phpstudy\u540e\uff0c\u5c06\u5176\u8bbe\u4e3a\u7cfb\u7edf\u670d\u52a1
4\u3001\u57fa\u672c\u64cd\u4f5c\uff1a
\uff081\uff09\u5bfc\u5165pymysql: import pymysql
\uff082\uff09\u8fde\u63a5\u6570\u636e\u5e93\uff1a conn=pymysql.connect(host='localhost',user='root',passwd='root',db='ere'\uff0ccharset='utf8') \u52a1\u5fc5\u6ce8\u610f\u5404\u7b49\u53f7\u524d\u9762\u7684\u5185\u5bb9\uff01charset\u53c2\u6570\u53ef\u907f\u514d\u4e2d\u6587\u4e71\u7801
\uff083\uff09\u83b7\u53d6\u64cd\u4f5c\u6e38\u6807\uff1acur=conn.cursor()
\uff084\uff09\u6267\u884csql\u8bed\u53e5,\u63d2\u5165\u8bb0\u5f55\uff1asta=cur.execute("insert \u8bed\u53e5") \u6267\u884c\u6210\u529f\u540esta\u503c\u4e3a1\u3002\u66f4\u65b0\u3001\u5220\u9664\u8bed\u53e5\u4e0e\u6b64\u7c7b\u4f3c\u3002
\uff085\uff09\u6267\u884csql\u8bed\u53e5\uff0c\u67e5\u8be2\u8bb0\u5f55\uff1acur.execute("select\u8bed\u53e5") \u6267\u884c\u6210\u529f\u540ecur\u53d8\u91cf\u4e2d\u4fdd\u5b58\u4e86\u67e5\u8be2\u7ed3\u679c\u8bb0\u5f55\u96c6\uff0c\u7136\u540e\u518d\u7528\u5faa\u73af\u6253\u5370\u7ed3\u679c\uff1a
for each in cur:
print(each[1].decode('utf-8')) # each[1] \u8868\u793a\u5f53\u524d\u6e38\u6807\u6240\u5728\u884c\u7684\u7684\u7b2c2\u5217\u503c\uff0c\u5982\u679c\u662f\u4e2d\u6587\u5219\u9700\u8981\u5904\u7406\u7f16\u7801
序号描述
1去github上下载pymysql的安装包pymysql
2解压到某个盘符下
3打开cmd窗口（win环境下），进入pymysql的根目录下执行命令，python setup.py install4在程序里，导入pymysql
5开始连接数据库
数据库操作的API文档连接:http://legacy.python.org/dev/peps/pep-0249/代码如下：
__author__ = 'qindongliang'
#导入pymysql的包
import pymysql
try:
#获取一个数据库连接，注意如果是UTF-8类型的，需要制定数据库conn=pymysql.connect(host='localhost',user='root',passwd='qin',db='person',port=3306,charset='utf8')cur=conn.cursor()#获取一个游标
cur.execute('select * from person')
data=cur.fetchall()
for d in data :
#注意int类型需要使用str函数转义
print("ID: "+str(d[0])+' 名字： '+d[1]+" 性别： "+d[2])cur.close()#关闭游标
conn.close()#释放数据库资源
except Exception :print("发生异常")
结果如下：
D:\python\python.exe D:/pythonide/pythonprojectworkspace/python/mysql.pyID: 1 名字： 秦天 性别： 男
ID: 2 名字： 王晶 性别： 女
Process finished with exit code 0
原文 http://qindongliang1922.iteye.com/blog/2096512补充说明：
mysqldb作为python连接mysql数据库的工具，但是mysqldb目前支撑的版本较低，安装失败。所以才尝试pymysql,这个比较简单易用软件下载地址：
python3.2.5:https://www.python.org/ftp/python/3.2.5/python-3.2.5.msipymysql3.0.5:https://pypi.python.org/packages/source/P/PyMySQL3/PyMySQL3-0.5.tar.gzmysql:http://www.phpstudy.net/phpstudy/phpStudyLite.zip(为了方便安装，我这里选择phpstudy)1、python安装目录设定为d:/python32
2、pymysql安装方法为：解压下载的文件，在cmd中运行: python setup.py install。
检验安装安装是否成功的方法：import pymysql 。 如果不报错 说明安装成功。
3、mysql安装目录为D:/phpStudy/MySQL。为避免更多配置问题，可在启动phpstudy后，将其设为系统服务4、基本操作：
（1）导入pymysql: import pymysql
（2）连接数据库： conn=pymysql.connect(host='localhost',user='root',passwd='root',db='ere'，charset='utf8') 务必注意各等号前面的内容！charset参数可避免中文乱码（3）获取操作游标：cur=conn.cursor()
（4）执行sql语句,插入记录：sta=cur.execute("insert 语句") 执行成功后sta值为1。更新、删除语句与此类似。
（5）执行sql语句，查询记录：cur.execute("select语句") 执行成功后cur变量中保存了查询结果记录集，然后再用循环打印结果：
for each in cur:
print(each[1].decode('utf-8')) # each[1] 表示当前游标所在行的的第2列值，如果是中文则需要处理编码
绛旓細1銆python瀹夎鐩綍璁惧畾涓篸:/python34 2銆乸ymysql瀹夎鏂规硶涓猴細瑙ｅ帇涓嬭浇鐨勬枃浠讹紝鍦╟md涓繍琛: python setup.py install銆傛楠屽畨瑁呭畨瑁呮槸鍚︽垚鍔熺殑鏂规硶锛歩mport pymysql 銆 濡傛灉涓嶆姤閿 璇存槑瀹夎鎴愬姛銆3銆乵ysql瀹夎鐩綍涓篋:/phpStudy/MySQL銆備负閬垮厤鏇村閰嶇疆闂锛屽彲鍦ㄥ惎鍔╬hpstudy鍚庯紝灏嗗叾璁句负绯荤粺鏈嶅姟 4...
绛旓細鐢╬ymysql妯″潡 __author__ = 'qindongliang' #瀵煎叆pymysql鐨勫寘 import pymysql try: #鑾峰彇涓涓暟鎹簱杩炴帴锛屾敞鎰忓鏋滄槸UTF-8绫诲瀷鐨勶紝闇瑕佸埗瀹氭暟鎹簱 conn=pymysql.connect(host='localhost',user='root',passwd='qin',db='person',port=3306,charset='utf8') cur=conn.cursor()#...
绛旓細鍙互鐢≒yMySQL浠ｆ浛銆傚畨瑁呮柟娉曪細pip install PyMySQL 鐒跺悗鍦ㄩ渶瑕佺殑椤圭洰涓紝鎶 __init__.py涓坊鍔犱袱琛岋細import pymysql pymysql.install_as_MySQLdb()灏卞彲浠ョ敤 import MySQLdb浜嗐傚叾浠栫殑鏂规硶涓嶮ySQLdb涓鏍枫
绛旓細mysqldb浣滀负python杩炴帴mysql鏁版嵁搴撶殑宸ュ叿锛屼絾鏄痬ysqldb鐩墠鏀拺鐨勭増鏈緝浣庯紝瀹夎澶辫触銆傛墍浠ユ墠灏濊瘯pymysql,杩欎釜姣旇緝绠鍗曟槗鐢杞欢涓嬭浇鍦板潃锛歱ython3.2.5:https://www.python.org/ftp/python/3.2.5/python-3.2.5.msipymysql3.0.5:https://pypi.python.org/packages/source/P/PyMySQL3/PyMySQL3-0.5...
绛旓細1銆侀鍏堜笅杞絤ysql 鏁版嵁搴擄紝鎴戝畨瑁呯殑鏄痬ysql5.1鐗堟湰锛岀洿鎺ュ畨瑁呭氨琛岋紝浣嗘槸濡傛灉浠ュ悗浣犳兂鍦ㄦ暟鎹簱閲屾樉绀轰腑鏂囩殑璇濓紝瑕佹妸瀛楃闆嗚缃负gb2312 2銆侀厤缃暟鎹簮odbc銆 mysql-connector-odbc-3.51.20-win32.exe锛堣繖鏄痬ysql鏁版嵁婧恉obc瀹夎绋嬪簭锛夛紝閰嶇疆odbc杩囩▼鍙互鍙傝 http://jingyan.baidu.com/article/8065...
绛旓細1.涓嬭浇32浣嶇殑python3.4 锛屽畨瑁咃紝娉ㄦ剰鍦ㄥ畨瑁呰繃绋嬩腑锛岄夋嫨pip 2.娣诲姞绯荤粺鐜鍙橀噺 C:\Python34;C:\Python34\Scripts;C:\Program Files\Google\Chrome\Application锛堝悗闈細鐢ㄥ埌锛3.浣跨敤pip鍛戒护锛屽畨瑁卻elenium cd Python34 鐒跺悗杈撳叆: pip install -U selenium 瀹夎鎴愬姛鍚庯紝鏄剧ず:Runing setup.py install ...
绛旓細妯℃嫙SSH鐧婚檰涓鍙版満鍣ㄥ苟鎵撳嵃纾佺洏鎯呭喌锛岀劧鍚庨鍑虹殑渚嬪瓙锛!/usr/local/python3.4/bin/python3.4 import pexpect ip="192.168.46.22"name="root"pwd="abc"鍙戦佸懡浠ゆ墽琛屼氦浜 child=pexpect.spawn('ssh %s@%s' % ("root",ip) )child.expect ('password:')child.sendline(pwd)child.expect('$'...
绛旓細cd Python-3.4.3 ./configure --prefix=/usr/local make make install 4 澶囦唤鏃х増python mv /usr/bin/python /usr/bin/pythonbak 5 鍒涘缓鏂皃ython杞杩炴帴 ln -sf /usr/local/bin/python3.4 /usr/bin/python 6 淇敼yum python 鐗堟湰 !/usr/bin/python2.6 import sys ...鐪佺暐 7 瀹夎 lib...
绛旓細python3.4鎬庝箞杩炴帴mysql pymysql杩炴帴mysql鏁版嵁搴 棣栭〉 闂 鍏ㄩ儴闂 缁忔祹閲戣瀺 浼佷笟绠＄悊 娉曞緥娉曡 绀句細姘戠敓 绉戝鏁欒偛 鍋ュ悍鐢熸椿 浣撹偛杩愬姩 鏂囧寲鑹烘湳 鐢靛瓙鏁扮爜 鐢佃剳缃戠粶 濞变箰浼戦棽 琛屾斂鍦板尯 蹇冪悊鍒嗘瀽 鍖荤枟鍗敓 绮鹃 鐭ラ亾涓撴爮 鐭ラ亾鏃ユ姤 鐭ラ亾澶ф暟鎹 鐭ラ亾闈為仐 鐢ㄦ埛 鐭ラ亾鍚堜紮浜 鑺濋夯鍥 鑺...
绛旓細浣跨敤璇ュ簱鏃讹紝闇瑕佸湪Sql Server Configuration Manager閲岄潰灏員CP/IP鍗忚寮鍚 鐢ㄦ硶锛"""def __init__(self,host,user,pwd,db):self.host = host self.user = user self.pwd = pwd self.db = db def __GetConnect(self):"""寰楀埌杩炴帴淇℃伅 杩斿洖: conn.cursor()"""if not self.db:raise(Name...
