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/mysql-command-options.html
The initiate registration step executes this statement: ALTER USER user factor INITIATE REGISTRATION The statement returns a result set containing a 32 byte challenge, the user name, and the relying party ID (see authentication_fido_rp_id). The ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
In such cases, it is necessary to alter any tables using utf8mb4_ai_ci so that they use a character set supported in the older version prior to performing the backup. Due to changes in how the MySQL Server and NDB handle table metadata, tables ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
In MySQL 8.0, all rows relating to employees working at stores in that region can be deleted with the query ALTER TABLE employees TRUNCATE PARTITION pWest, which can be executed much more efficiently than the equivalent DELETE statement DELETE FROM ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE statement to add new partitions for stores 21-25, 26-30, and so on (see Section 26.3, “Partition Management”, for details of ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache. This section describes the conditions that are favorable for SSL session reuse, the server variables ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
Note Rather than using SET PASSWORD to assign passwords, ALTER USER is the preferred statement for account alterations, including assigning passwords. For example: ALTER USER user IDENTIFIED BY 'auth_string'; Note Clauses for random password ... SET ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. The ALTER TABLE statement produces three warning messages (strict SQL mode is disabled for the example to ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to cause the server to load it ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
If the pointer size is too small for an existing table, you can change the options with ALTER TABLE to increase a table's maximum permissible size. ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, “DROP VIEW Statement”). The CREATE VIEW statement creates a new view (see Section 15.1.23, ...