By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
@input |
---|
sales: [ { id: 2, quantity: 5, price: 123, sum: 615 }, { id: 1, quantity: 9, price: 97, sum: 873 } ] |
JSON_VALID(@input) |
---|
0 |
@input |
---|
[{"id":2,"quantity":5,"price":123,"sum":615},{"id":1,"quantity":9,"price":97,"sum":873}] |
JSON_VALID(@input) |
---|
1 |
id | quantity | price | sum |
---|---|---|---|
2 | 5 | 123.00 | 615.00 |
1 | 9 | 97.00 | 873.00 |
id | code | quantity | price | sum | idCheck | data |
---|---|---|---|---|---|---|
2 | 0 | 5 | 123.00 | 615.00 | 0 | 2020-11-09 13:33:26 |
1 | 0 | 9 | 97.00 | 873.00 | 0 | 2020-11-09 13:33:26 |