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/optimizer-hints.html
For example, you can enable an optimization for one table in a statement and disable the optimization for a different table. References to table and index names follow the usual identifier case-sensitivity rules (see Section 11.2.3, “Identifier ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to create a PRIMARY KEY; use ALTER TABLE instead. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX ...
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. CREATE TABLESPACE Enables use of statements that create, alter, or drop ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
If you use ALTER TABLE to change a MERGE table to another storage engine, the mapping to the underlying tables is lost. Instead, the rows from the underlying MyISAM tables are copied into the altered table, which then uses the specified storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
When setting MaxNoOfAttributes, it is important to prepare in advance for any ALTER TABLE statements that you might want to perform in the future. This is due to the fact, during the execution of ALTER TABLE on a Cluster table, 3 times the number of ...Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration ...
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/information-schema-tables-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
The TABLESPACE option can be used with ALTER TABLE to move tables between general tablespaces, file-per-table tablespaces, and the system tablespace. Moving Tables Between Tablespaces Using ALTER TABLE ALTER TABLE with the TABLESPACE option can be ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...To make ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. Changing a column's blob part size must be done using a copying ALTER TABLE; this operation cannot be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished using the ALTER TABLE statement with the DROP PARTITION option. To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr ...For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY ... Adding and dropping of ...