windows7+pyhton2.7+pycharm+ MySQL-Python-1.2.4b4.win32-py2.7.exe
首先下载安装MySQL-python-1.2.4b4.win32-py2.7.exe
下载地址:https://sourceforge.net/projects/mysql-python/?source=typ_redirect,下载完直接安装就可以。
以下是查询mysql数据库的代码:
#!/usr/bin/python # -*- coding: GBK -*- __author__ = 'Administrator' import MySQLdb # 打开数据库连接 db = MySQLdb.connect(host='172.18.99.164',user='sun',passwd='myoa888',db='TD_OA',port=3336,charset='gb2312') # 使用cursor()方法获取操作游标 #cursor = db.cursor() #游标形式 cursor = db.cursor(cursorclass = MySQLdb.cursors.DictCursor) #带有键值对的数组 # SQL 查询语句 sql = "SELECT * FROM user limit 10" try: # 执行SQL语句 cursor.execute(sql) # 获取所有记录列表 results = cursor.fetchall() for row in results: #print row #fname = row[0] #游标形式 fname = row['USER_NAME'] # lname = row["USER_NAME"] # age = row["BYNAME"] #sex = row["UID"] # income = row["BYNAME"] print "fname=%s" % (fname) # 打印结果 #print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % \ # (fname, lname, age, sex, income ) except: print "Error: unable to fecth data" # 关闭数据库连接 db.close() print "程序结束,请检查!";
运行结果:
C:\Python27\python.exe E:/PycharmProjects/testmysql.py
fname=系统管理员
fname=XXX
程序结束,请检查!
进程已结束,退出代码0