python3 连接mysql

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'])