如何将CSV文件行放入我构建的表中？

import csv
import mysql.connector

# 读取CSV文件
with open('data.csv', 'r') as file:
    csv_data = csv.reader(file)
    next(csv_data)  # 跳过CSV文件的标题行

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

    # 创建表（如果表不存在）
    create_table_query = '''
        CREATE TABLE IF NOT EXISTS my_table (
            column1 INT,
            column2 VARCHAR(255),
            column3 FLOAT
        )
    '''
    cursor.execute(create_table_query)

    # 插入数据
    insert_query = '''
        INSERT INTO my_table (column1, column2, column3)
        VALUES (%s, %s, %s)
    '''
    for row in csv_data:
        cursor.execute(insert_query, row)

    # 提交事务
    conn.commit()

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