Search Results
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. Must the replica be connected to the source all the time? A.14.2. Must I enable networking on my source and replica to enable ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...
https://dev.mysql.com/doc/refman/8.4/en/federated-storage-engine.html
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. To include the ...
https://dev.mysql.com/doc/refman/8.4/en/firewall.html
Note MySQL Enterprise Firewall is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
Some queries using these functions with system variables may be rejected with Illegal mix of collations as a result. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ...