MySQL Trigger: make synchronous table from JSON array

I have stored JSON value inside table: { "Access": {"Read": ["value 1", "value 2"]}} I need triggers for this table (iafter insert, after update, after delete) that create and stay syncronously table JSON_TABLE with rows for each array element from [login to view URL] For example: CREATE TABLE `test` ( `id` varchar(64) NOT NULL, `JSON` json DEFAULT NULL) CREATE DEFINER=`root`@`%` TRIGGER `test_AFTER_INSERT` AFTER UPDATE ON `test` FOR EACH ROW BEGIN <YOUR TRIGGER> <SAME TRIGGER FOR UPDATE AND DELETE> CREATE TABLE `JSON_TABLE` ( `id` varchar(64) NOT NULL, `Reade` varchar(64) NOT NULL) INSERT INTO test (id,JSON) VALUES ('1','{ "Access": {"Read": ["value 1", "value 2"]}}') SELECT * FROM JSON_TABLE must return 2 rows: '1' | 'value 1' '1' | 'value 2' any updating of test table data stay synched JSON_TABLE data with this rules (table have extracted pairs of id - array element). For case of perfomance trigger process only single (triggered) row from test table. JSON array may contain 1000+ records