如何将CSV文件中的不同行放入表中？

import csv
import pymysql

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

    # 连接MySQL数据库
    conn = pymysql.connect(host='localhost', user='root', password='password', db='mydatabase')
    cursor = conn.cursor()

    # 创建表结构
    create_table_query = '''
    CREATE TABLE IF NOT EXISTS mytable (
        id INT AUTO_INCREMENT PRIMARY KEY,
        column1 VARCHAR(255),
        column2 VARCHAR(255),
        ...
    )
    '''
    cursor.execute(create_table_query)

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

    # 提交事务并关闭连接
    conn.commit()
    cursor.close()
    conn.close()