使用二维数组中的项向表中添加记录

import mysql.connector

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

# 创建表
create_table_query = '''
CREATE TABLE IF NOT EXISTS table_name (
    column1 INT,
    column2 VARCHAR(255),
    column3 FLOAT
)
'''
cursor.execute(create_table_query)

# 二维数组
data = [
    [1, 'item1', 1.23],
    [2, 'item2', 4.56],
    [3, 'item3', 7.89]
]

# 插入记录
insert_query = 'INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)'
for item in data:
    cursor.execute(insert_query, item)

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