在本地计算机中创建Csv文件

pip install pandas

Python脚本[import_csv_to_mysql.py] -

import pandas as pd
import sqlalchemy

# Replace with your database connection details
database_url = "mysql://user_name:password@host_name:PORT/database_name"

# Read the CSV file
csv_path = "path/to/your/csv/file.csv"

db = pd.read_csv(csv_path)

# Create a database engine
engine = sqlalchemy.create_engine(database_url)

# Insert the data into the database
db.to_sql("table-name", engine, if_exists="replace", index=False)
engine.dispose()

运行python脚本-

python import_csv_to_mysql.py