PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
The LATERAL keyword must precede each table to be used as a lateral derived table. If a lateral derived table is in the right operand of a join clause and contains a reference to the left operand, the join operation must be an INNER JOIN, CROSS ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
(A warning occurs for statements that otherwise would not be permitted.) authentication_policy values can be defined in an option file or specified using a SET GLOBAL statement: SET GLOBAL authentication_policy='*,*,'; There are several rules that ... Authentication involves one party establishing its identity to the satisfaction of a second ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
The qualifier must be specified if there is no default database. For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
* Multiplication: mysql> SELECT 3*5; -> 15 mysql> SELECT 18014398509481984*18014398509481984.0; -> 324518553658426726783156020576256.0 mysql> SELECT 18014398509481984*18014398509481984; -> out-of-range error The last expression produces an error ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
ndb_sync_excluded_objects: Shows information about NDB database objects for which automatic synchronization has failed due to permanent errors resulting from mismatches which cannot be reconciled without manual intervention; these objects are ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...If you use it, MySQL ignores primary-key or unique-key violations and continues processing with the next ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
SOURCE The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs. CURRENT_SCHEMA The default database for the statement, NULL if there is none. For use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB. To prevent execution of statements ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. Descending indexes also make it possible for the optimizer to use multiple-column indexes when the ... MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending ...