Micro project Parsing a JSON String in mysql and creating totals for the different variables inside

キャンセルされた 投稿 6年前 着払い
キャンセルされた 着払い

There are columns are other columns involved but here is the one that i need parsed

[{"id":3099,"type":"dp","character":"74523"},{"id":3099,"type":"dp","character":"74523"},{"id":3099,"type":"dp","character":"74523"},{"id":3099,"type":"dp","character":"74523"}]

Sample of the strings involved this would need to be grouped like this

ID COUNT

3099 x

I would also need one a 2 more queries of this nature grouping by different columns

JavaScript MySQL PHP ソフトウェアアーキテクチャ XML

プロジェクトID: #16162464

プロジェクトについて

12個の提案 リモートプロジェクト アクティブ 6年前

12人のフリーランサーが、平均$21 で、この仕事に入札しています。

rajeshsonisl

Hi there, Quick and easy. Just send FTP access. I have a 99% project completion rate and a 4.99 reputation (out of 5.0 from over a thousand projects. Thanks. Regards, Rajesh Soni.

$25 CAD 1日以内
(963件のレビュー)
8.6
ubica

Hello. So it just needs to yield (3099, 4) no matter what `type` and `character` are, and insert it to some mysql table? Thank you.

$30 CAD 1日以内
(24件のレビュー)
5.5
d3logicsindia

Hello i am senior php developer with 5+ years experience. I have experience with the php js json ajax and jquery etc..

$20 CAD 1日以内
(10件のレビュー)
3.2
gayatriprods

We understand your requirements and would like to complete this task for you. Kindly get in touch to take this further.

$17 CAD 1日以内
(6件のレビュー)
3.4
ouarkaayoub

Hello Client, This is an interesting project, I would like to discuss with you more details, please come on chat for more info, I can do the best. skills: Javascript, MySQL, PHP, Json Contact me Thanks

$25 CAD 3日以内
(14件のレビュー)
3.6
arvindvashi

Hello Sir, After going through the job description regarding "Parsing a JSON String in MySQL", I am glad to let you know that I am able to parse and calculate JSON variable values as per your instruction because I h もっと

$30 CAD 1日以内
(2件のレビュー)
0.4
Arijit13C

I have 4+ years of experience with Sql queries and JSON and have worked with Amazon as a database expert. Please review my profile and message me on chat so that we can discuss the finer details of the project.

$10 CAD 1日以内
(レビュー1件)
0.0
vslpwr90

Previously worked on similar requirement.

$15 CAD 1日以内
(0件のレビュー)
0.0
sureshksb2

A proposal has not yet been provided

$25 CAD 2日以内
(0件のレビュー)
0.0
jchandren

Deciphering the json format data to get an aggregate level of data is the initial understanding of the project scope.

$17 CAD 5日以内
(0件のレビュー)
0.0