MySQL Trigger: make synchronous table from JSON array
$10-30 USD
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
ID Projek: #29055960
Tentang projek
3 pekerja bebas membida secara purata $37 untuk pekerjaan ini
✅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
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
Hi there, I have seen your code explaination, Can you message me lets discuss more on the project.