https://dev.mysql.com/create-event.html
To create an event which occurs at some point in the future relative to the current date and time—such as that expressed by the phrase “three weeks from now”—you can use the optional clause + INTERVAL interval. CREATE [DEFINER = user] EVENT ...
https://dev.mysql.com/creating-spatial-columns.html
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...
https://dev.mysql.com/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/error-log-component-configuration.html
Note Assigning log_error_services a value that contains no writer components causes no log output to be written from that point. In MySQL 8.0, error logging uses the MySQL component architecture described at Section 5.5, “MySQL Server ...
https://dev.mysql.com/explain-output.html
The sort is done by going through all rows according to the join type and storing the sort key and pointer to the row for all rows that match the WHERE clause. The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN ...
https://dev.mysql.com/faqs-innodb-change-buffer.html
For example: ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges Relevant data points include: size: The number of pages used within ...
https://dev.mysql.com/federated-create-connection.html
Only mysql is supported as the scheme value at this point. To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL ...
https://dev.mysql.com/federated-description.html
Instead, the table definition includes a connection string that points to the remote table. 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 ...
https://dev.mysql.com/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”. Also, MySQL Enterprise Firewall does not work together with the query cache; ...
