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/stored-programs-defining.html
For example, the following stored procedure has a body made up of a BEGIN ... The delimiter is changed to // to enable the entire definition to be passed to the server as a single statement, and then restored to ; before invoking the procedure. This ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-metadata.html
To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines.html
Banks, for example, use stored procedures and functions for all common operations. Additional Resources You may find the Stored Procedures User Forum of use when working with stored procedures and functions. For answers to some commonly asked ...A ...This provides a consistent and secure environment, and routines can ensure that each operation is properly ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. Terminology used in this document reflects the stored object hierarchy: Stored routines include stored ...It ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A ...To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that includes the ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
It displays a representation of the internal implementation of the named stored procedure. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. A similar ...To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, or have the SELECT privilege at the global ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or function). (DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for ...(If ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-variables.html
In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and functions) can be declared to take parameters that communicate values between the routine and its caller. It is not permitted to assign the ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.