MySQL Database

  1. Stored Routines and Triggers
    1. Stored Procedures
      1. Procedure Fundamentals
        1. Code Reusability
          1. Performance Benefits
            1. Security Advantages
            2. Creating Procedures
              1. CREATE PROCEDURE Syntax
                1. Procedure Body Definition
                  1. Delimiter Usage
                  2. Procedure Parameters
                    1. IN Parameters
                      1. Input Value Passing
                        1. Read-Only Access
                        2. OUT Parameters
                          1. Output Value Return
                            1. Result Communication
                            2. INOUT Parameters
                              1. Bidirectional Value Passing
                                1. Value Modification
                              2. Procedure Execution
                                1. CALL Statement
                                  1. Parameter Passing
                                    1. Result Handling
                                    2. Procedure Management
                                      1. ALTER PROCEDURE
                                        1. DROP PROCEDURE
                                          1. Procedure Information Queries
                                        2. Stored Functions
                                          1. Function Fundamentals
                                            1. Return Value Requirement
                                              1. Expression Usage
                                                1. Deterministic Behavior
                                                2. Creating Functions
                                                  1. CREATE FUNCTION Syntax
                                                    1. Return Type Specification
                                                      1. Function Body Implementation
                                                      2. Function Characteristics
                                                        1. Deterministic vs. Non-Deterministic
                                                          1. SQL Data Access
                                                            1. Security Context
                                                            2. Function Usage
                                                              1. SELECT Statement Integration
                                                                1. Expression Evaluation
                                                                  1. Calculated Column Creation
                                                                  2. Function Management
                                                                    1. ALTER FUNCTION
                                                                      1. DROP FUNCTION
                                                                        1. Function Metadata Access
                                                                      2. Control Flow Structures
                                                                        1. Conditional Statements
                                                                          1. IF-THEN-ELSE
                                                                            1. CASE Statements
                                                                              1. Nested Conditions
                                                                              2. Loop Structures
                                                                                1. WHILE Loops
                                                                                  1. REPEAT Loops
                                                                                    1. LOOP Statements
                                                                                    2. Flow Control
                                                                                      1. LEAVE Statements
                                                                                        1. ITERATE Statements
                                                                                          1. Label Usage
                                                                                        2. Triggers
                                                                                          1. Trigger Fundamentals
                                                                                            1. Automatic Execution
                                                                                              1. Event-Driven Programming
                                                                                                1. Data Integrity Enforcement
                                                                                                2. Trigger Types
                                                                                                  1. BEFORE Triggers
                                                                                                    1. Pre-Event Execution
                                                                                                      1. Data Validation
                                                                                                        1. Value Modification
                                                                                                        2. AFTER Triggers
                                                                                                          1. Post-Event Execution
                                                                                                            1. Logging and Auditing
                                                                                                              1. Cascading Operations
                                                                                                            2. Trigger Events
                                                                                                              1. INSERT Triggers
                                                                                                                1. New Row Processing
                                                                                                                  1. Default Value Assignment
                                                                                                                  2. UPDATE Triggers
                                                                                                                    1. Row Modification Handling
                                                                                                                      1. Change Tracking
                                                                                                                      2. DELETE Triggers
                                                                                                                        1. Row Removal Processing
                                                                                                                          1. Cleanup Operations
                                                                                                                        2. Trigger Creation
                                                                                                                          1. CREATE TRIGGER Syntax
                                                                                                                            1. Event Specification
                                                                                                                              1. Trigger Body Definition
                                                                                                                              2. Trigger Management
                                                                                                                                1. DROP TRIGGER
                                                                                                                                  1. Trigger Information Queries
                                                                                                                                    1. Trigger Debugging
                                                                                                                                  2. Event Scheduler
                                                                                                                                    1. Event Scheduler Overview
                                                                                                                                      1. Automated Task Execution
                                                                                                                                        1. Scheduled Maintenance
                                                                                                                                          1. Background Processing
                                                                                                                                          2. Event Creation
                                                                                                                                            1. CREATE EVENT Syntax
                                                                                                                                              1. Schedule Specification
                                                                                                                                                1. Event Body Definition
                                                                                                                                                2. Event Scheduling
                                                                                                                                                  1. One-Time Events
                                                                                                                                                    1. Recurring Events
                                                                                                                                                      1. Complex Schedules
                                                                                                                                                      2. Event Management
                                                                                                                                                        1. ALTER EVENT
                                                                                                                                                          1. DROP EVENT
                                                                                                                                                            1. Event Status Control
                                                                                                                                                            2. Scheduler Administration
                                                                                                                                                              1. Enabling Event Scheduler
                                                                                                                                                                1. Monitoring Event Execution
                                                                                                                                                                  1. Event Log Analysis

                                                                                                                                                              Previous

                                                                                                                                                              11. Transactions and Concurrency

                                                                                                                                                              Go to top

                                                                                                                                                              Next

                                                                                                                                                              13. User Management and Security