PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table has these indexes: Primary key on (UDF_NAME) TRUNCATE TABLE is not permitted for the user_defined_functions table. The user_defined_functions table contains a row for each loadable function registered automatically ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-variable-tables.html
The user_variables_by_thread table has these indexes: Primary key on (THREAD_ID, VARIABLE_NAME) TRUNCATE TABLE is not permitted for the user_variables_by_thread table. The Performance Schema provides a user_variables_by_thread table that exposes ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-users-table.html
The users table has these indexes: Primary key on (USER) . The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
Columns that are part of a PRIMARY KEY are made NOT NULL even if not declared that way. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Beginning with MySQL 8.0.19, time ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
From MySQL 8.0.30, when Step 2 is upgrading the system tables in the mysql schema, the column order in the primary key of the mysql.db, mysql.tables_priv, mysql.columns_priv and mysql.procs_priv tables is changed to place the host name and user name ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
A table that is used with a WHERE clause on a PRIMARY KEY or a UNIQUE index, where all index parts are compared to constant expressions and are defined as NOT NULL. All of the following tables are used as constant tables: SELECT * FROM t WHERE ...