In MySQL, the JSON_SCHEMA_VALID() function validates a JSON document against a JSON schema. It returns true (1) if the document is valid, and false (0) if it is not.
Tag: functions
How JSON_OVERLAPS() Works in MySQL
In MySQL, JSON_OVERLAPS() is a function that tests whether or not two JSON documents have any key-value pairs or array elements in common.
The function returns true (1) if the documents have any key-value pairs or array elements in common, and false (0) if they don’t.
The JSON_OVERLAPS() function was added in MySQL 8.0.17.
About the JSON_MERGE() Function in MySQL
In MySQL, JSON_MERGE() is a deprecated function that merges two or more JSON documents and returns the result.
It was deprecated in MySQL 8.0.3 and is subject to removal in a future release.
Fortunately, the JSON_MERGE_PRESERVE() function was added in MySQL 8.0.3 as a synonym for JSON_MERGE(), and it therefore does the same thing that JSON_MERGE() does/did.
Therefore, instead of using JSON_MERGE(), use JSON_MERGE_PRESERVE() instead.
Alternatively, you can use JSON_MERGE_PATCH(), which performs an RFC 7396 compliant merge of two or more JSON documents, without preserving members having duplicate keys.
How JSON_TABLE() Works in MySQL
In MySQL, JSON_TABLE() is a built-in function that converts JSON data into a relational form.
In other words, it lets you return a JSON document as a table.
The JSON_TABLE() function was introduced in MySQL 8.0.
How CAST() Works in MySQL
In MySQL, CAST() is a built in function that converts a value to another data type. It takes a value of one type and returns a value of the specified type.
You provide the value as an argument when you call the function, as well as the type that you’d like it converted to.
CAST() works similar to CONVERT(), except that the syntax used is slightly different.
How LAST_INSERT_ID() Works in MySQL
In MySQL, the LAST_INSERT_ID() function returns the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most recently executed INSERT statement.
It can also be called with an argument, in which case, it returns the value of the expression and the next call to LAST_INSERT_ID() will return the same value.
How GENERATE_SERIES() Works in PostgreSQL
In PostgreSQL, we can use the generate_series() function to return a series of values between a given start and stop point. This can be a series of numbers or a series of timestamps.
The function returns a set containing the series.
Continue readingMySQL ICU_VERSION() Explained
In MySQL, the ICU_VERSION() function returns the version of the International Components for Unicode (ICU) library used to support regular expression operations.
The ICU_VERSION() function is primarily intended for use in test cases.
How CURRENT_ROLE() Works in MySQL
In MySQL, CURRENT_ROLE() is a built-in function that returns the current active roles for the current session, separated by commas, or NONE if there are none. The current role determines our access privileges.
MySQL COERCIBILITY() Explained
In MySQL, the COERCIBILITY() returns the collation coercibility value of its string argument.
The COERCIBILITY() function defines how collations will be converted in the case of collation conflict. In such conflicts, an expression with a higher coercibility is converted to the collation of an expression with a lower coercibility.