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/firewall-usage.html
Grant the EXECUTE privilege for the firewall stored procedures in the mysql system database. These may invoke administrative functions, so stored procedure access also requires the privileges indicated earlier that are needed for those functions.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
These include DML and DDL operations on tables, views, stored procedures, and stored functions, as well as LOCK TABLES, FLUSH TABLES WITH READ LOCK, and HANDLER statements. For details, see Section 10.2.1.16, “ORDER BY Optimization” ...Note Some ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
Valid target designators for storing item information can be stored procedure or function parameters, stored program local variables declared with DECLARE, or user-defined variables. Valid condition_number designators can be stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
Valid simple_value_specification designators can be specified using stored procedure or function parameters, stored program local variables declared with DECLARE, user-defined variables, system variables, or literals. The warning does not terminate ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). If the routine is a stored procedure, this value is empty. If the routine is a stored procedure, this value is NULL. If the routine is a stored ...DATA_TYPE If the routine is a stored function, the return value data ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
The statement executes a stored procedure that sets the new limit. This is also true for any statement inside a stored procedure; the statement is prepared once, when the stored procedure is first executed. A user variable referenced by a statement ...MySQL now incorporates a transactional data dictionary that stores information about database ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
Note The rules table is loaded into the plugin by the flush_rewrite_rules stored procedure. Load operations (performed by invoking the flush_rewrite_rules() stored procedure) load the rule from the table into the Rewriter in-memory cache only if ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
The available scripts differ in the file name used to refer to the script: win_install_firewall.sql linux_install_firewall.sql The installation script creates stored procedures in the default database, mysql. MySQL Enterprise Firewall installation ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
Transactions and Stored Programs Transactions and stored program events are related as follows: Stored Procedures Stored procedures operate independently of transactions. A stored procedure can be started within a transaction, and a transaction can ...These tables store transaction events: events_transactions_current: The current transaction event for each ...Within the event ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
A stored program may include handlers to be invoked when certain conditions occur within the program. When a condition occurs in a stored program, the server searches for applicable handlers in the current scope (current BEGIN ... If there is no ...