import pandas as pd
from sqlalchemy import create_engine
data = pd.read_csv('C:/Users/mike/Desktop/pdf资料/data/TikTok profiles dataset.csv')
db_connection = 'mysql+pymysql://root:bg6mgd@localhost/aa'
engine = create_engine(db_connection)
table_name = 'my_table'
data.to_sql(table_name, engine, if_exists='replace', index=False)
Out[22]: 1000
python把csv导入到mysql
最新推荐文章于 2024-06-25 14:57:14 发布