Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
Use of DROP TABLE with a MERGE table drops only the MERGE specification. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
A DROP TABLE or TRUNCATE TABLE operation on an NDB table frees the memory that was used by this table for re-use by any NDB table, either by the same table or by another NDB table. As each DataMemory page is used, it is assigned to a specific table; ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
It is not possible to drop partitions from NDB tables using ALTER TABLE ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
--drop-source Command-Line Format --drop-source Drop source table after all rows have been moved. Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the following ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-table-delete.html
Drop a Table The dropCollection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-js> session.dropCollection("world_x", "citytest") ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-delete.html
Drop a Table The drop_collection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-py> db.drop_collection("citytest") Related Information ... You can use the delete() method to remove some or all records from a table in a ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. drop db_name Delete the database named db_name and all its tables. (See Section 8.4.1.4, “Client-Side Cleartext Pluggable ...Invoke ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE ...Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated indexes by creating the table without secondary indexes, then adding secondary indexes after the data is ...
https://dev.mysql.com/doc/refman/8.4/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 ... Table nt contains no foreign key references, and no other table has any foreign keys ...