Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.4/en/drop-event.html
DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. This statement requires the EVENT privilege for the schema to which the event to be dropped belongs. The event immediately ceases being active, and is deleted ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
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/workbench/en/wb-database-synchronization.html
Figure 9.58 Controlling Synchronization Direction In this case, the synchronization direction has been changed so that rather than the default action of friends being dropped from the live database, it will be incorporated into the MySQL Workbench ...For example, you can synchronize tables from a model to your database, other tables from your database to your model, and skip a few tables all during the same synchronization ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION [=] {'Y' | 'N'} } CREATE DATABASE creates a database with the given name. To ...For information about character set and collation names, see Chapter 12, Character Sets, Collations, ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
Important MySQL does not automatically revoke any privileges when you drop a database or table. The CREATE, DROP, EVENT, GRANT OPTION, LOCK TABLES, and REFERENCES privileges can be specified at the database level. Normally, a database administrator ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
Every database has a database character set and a database collation. The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET ...If CHARACTER SET charset_name is specified without COLLATE, character set charset_name and its default collation are ...