python读写MySQL

读取mysql中的数据到pandas

import pandas as pd
import pymysql

dbconn = pymysql.connect(
    host = 'localhost',   
    database = 'myemployees',   #需要读取的库
    user = 'root',    #用户
    port = 3306,    #端口号
    password = '*****')   #密码

sql = 'select * from employees'  #sql语句
df = pd.read_sql(sql,dbconn)
 

将pandas中的数据导入mysql

import pandas as pd
import pymysql
from sqlalchemy import create_engine

engine = create_engine('mysql+pymysql://root:password@localhost:3306/库名')
df.to_sql('表名', engine, index= False)  #index = False代表不存储索引列