Flaten JSON key/value blob via MySql query

I am looking for someone who can flatten a JSON blob via MySql queries using the ->> operator and/or JSON_TABLE function, COLUMNS function. Other functions and MySql functionality can be used, these are just examples.

Solution should only be a MySql query. (No java, .net, etc)

Source will be stored in a table and out put should be put into another table. Table and sample data attached.

Specific work is a query to:

1) Read from source table (src)

2) Flatten all JSON keys/value pairs

3) Write each key/value as a row in the destination table (dest) with the related itemID from the source table

json key = question

json value = answer

Навыки: MySQL, SQL

Показать больше: mysql query json, php mysql query json, return json mysql query php, php json foreach key value, php json get value by key, add new key value pair to json object, how to get key value from json array in java, get key value pair from json object java, parse json key value java, create json from mysql query, how to get key value from json object in c#, query key value attention, mysql query xml blob, mysql query to json, python json get value by key, python json update value by key, expected key value host variable assignment got json, php json foreach key => $value, powershell json = get value by key, sql query key value pairs

О работодателе:
( 24 отзыв(-а, -ов) ) Brooklyn, United States

ID проекта: #30925111


(1 отзыв)

14 фрилансеров(-а) готовы выполнить эту работу в среднем за $138


Hello , I have just ready your project details, i can make your project . I have done many jobs before same , i have 6 years of work experience in web design and development . I am full stack developer . I am well expe Больше

$70 USD за 1 день
(49 отзывов(-а))
(32 отзывов(-а))

I understand what you looking to Flaten JSON key/value blob via MySql query I can help you in this request now. Please send me messages whenever you available online.

$300 USD за 7 дней(-я)
(4 отзывов(-а))

I have a experience in asp.net, MVC, web API,Laravel,Php,,Java, Spring mvc,Hibernate, c#, SQL, entity framework,linq, razor view (Cshtl), html, Wordpress,Joomla,Shopify,Jstl,bootstrap,Angular JS, Jquery, Json,XML, repo Больше

$56 USD за 2 дней(-я)
(9 отзывов(-а))

★★★★★ DATABASE EXPERT ★★★★★ Hello, there? I have read your description. I am appropriate to your description. I am full-stack, full-time senior developer and have rich experience with the similar projects over 6 years. Больше

$110 USD за 1 день
(1 отзыв)

Hi, I am an experienced Data Engineer with a solid background in SQL. I have already done Data processing with SQL. Let's have a call for more details about the project. Regards

$250 USD за 1 день
(1 отзыв)

Hello. As an experienced senior full stack developer, I am familiar with not only PHP, Javascript frameworks such as Laravel+Vue.js, MEAN, MERN, MEVN but also blockchain. The details below will assure you that hiring m Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))

Hello... I will prepare WEBSITE DESIGN in the best quality within the desired time frame and according to your requirements it is for (need integration shiprocket shipping into this ) ✓UI & UX ✓ Website Design & Develo Больше

$40 USD за 2 дней(-я)
(0 отзывов(-а))

Hi there. Hope you are doing well. I saw your description and I am pretty sure that I can help you with that. Let's discuss in detail via chat. Thanks.

$100 USD за 1 день
(0 отзывов(-а))

Hello. I have read your description very carefully and I can complete it perfectly in short time. I am a new freelancer, But I am confident in my skills and always value for client's trust. So I have rich experience Больше

$100 USD за 7 дней(-я)
(0 отзывов(-а))

Based on our understanding, we will read the json object via mssql sp/function and then insert that into the destination table as key value pair rows. the request is [login to view URL] and output is in the [login to view URL] format Больше

$250 USD за 7 дней(-я)
(0 отзывов(-а))

Hi. I have seen your requirements. And I am doing it now already. Please let me know if I can continue to work. Thanks.

$140 USD за 7 дней(-я)
(0 отзывов(-а))

my company free hosting provider services. Hi, I am interested in your work. I want to do your job I want to talk to you in detail. And I am a professional full-php web developer with expertise in php, javascript, Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))