Search Results
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. To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 15.6.5.1, “CASE Statement”, for use inside stored programs. The CASE statement cannot have an ELSE NULL clause, and it ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
How do I set credentials for the distributed recovery process? You can set the user credentials permanently as the credentials for the group_replication_recovery channel, using a CHANGE REPLICATION SOURCE TO statement. You can specify them in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-plugins-table.html
The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
Parsed definitions are stored in the data dictionary cache to enable reuse and avoid incurring parsing overhead for every statement that needs SRS information. The description for this statement includes additional information about SRS components.
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
MySQL replication is based on the binary log where MySQL writes SQL statements that modify data. This is true whether you are using statement-based or row-based replication. It is possible to use replication in a way where the storage engine on the ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. (A warning does occur for statements that otherwise would not be permitted.) The PASSWORDLESS_USER_ADMIN privilege enables creation ... Authentication involves one party establishing its identity to the satisfaction of a second ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo.html
row *************************** Engine: ndbcluster Support: YES Comment: Clustered, fault-tolerant tables Transactions: YES XA: NO Savepoints: NO 10 rows in set (0.01 sec) If ndbinfo support is enabled, then you can access ndbinfo using SQL ...