如何从txt文件中插入数据到数据库中

import mysql.connector

# 读取txt文件
with open('data.txt', 'r') as file:
    lines = file.readlines()

# 解析数据
data = []
for line in lines:
    # 假设txt文件中每行数据以逗号分隔
    values = line.strip().split(',')
    data.append(values)

# 连接数据库
conn = mysql.connector.connect(
    host='localhost',
    user='username',
    password='password',
    database='database_name'
)

# 创建表格
cursor = conn.cursor()
create_table_sql = '''
    CREATE TABLE IF NOT EXISTS data_table (
        id INT AUTO_INCREMENT PRIMARY KEY,
        column1 VARCHAR(255),
        column2 VARCHAR(255),
        ...
    )
'''
cursor.execute(create_table_sql)

# 插入数据
insert_sql = '''
    INSERT INTO data_table (column1, column2, ...)
    VALUES (%s, %s, ...)
'''
cursor.executemany(insert_sql, data)

# 提交事务
conn.commit()

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