Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-resource-group.html
DROP RESOURCE GROUP group_name [FORCE] DROP RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”). Examples: Drop a group, failing if the group contains any threads: DROP RESOURCE GROUP rg1; Drop a group ...The FORCE modifier determines statement behavior if the resource group has any threads assigned to it: If FORCE is not given and any threads are assigned to the group, an error ...
https://dev.mysql.com/doc/refman/8.4/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. Note In MySQL 8.3 and earlier, DROP VIEW returns an error if any views ...For more information, see Section 15.1.1, “Atomic Data Definition Statement ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. Options that can be used with ndb_drop_index are shown in the following table. --database, -d ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
These terms are commonly used in information about the MySQL database server. These properties are all desirable in a database system, and are all closely tied to the notion of a transaction. When a transaction makes multiple changes to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. This is to ensure that the object to be dropped no longer ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function.html
The DROP FUNCTION statement is used to drop stored functions and loadable functions: For information about dropping stored functions, see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”. For information about dropping loadable ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. This statement is mapped to an ALTER TABLE statement to drop ...The table is not locked against access from other NDB Cluster API nodes, although it is locked against other operations on the same API node for the duration of the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
Renaming a table requires ALTER and DROP on the old table, ALTER, CREATE, and INSERT on the new table. Multiple ADD, ALTER, DROP, and CHANGE clauses are permitted in a single ALTER TABLE statement, separated by commas. For example, to drop multiple ... 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} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The temporary table comprising the new clustered index is renamed with the name of the original table, and the original table is dropped from the database. Dropping an index DROP INDEX name ON table; ALTER TABLE tbl_name DROP INDEX name; The table ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use ...