python连接mysql

1.原生连接pymsql

import pymysql     # 安装这个包

conn = pymysql.Connect(       # 建立连接

    host = '127.0.0.1',     # localhost

    user = 'root',

    password = '123456',

    database = 'data',

    port = 3306)    #不要加引号

cur = conn.cursor()       # 建立游标

cur.execute("SELECT * FROM data.company ")

data = cur.fetchall()   # 获得sql结果并赋值

print(data[0])

cur.close()

conn.close()

2.pd连接

sql = 'select * from company'

df = pd.read_sql(sql,con)

result.to_csv('路径',index = 0)

参考：https://www.jianshu.com/p/02cc142d950e

七周数据分析