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-cluster-replication-schema.html
Note When performing schema changes on NDB tables, applications should wait until the ALTER TABLE statement has returned in the MySQL client connection that issued the statement before attempting to use the updated definition of the table. This is ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
If an ALTER TABLE operation runs out of space, it starts a rollback, and that can take hours if it is disk-bound. Declare the PRIMARY KEY clause in the original CREATE TABLE statement, rather than adding it later through an ALTER TABLE statement.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Partitioning and repartitioning operations (such as ALTER TABLE with PARTITION BY ..., REORGANIZE PARTITION, or REMOVE PARTITIONING) depend on file system operations for their implementation. CREATE TABLE and ALTER TABLE statements that would result ...Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
In this case, OPTIMIZE TABLE is just mapped to ALTER TABLE. InnoDB Details For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE ... OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
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 ...ALTER USER may be used to change the nonprivilege characteristics of existing ...[WITH ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
Only statements involving tables are affected, not statements such as CREATE DATABASE, DROP DATABASE, and ALTER DATABASE. If the table name pattern is %, it matches any table name and the option also applies to database-level statements (CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...A ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The value in effect for CREATE TABLE, or a subsequent ALTER TABLE or TRUNCATE TABLE, is the value used for the life of the table. To free up the memory used by deleted rows, use ALTER TABLE ENGINE=MEMORY to force a table rebuild. The MEMORY storage ...A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or ...