Find Jobs
Hire Freelancers

MySQL Trigger: make synchronous table from JSON array

$10-30 USD

Closed
Posted about 3 years ago

$10-30 USD

Paid on delivery
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
Project ID: 29055960

About the project

3 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $37 USD for this job
User Avatar
✅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 with 5+ years of experience with expertise in all kind of CMS and PHP frameworks, WordPress customization, Dynamic website Design, eCommerce setup, UI design, Graphic design, Theme Customization etc. As a professional developer, I assure you that I will perfectly meet your requirements using my skills and expertise and I serve you with the best services as your expectations. My price and timeline negotiable. So, feel free to ask me. I’m glad to answer any questions!
$50 USD in 1 day
5.0 (39 reviews)
5.3
5.3
User Avatar
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 mentioned. I am available to start now on project. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$30 USD in 2 days
5.0 (29 reviews)
4.8
4.8
User Avatar
Hi there, I have seen your code explaination, Can you message me lets discuss more on the project.
$30 USD in 1 day
5.0 (1 review)
0.8
0.8

About the client

Flag of RUSSIAN FEDERATION
Moscow, Russian Federation
5.0
3
Payment method verified
Member since Apr 15, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.