Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
(The ALTER ROUTINE privilege is required to drop the routine.) The server also automatically drops those privileges from the creator when the routine is dropped. If automatic_sp_privileges is 0, the server does not automatically add or drop these ...
https://dev.mysql.com/doc/internals/en/prepared-stored-procedure-execution.html
Execution of a stored procedure statement is similar to execution of a prepared statement. During execution of a stored procedure, THD::stmt_arena points to the permanent query arena of the stored procedure. This arena happens to be also the ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used to re-create the named stored procedure. The value displayed for the Create Procedure or Create Function field is NULL if you have ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. For each ...
https://dev.mysql.com/doc/internals/en/class-procedure.html
For a minimal dummy procedure that doesn't actually change the result set it would look like this: class proc_dummy: public Procedure { } In a real procedure you'd extend at least some of the member functions below: .
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. A ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
MySQL Enterprise Firewall Stored Procedures MySQL Enterprise Firewall stored procedures perform tasks such as registering profiles with the firewall, establishing their operational mode, and managing transfer of firewall data between the cache and ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/internals/en/result-postprocessing-procedures.html
Note This section is not about SQL stored procedures but about MySQL procedures like Using PROCEDURE ANALYSE. For internal information on SQL stored procedures see the Chapter 16, Stored Programs.
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
ALTER ROUTINE Enables use of statements that alter or drop stored routines (stored procedures and functions). Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. The CREATE ROLE and DROP ROLE privileges ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-sign-procedure.html
Sign-up Procedure 2.2.2 Sign-up Procedure To sign up for MySQL HeatWave on AWS: Create an Oracle Cloud Account (or proceed to Step 2 below if you already have one): Navigate to https://cloud.mysql.com and click Sign Up. In the verification email, ...