https://dev.mysql.com/mysql-shell-tutorial-javascript-indexes-create.html
If the value is false, the field can contain NULL values. field("demographics.Population", "INTEGER", false).execute() Query OK (0.04 sec) To create a unique index, pass to the createIndex() method an index name and the mysqlx.IndexType.UNIQUE type.
https://dev.mysql.com/mysql-shell-tutorial-python-documents-index.html
If the value is False, the field can contain NULL values. mysql-js> db.countryinfo.create_index("pop").\ field("demographics.Population", "INTEGER", False).execute() Query OK (0.04 sec) To create a unique index, pass to the create_index() method an ... Indexes are used to find documents with specific field values ...
https://dev.mysql.com/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...
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/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 ...
https://dev.mysql.com/spatial-relation-functions-object-shapes.html
The return values 1 and 0 indicate true and false, respectively, except for ST_Distance(), which returns distance values. If any geometry argument is geometrically invalid, either the result is true or false (it is undefined which), or an error ...
https://dev.mysql.com/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. mysql> CALL ...
https://dev.mysql.com/all-subqueries.html
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 expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The ...
https://dev.mysql.com/any-in-some-subqueries.html
The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is unknown (that is, NULL) if table t2 ...
