在将csv读入sql数据库时，我需要将名称列拆分为名字、中间名(如果可用)和姓氏列

import csv
import MySQLdb

# 连接到MySQL数据库
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database_name")
cursor = db.cursor()

# 创建表格
create_table_query = "CREATE TABLE IF NOT EXISTS person (id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(255), middle_name VARCHAR(255), last_name VARCHAR(255))"
cursor.execute(create_table_query)

# 读取CSV文件并将其转换为数据表
with open('data.csv', 'r') as csvfile:
    csvreader = csv.reader(csvfile)
    next(csvreader)  # 跳过标题行
    for row in csvreader:
        name = row[0].split(' ')  # 根据空格拆分名称列
        first_name = name[0]
        middle_name = name[1] if len(name) > 2 else None
        last_name = name[-1]
        
        # 插入拆分后的数据到数据库表中
        insert_query = "INSERT INTO person (first_name, middle_name, last_name) VALUES (%s, %s, %s)"
        cursor.execute(insert_query, (first_name, middle_name, last_name))

# 提交更改并关闭数据库连接
db.commit()
db.close()