Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:database
|
| gptkbp:affects |
user privileges
SQL_MODE settings definer security context invoker security context transaction isolation level |
| gptkbp:canBe |
gptkb:transformation
privileges batch processing data validation business logic automation of repetitive tasks unit tests CALL statement |
| gptkbp:canBeDebuggedBy |
gptkb:MySQL_Workbench
|
| gptkbp:canBeListedBy |
SHOW PROCEDURE STATUS
|
| gptkbp:canBeNested |
yes
|
| gptkbp:canCreate |
CREATE PROCEDURE statement
|
| gptkbp:canDrop |
DROP PROCEDURE statement
|
| gptkbp:canImport |
gptkb:mysql_client
|
| gptkbp:documentedIn |
INFORMATION_SCHEMA.ROUTINES
|
| gptkbp:exportedTo |
gptkb:mysqldump
|
| https://www.w3.org/2000/01/rdf-schema#label |
MySQL stored procedures
|
| gptkbp:improves |
performance by reducing client-server communication
|
| gptkbp:introducedIn |
MySQL 5.0
|
| gptkbp:invokedFor |
events
applications triggers other stored procedures |
| gptkbp:mayInclude |
variables
error handling cursors control flow statements INOUT parameters input parameters output parameters |
| gptkbp:monitors |
performance_schema
|
| gptkbp:notableRelease |
ALTER PROCEDURE statement
|
| gptkbp:optimizedFor |
query optimization
|
| gptkbp:partOf |
gptkb:MySQL
|
| gptkbp:prohibits |
max_allowed_packet
max_sp_recursion_depth |
| gptkbp:purpose |
automate database tasks
encapsulate SQL logic |
| gptkbp:result |
output parameters
result sets |
| gptkbp:storage |
gptkb:dictionary
|
| gptkbp:supportsLanguage |
SQL
|
| gptkbp:bfsParent |
gptkb:SQL/PSM
|
| gptkbp:bfsLayer |
8
|