PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
There must be no tables or stored procedures with individual ENUM or SET column elements that exceed 255 characters or 1020 bytes in length. Any such triggers must be dumped and restored to fix the issue. REORGANIZE PARTITION: ALTER TABLE table_name ... Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume also that the ...
https://dev.mysql.com/doc/refman/8.0/en/case.html
[ELSE statement_list] END CASE The CASE statement for stored programs implements a complex conditional construct. (The indentation used here in the ELSE clause is for purposes of clarity only, and is not otherwise significant.) DELIMITER | CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/conditions-and-parameters.html
If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller. If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
When the thread stack is too small, this limits the complexity of the SQL statements the server can handle, the recursion depth of stored procedures, and other memory-consuming actions. This section describes aspects of how the MySQL server manages ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. DROP FUNCTION [IF EXISTS] function_name This statement drops the ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-elements.html
Stored procedures perform tasks such as registering firewall profiles, establishing their operational mode, and managing transfer of firewall data between the cache and persistent storage. MySQL Enterprise Firewall is based on a plugin library that ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
Storage Engines Replication Framework Group Replication Settings Storage Engines For Group Replication, data must be stored in the InnoDB transactional storage engine (for details of why, see Section 20.3.1, “Group Replication Requirements”).