python 连接mysql数据库

有2种方式连接数据库

1.

def duqushuju(sql):
    connect = pymysql.Connect(host = 'ip名称', port = 3306,user = "账号",passwd ="密码",database = "数据库")
    cursor = connect.cursor() 
    #print(sql)
    cursor.execute(sql)  
    data = cursor.fetchall() 
    header = [t[0] for t in cursor.description] 
    df = pd.DataFrame(list(data), columns=header) 
    cursor.close() 
    connect.close() 
    return df
sql = """
"""
df_huilv = duqushuju(sql)

2.

import pymysql
conn = pymysql.connect(host = 'ip', port = 3306,user = "账号",passwd ="密码",database = "数据库")
df_account = pd.read_sql("select id,account_num,site,group_id from yibai_amazon_account;", conn)
conn.close()

将dataframe存入数据库

from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://root:密码@localhost:3306/yxh?charset=utf8mb4")
result.to_sql(name="数据库名称",con=engine,if_exists='append',index=False,index_label=False)