You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
A native json data type is implemented in MySQL since version 5.7.8 which provides advantages over storing json in a text column:
Automatic validation of JSON documents stored in JSON columns. Invalid documents produce an error.
Optimized storage format. JSON documents stored in JSON columns are converted to an internal format that permits quick read access to document elements. When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the document.
Are you considering adding support for this data type? Currently the json interface only allows text based data types.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
A native json data type is implemented in MySQL since version 5.7.8 which provides advantages over storing json in a text column:
Are you considering adding support for this data type? Currently the json interface only allows text based data types.
More information about the JSON Data Type in the MySQL Docs: https://dev.mysql.com/doc/refman/5.7/en/json.html
Beta Was this translation helpful? Give feedback.
All reactions