mysql存储map数据结构

-- 创建表
CREATE TABLE map_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data JSON
);

-- 插入数据
INSERT INTO map_data (data) VALUES ('{"key1": "value1", "key2": "value2"}');

-- 查询数据
SELECT data->'$.key1' AS key1, data->'$.key2' AS key2 FROM map_data WHERE id = 1;

-- 创建表
CREATE TABLE map_keys (
    id INT AUTO_INCREMENT PRIMARY KEY,
    key VARCHAR(255) UNIQUE
);

CREATE TABLE map_values (
    id INT AUTO_INCREMENT PRIMARY KEY,
    map_id INT,
    value TEXT,
    FOREIGN KEY (map_id) REFERENCES map_keys(id)
);

-- 插入数据
INSERT INTO map_keys (key) VALUES ('key1'), ('key2');
INSERT INTO map_values (map_id, value) VALUES (1, 'value1'), (2, 'value2');

-- 查询数据
SELECT k.key, v.value FROM map_keys k JOIN map_values v ON k.id = v.map_id;

-- 创建表
CREATE TABLE map_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    data TEXT
);

-- 插入数据
INSERT INTO map_data (data) VALUES ('key1=value1&key2=value2');

-- 查询数据
SELECT data FROM map_data WHERE id = 1;