mysql的json

INSERT INTO my_table (json_column) VALUES ('{"name": "John", "age": 30}');

SELECT json_column->'$.name' AS name FROM my_table;

UPDATE my_table SET json_column = JSON_SET(json_column, '$.age', 31) WHERE id = 1;

UPDATE my_table SET json_column = JSON_REMOVE(json_column, '$.age') WHERE id = 1;

ALTER TABLE my_table ADD COLUMN name VARCHAR(255) AS (json_column->'$.name');
CREATE INDEX idx_name ON my_table(name);

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

-- 插入数据
INSERT INTO users (info) VALUES ('{"name": "Alice", "age": 25}');
INSERT INTO users (info) VALUES ('{"name": "Bob", "age": 30}');

-- 查询数据
SELECT id, info->'$.name' AS name, info->'$.age' AS age FROM users;

-- 更新数据
UPDATE users SET info = JSON_SET(info, '$.age', 26) WHERE id = 1;

-- 删除数据
DELETE FROM users WHERE id = 2;