命令行 csv导入mysql

id,name,age
1,Alice,30
2,Bob,25
3,Charlie,35

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

mysql -u username -p database_name -e "LOAD DATA INFILE '/path/to/data.csv' INTO TABLE users FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;"

import mysql.connector
import csv

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

cursor = db.cursor()

# 打开CSV文件
with open('/path/to/data.csv', newline='') as csvfile:
    reader = csv.reader(csvfile)
    next(reader)  # 跳过标题行
    for row in reader:
        cursor.execute("INSERT INTO users (id, name, age) VALUES (%s, %s, %s)", row)

# 提交事务
db.commit()

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

GRANT FILE ON *.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

import codecs

with codecs.open('/path/to/data.csv', 'r', 'utf-8') as csvfile:
    # 处理CSV文件