https://dev.mysql.com/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/json-validation-functions.html
JSON_SCHEMA_VALID() returns true if the document is validates against the schema, and false if it is not; JSON_SCHEMA_VALIDATION_REPORT() provides a report in JSON format on the validation. Provided that these conditions are met: If the document ...
https://dev.mysql.com/explain-output.html
select_type Value JSON Name Meaning SIMPLE None Simple SELECT (not using UNION or subqueries) PRIMARY None Outermost SELECT UNION None Second or later SELECT statement in a UNION DEPENDENT UNION dependent (true) Second or later SELECT statement in a ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/replication-gtids-functions.html
These functions are as follows: GTID_SUBSET(set1,set2) Given two sets of global transaction identifiers set1 and set2, returns true if all GTIDs in set1 are also in set2. This function returns nonzero (true) if two GTID sets are the same set, even ... MySQL includes some built-in (native) functions for use with GTID-based ...
https://dev.mysql.com/replication-options-gtids.html
When binlog_gtid_simple_recovery=TRUE, which is the default in MySQL 8.0, the values of gtid_executed and gtid_purged are computed at startup based on the values of Previous_gtids_log_event in the most recent and oldest binary log files. If all ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/connecting-using-uri-or-key-value-pairs.html
For example: mysql://user@localhost:3306?get-server-public-key=true This option applies to clients that authenticate with the caching_sha2_password authentication plugin. compression: When set to true (or 1), this option enables compression of all ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/mysql-cluster-programs-ndb-perror.html
--ndb Property Value Command-Line Format --ndb Type Boolean Default Value TRUE For compatibility with applications depending on old versions of perror that use that program's --ndb option. --silent, -s Property Value Command-Line Format --silent ...
https://dev.mysql.com/c-api-data-structures.html
my_bool A boolean type, for values that are true (nonzero) or false (zero). Pass the type value to IS_NUM() and it evaluates to TRUE if the field is numeric: if (IS_NUM(field->type)) printf("Field is numeric\n"); ENUM and SET values are returned as ... This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream ...
