https://dev.mysql.com/server-configuration.html
Its output includes the default option and variable values and looks something like this: abort-slave-event-count 0 allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges ...
https://dev.mysql.com/audit-log-filtering.html
To assign a filter explicitly to a particular user account or accounts, define the filter, then assign it to the relevant accounts: SELECT audit_log_filter_set_filter('log_all', '{ "filter": { "log": true } }'); SELECT ... Note This section ...
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/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For the preceding example, if t2 contains any rows, even rows with nothing but NULL values, the EXISTS condition is TRUE. Formally, it answers the ...
https://dev.mysql.com/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
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/mysql-cluster-options-variables.html
This is also true if the node ID is specified as part of the connection string. This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general information on using these, and ...
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/mysql-cluster-what-is-new.html
The default value for TwoPassInitialNodeRestartCopy is changed from false to true. Note This parameter has no effect if at least one of the following conditions is true: ODirect is not enabled. Beginning with NDB 8.0.16, the default value of the ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-documents-remove.html
mysql-js> db.countryinfo.remove("true").limit(1) Query OK, 1 item affected (0.03 sec) The following example removes the last document in the countryinfo collection by country name. mysql-js> db.countryinfo.remove("true").sort(["Name desc"]).limit(1) ... You can use the remove() method to delete some or all documents from a collection in a ...
