如何读取每一行并插入到数据库中，同时删除不需要空格和多个逗号

with open('data.txt', 'r') as file:
    lines = file.readlines()

cleaned_lines = []
for line in lines:
    cleaned_line = line.strip().replace(',', '')
    cleaned_lines.append(cleaned_line)

import mysql.connector

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

# 创建游标对象
cursor = cnx.cursor()

# 插入数据
for line in cleaned_lines:
    query = "INSERT INTO table_name (column_name) VALUES (%s)"
    values = (line,)
    cursor.execute(query, values)

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()