mysql导入csv文件

LOAD DATA INFILE 'path/to/your/file.csv'
INTO TABLE your_table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS; -- 如果CSV文件包含标题行

import mysql.connector
import csv

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 打开CSV文件
with open('path/to/your/file.csv', newline='') as csvfile:
    reader = csv.reader(csvfile, delimiter=',')
    next(reader)  # 跳过标题行
    for row in reader:
        cursor.execute("INSERT INTO your_table_name (column1, column2, column3) VALUES (%s, %s, %s)", row)

# 提交事务
db.commit()

# 关闭连接
cursor.close()
db.close()

GRANT FILE ON *.* TO 'yourusername'@'localhost';

LOAD DATA INFILE 'path/to/your/file.csv' CHARACTER SET utf8mb4
INTO TABLE your_table_name
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
Lzychars terminated by '
IGNORE 1 ROWS;