Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...For ...| ADD {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be used to partition an existing table that is not already ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...If you drop an AUTO_INCREMENT column ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
https://dev.mysql.com/doc/refman/8.4/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. If you use ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
MySQL creates or drops such indexes automatically when needed, as a side-effect of CREATE TABLE, CREATE INDEX, and ALTER TABLE statements. Please do "ALTER TABLE `%s` FORCE" or dump/reload to fix it! Error number: 1708; Symbol: ...Error number: ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
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, during the ALTER TABLE ... The InnoDB online DDL feature enhances performance for CREATE INDEX, DROP ...If ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
MySQL NDB Cluster 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 which ...For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The following table shows some possible values for authentication_policy and the policy that each establishes for creating or altering accounts. CREATE TABLE and ALTER TABLE having a CHARACTER SET utf8mb4 clause without a COLLATION clause, either ...