from sqlalchemy import create_engine
#创建一个mysql连接器,用户名为root,密码为123456
#地址为127.0.0.1,数据库为sys,编码为utf8
engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/sys?charset=utf8')
print(engine)
#写入数据
import numpy as np
import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/sys?charset=utf8')
print(engine)
df_write = pd.DataFrame({'id':[10,27,34],'name':['张三','李四','王五'],'score':[80,75,56]})
df_write.to_sql('sys',engine,index=False)