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/create-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...(Some valid select or union statement) CREATE TABLE creates a table with the given ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
MySQL NDB Cluster 8.0 supports online table schema changes using ALTER TABLE ... We sometimes refer to this as a “copying” or “offline” ALTER TABLE. DML operations are not permitted concurrently with a copying ALTER TABLE. The mysqld on ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
The privilege check occurs when creating or altering a schema or general tablespace with an encryption setting that differs from the default_table_encryption setting, or when creating or altering a table with an encryption setting that differs from ...In previous MySQL releases, dictionary data was stored in metadata files and nontransactional ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
A newly created secondary index contains only the committed data in the table at the time the CREATE INDEX or ALTER TABLE statement finishes executing. Dropping an index DROP INDEX name ON table; ALTER TABLE tbl_name DROP INDEX name; The table ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
Note If you use ALTER TABLE on a locked table, it may become unlocked. For example, if you attempt a second ALTER TABLE operation, the result may be an error Table 'tbl_name' was not locked with LOCK TABLES. To handle this, lock the table again ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
innodb_api_enable_mdl Command-Line Format --innodb-api-enable-mdl[={OFF|ON}] Deprecated 8.0.22 System Variable innodb_api_enable_mdl Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF Locks the table used by the InnoDB ...
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. In addition, ALTER TABLE table ENGINE = NDB, where table uses a storage engine other than NDB prior to execution of the statement, may also execute ...NDB 8.0 removes the previous 63-byte limit on identifiers for databases and ... The following sections describe changes in the implementation of MySQL NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
This may be desirable when backing up and restoring between different schema versions with primary key changes on one or more tables, and it appears that performing the restore operation using ndb_restore is simpler or more efficient than issuing ...
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 ...As a faster way of moving data than importing a dump file, which requires reinserting data and rebuilding ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... You should also be aware of the following effects of ALTER TABLE ... The IGNORE keyword ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...