数组如何存到mysql里

CREATE TABLE array_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    value INT
);

INSERT INTO array_data (value) VALUES (1), (2), (3), (4), (5);

CREATE TABLE array_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data JSON
);

INSERT INTO array_data (data) VALUES ('[1, 2, 3, 4, 5]');

import json

array = [1, '2', 3.0, 4, 5]
array = [int(item) if isinstance(item, (int, float)) else int(float(item)) for item in array]
json_data = json.dumps(array)

# 存储到MySQL

array = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
chunk_size = 5
chunks = [array[i:i + chunk_size] for i in range(0, len(array), chunk_size)]

for chunk in chunks:
    json_data = json.dumps(chunk)
    # 存储到MySQL