实例：
import pymysql
import pandas as pd
import numpy as np
from sqlalchemy import create_engine
df = pd.DataFrame([[1,"Bob",0],
[2,"Kim",1]],columns=["id","name","sex"])
df
id name sex
0 1 Bob 0
1 2 Kim 1
from sqlalchemy import create_engine
engine = create_engine("mysql://{}:{}@{}/{}".format('root', 'root', '127.0.0.1:3306', 'spider_zn'))
con = engine.connect()
df.to_sql(name='students', con=con, if_exists='replace', index=False)
import pymysql
import pandas as pd
imp
