https://dev.mysql.com/mysql-shell-tutorial-python-documents-index.html
In the following example, "Text(40)" represents the number of characters to index and True indicates that the field cannot contain any NULL values. mysql-js> db.countryinfo.create_index("name", mysqlx.IndexType.UNIQUE).\ field("Name", "TEXT(40)", ...
https://dev.mysql.com/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/partitioning-selection.html
p5) VALUES -> (24, 'Tim', 'Greene', 3, 1), (26, 'Linda', 'Mills', 2, 1); Query OK, 2 rows affected (0.06 sec) Records: 2 Duplicates: 0 Warnings: 0 The preceding is true for both INSERT statements and REPLACE statements that write multiple rows.
https://dev.mysql.com/password-management.html
(This means that in the examples just shown, the statements that explicitly name the account for jeffrey fail unless the current user is jeffrey.) This is true even if the change is attempted for another user by a privileged user; however, such a ...
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/performance-schema-statement-digests.html
The MySQL server is capable of maintaining statement digest information. The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/performance-schema-thread-filtering.html
For the Performance Schema to monitor a thread, these things must be true: The thread_instrumentation consumer in the setup_consumers table must be YES. This includes wait, stage, statement, and transaction events and affects logging to these ...
https://dev.mysql.com/plugin-data-structures.html
The same is not true for a library that contains server plugins. (0 = false, 1 = true) MYSQL_THDVAR_BOOL(name, opt, comment, check, update, default) MYSQL_SYSVAR_BOOL(name, varname, opt, comment, check, update, default) String system variables of ...
https://dev.mysql.com/problems-with-null.html
In SQL, the NULL value is never true in comparison to any other value, even NULL. The following statement returns no rows, because expr = NULL is never true for any expression: mysql> SELECT * FROM my_table WHERE phone = NULL; To look for NULL ...
https://dev.mysql.com/replication-options.html
server_uuid The MySQL server generates a true UUID in addition to the default or user-supplied server ID set in the server_id system variable. In addition, the slave I/O thread generates a warning if either of the following is true: No master having ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
