Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A table in a foreign key relationship cannot be altered to use another storage engine. When you add a foreign key constraint to a table using ALTER TABLE, remember to first create an index on the column(s) referenced by the foreign key. Dropping ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
altering table The server is in the process of executing an in-place ALTER TABLE. committing alter table to storage engine The server has finished an in-place ALTER TABLE and is committing the result. copy to tmp table The thread is processing an ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
(It is neither necessary nor desirable to use this option together with --initialize.) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] System Variable ndb_allow_copying_alter_table Scope ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
For example: mysql> ALTER TABLE demo_minilm_table SECONDARY_LOAD; This accelerates processing of vector distance function used to compare vector embeddings and generate relevant output later in this section. For example: mysql> ALTER TABLE ... GenAI ...A vector column containing the vector embeddings of the text ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/analyze-table.html
ANALYZE TABLE is supported for partitioned tables, and you can use ALTER TABLE ... ANALYZE PARTITION to analyze one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage bucket. This topic contains the following ...Selective Load Overview To edit the list of files comprising an external table, you can add or remove the file paths specified in the ENGINE_ATTRIBUTE option for the ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/check-table.html
CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ... CHECK PARTITION to check one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of ...option: ...The last row has a Msg_type value of status and the Msg_text normally should be ...