从SQL查询返回的数据创建多维数组

import pymysql

# 连接数据库
connection = pymysql.connect(host='localhost',
                             user='root',
                             password='password',
                             database='your_database')

# 创建游标
cursor = connection.cursor()

# 执行SQL查询
sql = "SELECT * FROM your_table"
cursor.execute(sql)

# 获取查询结果
results = cursor.fetchall()

# 关闭游标和数据库连接
cursor.close()
connection.close()

# 创建多维数组
multi_dimensional_array = []

for row in results:
    # 根据查询结果的列数创建多维数组的维度
    temp_array = [None] * len(row)

    for i in range(len(row)):
        temp_array[i] = row[i]

    # 将每一行数据添加到多维数组中
    multi_dimensional_array.append(temp_array)

# 打印多维数组
print(multi_dimensional_array)