https://dev.mysql.com/mysql-cluster-tcp-definition.html
TcpBind_INADDR_ANY Setting this parameter to TRUE or 1 binds IP_ADDR_ANY so that connections can be made from anywhere (for autogenerated connections). TCP/IP is the default transport mechanism for all connections between nodes in an NDB Cluster.
https://dev.mysql.com/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
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/string-comparison-functions.html
The same is true for aggregate queries involving NULL and comparisons using NOT RLIKE or NOT REGEXP. Table 12.8 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching ...
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/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
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-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 ...
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 ...
