How to JSON in MySQL

How to remove a field in a JSON document in MySQL

You can remove a field from JSON document in MySQL with the JSON_REMOVE function.

How to JSON in PostgreSQL®

How to tabulate a JSON to a record in PostgreSQL®

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to tabulate a JSON to a record:

How to JSON in PostgreSQL®

How to tabulate a JSON to a recordset in PostgreSQL®

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to tabulate a JSON to a recordset:

How to JSON in PostgreSQL®

How to remove an item from a JSON array in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the - operator to remove an item from an array.

How to JSON in PostgreSQL®

How to remove fields from a JSON document in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to remove fields from a JSON document:

How to JSON in PostgreSQL®

How to remove nulls JSON object in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the json_strip_nulls (jsonb_strip_nulls for JSONB) function to remove the null values.