python连接mysql数据库

一、安装pymysql

安装方式： pip install pymysql

二、python连接mysql

环境：linux, python3.6

# os.environ['NLS_LANG'] = 'AMERICAN_AMERICA.AL32UTF8'
import pymysql
conn = pymysql.connect(host=host,user=user,password=password,charset='utf8')
cursor = conn .cursor()  # 设置游标
cursor.execute("select * from xxx")
data_list = list(cursor.fetchall())
df = pd.DataFrame(data_list )

 

python连接oracle: https://blog.csdn.net/kerry_55/article/details/93390592

python连接hive: https://blog.csdn.net/kerry_55/article/details/105789298