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/privileges-provided.html
ALTER Enables use of the ALTER TABLE statement to change the structure of tables. Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. ALTER ROUTINE Enables use of statements that alter or drop stored ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
altering table The server is in the process of executing an in-place ALTER TABLE. committing alter table to storage engine The server has finished an in-place ALTER TABLE and is committing the result. copy to tmp table The thread is processing an ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-objects.html
Every CREATE LOGFILE GROUP and ALTER LOGFILE GROUP statement must include an ENGINE option. See Section 15.1.16, “CREATE LOGFILE GROUP Statement”, and Section 15.1.6, “ALTER LOGFILE GROUP Statement”, for more information about these ... NDB ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
ANSI In ODBC, an alternative method of supporting character sets and other internationalization aspects. The .cfg file is copied along with the corresponding .ibd file, and used to adjust the internal values of the .ibd file, such as the space ID, ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
See Section 25.6.12, “Online Operations with ALTER TABLE in NDB Cluster”, for more information. A downgrade from NDB 8.0 to an older version of the NDB Cluster software requires manual removal of any binary configuration files or, alternatively, ... The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. If you have deleted a large number of rows from a partition or if ... A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Alternatively, double quotation marks (") can be used if the ANSI_QUOTES SQL mode is enabled. A table in a foreign key relationship cannot be altered to use another storage engine. When you add a foreign key constraint to a table using ALTER TABLE, ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... (Before importing, you must discard the tablespace of the receiving table.) mysql> ALTER TABLE t1 DISCARD TABLESPACE; On the source ... This ...