Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. IF EXISTS is used to prevent an error from occurring if the database does not exist. Be very careful with this statement! To use ...
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. If the event does not exist, the error ERROR 1517 (HY000): Unknown event 'event_name' results. You can override this and cause the statement to generate a warning ...
https://dev.mysql.com/doc/refman/8.4/en/drop-procedure.html
DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or function). It prevents an error from occurring if the procedure or function does not exist. (DROP FUNCTION is also used to ...
https://dev.mysql.com/doc/refman/8.4/en/drop-resource-group.html
If FORCE is given, existing threads in the group are moved to their respective default group (system threads to SYS_default, user threads to USR_default). Examples: Drop a group, failing if the group contains any threads: DROP RESOURCE GROUP rg1; ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. How do I import an existing MySQL database into an NDB Cluster? You can import databases into NDB Cluster much as you would with any other version of MySQL. It is also possible ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
If the profile previously existed, any recording limitation for it remains unchanged. The account profile must exist, and must not currently be in RECORDING mode. group: The name of the new group profile, which must not already exist. When enabled, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-communication-protocol.html
When a new member joins a replication group, it checks the communication protocol version that is announced by the existing members of the group. All existing members of the group return the same communication protocol version. The ... Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
The connection that an existing member offers to a joining member for Group Replication's distributed recovery process is not the network address configured by group_replication_local_address. In other words, any existing data which is on the server ... This section explains the configuration settings required for MySQL Server instances that you want to use for Group ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
ON DUPLICATE KEY UPDATE statements, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row is updated, and 0 if an existing row is set to its current values. If you specify the CLIENT_FOUND_ROWS flag, the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-internal-data.html
Data retrieved from the lock tables exists when the SELECT is executed, but might be gone or changed by the time the query result is consumed by the client. Joining data_locks with data_lock_waits can show rows in data_lock_waits that identify a ...