PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their privileges. The SQL SECURITY Characteristic For stored routines ...The ...
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/handler-scope.html
However, SQLSTATE handlers take precedence over SQLEXCEPTION handlers, so if the table t is nonexistent, the DROP TABLE statement raises a condition that activates the SQLSTATE handler: mysql> CALL p1(); +--------------------------------+ | msg | ...
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 ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-rejoin.html
The auto-rejoin attempts and the time between them are called the auto-rejoin procedure. If you do want to intervene to take the member offline during the auto-rejoin procedure, the member can be stopped manually at any time by using a STOP ... The ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
ALTER ROUTINE Enables use of statements that alter or drop stored routines (stored procedures and functions). CREATE ROUTINE Enables use of statements that create stored routines (stored procedures and functions). EXECUTE Enables use of statements ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL also can make some procedures shorter if a given handler can handle part of a situation, then pass the condition “up the line” to another handler. RESIGNAL may change some or all information before passing it on. RESIGNAL is related to ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
An API provides a stable set of names and types for functions, procedures, parameters, and return values. Historically, used by some Connector/J, Connector/ODBC, and Connector/PHP developers to work around issues with server-side stored procedures.
https://dev.mysql.com/doc/refman/8.0/en/grant.html
Never alter the structure of tables in the mysql system schema in any manner except by means of the procedure described in Chapter 3, Upgrading MySQL. The object_type clause, if present, should be specified as TABLE, FUNCTION, or PROCEDURE when the ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--exclude-routines=routine_list Command-Line Format --exclude-routines=routine_list Type String Do not dump the events in routine_list, which is a list of one or more comma-separated routine (stored procedure or function) names. mysqlpump ...