Search Results
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation. Dropping a database does not remove any TEMPORARY tables that were created in that database.
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ ... To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
For example: SET @g1 = ST_SRID(Point(1, 1), 4326); However, that method creates the geometry in SRID 0, then casts it to SRID 4326 (WGS 84). A preferable alternative is to create the geometry with the correct spatial reference system to begin with.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". It is good practice to start the bootstrap member first, and let it create the group. Creating ... 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/group-replication-deploying-locally.html
This section explains how to create a replication group with three MySQL Server instances on one physical machine. Create a directory named data, then in that directory create a subdirectory for each server instance, for example s1, s2 and s3, and ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
Rolling Migration Upgrade In this method you remove members from the group, upgrade them and then create a second group using the upgraded members. create a new group with the upgraded members, see Chapter 20, Group Replication. Rolling Duplication ... Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with an older version in ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
A stored program may include handlers to be invoked when certain conditions occur within the program. The applicability of each handler depends on its location within the program definition and on the condition or conditions that it handles: A ...