导入相关包
import pandas as pd
from sqlalchemy import create_engine
建立连接
engine = create_engine('mysql+pymysql://root:123456@localhost:3306/mysqlnancy?charset=utf8')
dfla.to_sql(name='KNN', con=engine, if_exists='append', index=None)
导入相关包
import pandas as pd
from sqlalchemy import create_engine
建立连接
engine = create_engine('mysql+pymysql://root:123456@localhost:3306/mysqlnancy?charset=utf8')
dfla.to_sql(name='KNN', con=engine, if_exists='append', index=None)