1DROP TABLE IF EXISTS logs; 2CREATE TABLE logs ( 3id INT PRIMARY KEY, 4record JSON, 5message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`, '$.message')) VIRTUAL 6) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COMMENT = 'ENGINE "InnoDB"'; 7INSERT INTO logs(id, record) VALUES (1, '{"level": "info", "message": "start"}'); 8INSERT INTO logs(id, record) VALUES (2, '{"level": "info", "message": "restart"}'); 9INSERT INTO logs(id, record) VALUES (3, '{"level": "warn", "message": "abort"}'); 10UPDATE logs SET record = '{"level": "info", "message": "shutdown"}' WHERE id = 2; 11SELECT * FROM logs; 12id record message 131 {"level": "info", "message": "start"} "start" 142 {"level": "info", "message": "shutdown"} "shutdown" 153 {"level": "warn", "message": "abort"} "abort" 16DROP TABLE logs; 17