How to get the JSON field types in MySQL

To get the type of a JSON item in MySQL you need to use the JSON_TYPE function.

How to JSON in PostgreSQL®

How to get the JSON field types in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_typeof (jsonb_typeof for JSONB) to extract the fields type.