法一、安装MySQL-python (MySQLdb)
要想使python可以操作mysql 就需要MySQL-python驱动,它是python 操作mysql必不可少的模块。
下载地址:https://pypi.python.org/pypi/MySQL-python/
下载MySQL-python-1.2.5.zip 文件之后直接解压(如何地方)。进入MySQL-python-1.2.5目录:
cmd cd到文件夹
python setup.py install
import pymysql
try:
conn=pymysql.connect(host='localhost',user='root',passwd='root',db='xu',port=3306,charset='utf8')
cur = conn.cursor()
cur.execute('select * from admin')
date=cur.fetchall()
for d in date:
print(d[0]+' '+d[1]+' '+str(d[2]) )
cur.close()
conn.close()
except Exception as err:
print(err)
要想使python可以操作mysql 就需要MySQL-python驱动,它是python 操作mysql必不可少的模块。
下载地址:https://pypi.python.org/pypi/MySQL-python/
下载MySQL-python-1.2.5.zip 文件之后直接解压(如何地方)。进入MySQL-python-1.2.5目录:
cmd cd到文件夹
python setup.py install
import pymysql
try:
conn=pymysql.connect(host='localhost',user='root',passwd='root',db='xu',port=3306,charset='utf8')
cur = conn.cursor()
cur.execute('select * from admin')
date=cur.fetchall()
for d in date:
print(d[0]+' '+d[1]+' '+str(d[2]) )
cur.close()
conn.close()
except Exception as err:
print(err)