> On Dec 19, 2019, at 7:45 PM, No.1 Perfect <757171...@qq.com> wrote:
>
> How can I count the amountand numof goods when the customer or
> goodsname is different.
Querying the contents of arrays is kind of complicated. SQL doesn't understand
arrays, so the query has to use a "table-valued
On 20.12.19 04:45, No.1 Perfect wrote:
I've read the full page instructions of JSON1, But I don't know how to use
JSON1 to query multiple layers JSON data.
The Data as follows :
{
id: 1,
data: {
customer: 1,
goods: [
{ id: 1, name: "apple", price: 12, num: 10,
amount: 120 },
My English is poor, please forgive me.
The first time I use SQLite database.
I've read the full page instructions of JSON1, But I don't know how to use
JSON1 to query multiple layers JSON data.
The Data as follows :
{
id: 1,
data: {
customer: 1,
goods: [
{ id: 1, name: "apple",
3 matches
Mail list logo