Json in a data, and I am going to put the inside of the data array money together summation, the length of the array is not sure, how to write SQL, please?

CodePudding user response:

Can try a regular expression

CodePudding user response:

Json - & gt; $. Data. [*]. Money, this should be an array of money received, now mysql8.0 should not directly combined function, suggest or after parsing out in code, in a List, and then to add

CodePudding user response:

In addition, I have the time, have a look at my Posting an article about mysql8.0, see can solve my problem