1 安装mysql包
1 查看是否有安装pymysql:
2 安装pymysql
pip install pymysql
3 查看安装结果 pip show pymysql
2 从MYSQL中查询数据
1 查询一条数据
import pymysql
# 连接MySQL数据库
connection = pymysql.connect(host='10.0.57.67', port=3306, user='root', password='root', db='epay',charset='utf8', cursorclass=pymysql.cursors.DictCursor)
# 执行数据查询
sql = "select * from orders where busi_date='20180202'"
# 通过cursor创建游标
cursor = connection.cursor()
cursor.execute(sql)
#查询数据库单条数据
result = cursor.fetchone()
print(result);
print(result['refund_point'])
2 查询多条数据
#查询数据库多条数据
result = cursor.fetchall()
#查询数据库单条数据
#result = cursor.fetchone()
print(result);
print(result[0]['refund_point'])