https://dev.mysql.com/json-function-reference.html
Table 12.21 JSON Functions Name Description JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON array -> Return value from JSON column after evaluating path; equivalent to ...
https://dev.mysql.com/plugin-data-structures.html
For example: static MYSQL_THDVAR_BOOL(some_flag, PLUGIN_VAR_NOCMDARG, "flag comment", NULL, NULL, FALSE); ... if (THDVAR(thd, some_flag)) { do_something(); THDVAR(thd, some_flag)= FALSE; } All global and session system variables must be published to ... A plugin library file includes descriptor information to indicate what plugins it ...
https://dev.mysql.com/binary-installation.html
shell> groupadd mysql shell> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ownership purposes, not login purposes, the useradd command uses the -r and -s /bin/false options to create a user that does not have ...
https://dev.mysql.com/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/subquery-materialization.html
oe [NOT] IN (SELECT ie ...) The predicate is IN or NOT IN and a result of UNKNOWN (NULL) has the same meaning as a result of FALSE. The following examples illustrate how the requirement for equivalence of UNKNOWN and FALSE predicate evaluation ...
https://dev.mysql.com/mysql-cluster-sci-definition.html
SendSignalId Table 22.330 This table provides type and value information for the SendSignalId SCI configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units boolean Default true Range true, false Restart Type N To trace a ...
https://dev.mysql.com/boolean-literals.html
The constants TRUE and FALSE evaluate to 1 and 0, respectively. mysql> SELECT TRUE, true, FALSE, false; -> 1, 1, 0, 0 .
https://dev.mysql.com/replication-gtids-functions.html
MySQL includes some built-in (native) functions for use with GTID-based replication. 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 ...
https://dev.mysql.com/mysql-cluster-mgm-definition.html
Wan Table 22.20 This table provides type and value information for the wan management node configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units boolean Default false Range true, false Restart Type N Use WAN TCP setting ... The [ndb_mgmd] section is used to configure the behavior of the management ...
https://dev.mysql.com/spatial-relation-functions-mbr.html
The return values 1 and 0 indicate true and false, respectively. If any argument is geometrically invalid, either the result is true or false (it is undefined which), or an error occurs. MySQL provides several MySQL-specific functions that test the ...
