Suljettu

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

Taidot: MySQL

Näytä lisää: mysql ajax php filter table, mysql trigger send mail, json array manipulation, mysql php drowdown menu table set value table, mysql trigger email sending record inserted table, mysql create table json, mysql table json file, php convert mysql table json, mysql json array to rows, how to convert json array to html table, mysql trigger after insert update another table, mysql trigger update same table after update, mysql trigger insert into another table, display json array in html table using php, mysql search json array

Tietoa työnantajasta:
( 3 arvostelua ) Moscow, Russian Federation

Projektin tunnus: #29055960

4 freelanceria on tarjonnut keskimäärin $53 tähän työhön

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 Lisää

$50 USD 1 päivässä
(37 arvostelua)
5.2
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 Lisää

$30 USD 2 päivässä
(29 arvostelua)
4.8
Alexeydev1

MySQL expert is here, I am very interested in this project. I can handle any mysql project. Please give me this job and work together. Thank you sir.

$100 USD 7 päivässä
(4 arvostelua)
3.1
blackrockwise

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

$30 USD 1 päivässä
(1 arvostelu)
0.8