mysql导入txt

LOAD DATA INFILE '/path/to/your/file.txt'
INTO TABLE your_table
FIELDS TERMINATED BY ',' -- 根据实际情况修改分隔符
ENCLOSED BY '"' -- 如果字段包含分隔符，需要指定包围字符
LINES TERMINATED BY '\n' -- 每行记录的结束符
IGNORE 1 LINES; -- 如果文件包含标题行，忽略第一行

import mysql.connector

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

cursor = db.cursor()

# 打开TXT文件
with open('/path/to/your/file.txt', 'r') as file:
    for line in file:
        # 假设每行数据用逗号分隔
        values = line.strip().split(',')
        # 插入数据到MySQL表
        sql = "INSERT INTO your_table (column1, column2, column3) VALUES (%s, %s, %s)"
        cursor.execute(sql, values)

# 提交更改
db.commit()
cursor.close()
db.close()