MySQL Trigger: make synchronous table from JSON array

Ditutup Disiarkan 3 tahun lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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

MySQL

ID Projek: #29055960

Tentang projek

3 cadangan Projek jarak jauh Aktif 3 tahun lepas

3 pekerja bebas membida secara purata $37 untuk pekerjaan ini

DeveloperAlok

✅Hi, there!! I have read your project description, and I fell I do this job very well. My skill matching with your project requirements. so I’m very interested to do this job. I am a professional Full stack developer Lagi

$50 USD dalam sehari
(39 Ulasan)
5.3
mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several MYSQL database projects of various kinds, based on that I can help you in getting your trigger work done as per requirement mentio Lagi

$30 USD dalam 2 hari
(29 Ulasan)
4.8
blackrockwise

Hi there, I have seen your code explaination, Can you message me lets discuss more on the project.

$30 USD dalam sehari
(1 Ulasan)
0.8