Search Results
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
To start, select Synchronize With Any Source from the Database navigation menu, as the following figure shows. Figure 9.57 Model and Database Differences In the preceding example, the live database and model both have movies shows tables. Figure ...
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/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/internals/en/event-data-for-specific-event-types.html
The length of the name of the database which was the default database when the statement was executed. It is necessary for statements such as INSERT INTO t VALUES(1) that don't specify the database and rely on the default database previously ... The ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping ...The log file group must already exist or an error ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...