By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
| mydata |
|---|
| {"john": 1, "alex" : 4, "harry" :2} |
SELECT 1
UPDATE 1
| mydata |
|---|
| {"alex": 4, "john": 2, "harry": 2} |
SELECT 1
CREATE TABLE
INSERT 0 1
| mydata |
|---|
| {"john": 1, "alex" : 4, "harry" :2} |
SELECT 1
UPDATE 1
| mydata |
|---|
| {"alex": 4, "john": 2, "harry": 2} |
SELECT 1