https://dev.mysql.com/stored-programs-defining.html
This enables the ; delimiter used in the procedure body to be passed through to the server rather than being interpreted by mysql itself. Each stored program contains a body that consists of an SQL statement. This statement may be a compound ...
https://dev.mysql.com/sys-diagnostics.html
in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of ...
https://dev.mysql.com/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 13.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 13.1.35, ...
https://dev.mysql.com/with.html
This constraint rules out mutually-recursive CTEs, where cte1 references cte2 and cte2 references cte1. These constraints come from the SQL standard, other than the MySQL-specific exclusions of ORDER BY, LIMIT, and DISTINCT. A CTE that produces many ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/writing-information-schema-plugins.html
The array pointed to by fields_info should contain one element per column of the INFORMATION_SCHEMA plus a terminating element. NAME is string-valued with a length of 10 and VALUE is integer-valued with a display width of 20. This section describes ...
https://dev.mysql.com/writing-semisynchronous-replication-plugins.html
This section describes how to write server-side semisynchronous replication plugins, using the example plugins found in the plugin/semisync directory of MySQL source distributions. That directory contains the source files for master and slave ...
https://dev.mysql.com/bit-functions.html
(The BIT_AND(), BIT_OR(), and BIT_XOR() aggregate functions are described in Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”.) Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned ...In MySQL 8.0, bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 ...
https://dev.mysql.com/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to slave servers. Inserts are performed into the master's table without explicitly setting the auto ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/c-api-binary-log-data-structures.html
C API functions for processing a replication event stream from a server require a connection handler (a MYSQL * pointer) and a pointer to a MYSQL_RPL structure that describes the steam of replication events to read from the server binary log. int ...Connection handlers are described in Section 28.6.4, “C API Data ...
https://dev.mysql.com/c-api-multiple-queries.html
By default, mysql_query() and mysql_real_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...MySQL also supports the execution of a string containing multiple statements separated by semicolon (;) ...
