Python3 操作mysql数据库使用pymysql
去github下载pymysql:https://github.com/PyMySQL/PyMySQ
解压到磁盘某个目录下
进入pymysql的根目录下执行命令,python setup.py install
在工程代码中导入pymysql库就可以链接数据库了
import pymysql.cursors
# Connect to the database
connection = pymysql.connect(host='localhost',user='root',password='123456',db='venture',charset='utf8',cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
sql="SELECT * FROM vt_user"
cursor.execute(sql)
result=cursor.fetchone()
print(result)
finally:
connection.close()
参考文献:http://qindongliang.iteye.com/blog/2096512