import pandas as pd
from sqlalchemy import create_engine

# 创建数据库引擎
engine = create_engine('mysql+pymysql://root:lihaozhe@192.168.10.10:3306/db_book')

# 读取CSV文件
df = pd.read_csv('data.csv',header=1)

# 将DataFrame写入MySQL
df.to_sql('tb_book', con=engine, if_exists='replace', index=False)