Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/innodb-row-format.html
To store DYNAMIC tables in the system tablespace, either disable innodb_file_per_table and use a regular CREATE TABLE or ALTER TABLE statement, or use the TABLESPACE [=] innodb_system table option with CREATE TABLE or ALTER TABLE. The row format of ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...As more rows fit into a single disk page, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
INSTANT_COLS shows number of columns in the table prior to adding the first instant column using ALTER TABLE ... The HAS_DEFAULT and DEFAULT_VALUE columns only apply to columns added instantly using ALTER TABLE ... You can extract metadata about ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
REPAIR PARTITION to repair one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of Partitions”. [QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
A table-copying ALTER TABLE operation on a table that resides in a shared tablespace can increase the amount of disk space occupied by the tablespace. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on ...Changing the setting at runtime requires privileges sufficient to set global system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
ALTER SCHEMA and ALTER TABLESPACE operations do not apply the default_table_encryption setting. An ENCRYPTION clause must be specified explicitly to alter the encryption of an existing schema or general tablespace. When ... InnoDB supports ...InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...The atomic DDL feature is described under the following topics in this section: Supported DDL Statements Atomic DDL Characteristics DDL Statement Behavior Storage Engine Support Viewing DDL Logs Supported DDL Statements The atomic DDL feature supports both table and non-table DDL ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
CREATE TABLE, ALTER TABLE, and DROP TABLE are valid operations on a log table. For ALTER TABLE and DROP TABLE, the log table cannot be in use and must be disabled, as described later. The log tables can be altered to use the MyISAM storage engine.
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
TABLESPACE [=] tablespace_name or ALTER TABLE tbl_name TABLESPACE [=] tablespace_name to add tables to the tablespace. Additional data files may be added to the tablespace by using the ALTER TABLESPACE statement (see Section 15.1.10, “ALTER ...The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...