MySQL Database

  1. SQL Fundamentals: Data Manipulation Language (DML)
    1. Inserting Data
      1. Basic INSERT Operations
        1. INSERT INTO VALUES Syntax
          1. Column List Specification
            1. Value List Matching
            2. Multiple Row Insertion
              1. Bulk Insert Syntax
                1. Performance Benefits
                  1. Transaction Considerations
                  2. Alternative INSERT Syntax
                    1. INSERT INTO SET Format
                      1. Column-Value Pairs
                        1. Readability Benefits
                        2. Handling Duplicate Keys
                          1. INSERT IGNORE
                            1. Duplicate Key Handling
                              1. Error Suppression
                              2. ON DUPLICATE KEY UPDATE
                                1. Upsert Operations
                                  1. Conditional Updates
                                    1. Value Expressions
                                  2. INSERT with Subqueries
                                    1. INSERT INTO SELECT
                                      1. Data Migration
                                        1. Conditional Insertion
                                      2. Updating Data
                                        1. Basic UPDATE Operations
                                          1. UPDATE SET WHERE Syntax
                                            1. Single Column Updates
                                              1. Multiple Column Updates
                                              2. Conditional Updates
                                                1. WHERE Clause Usage
                                                  1. Complex Conditions
                                                    1. Subquery Conditions
                                                    2. Multi-Table Updates
                                                      1. JOIN-Based Updates
                                                        1. Performance Considerations
                                                        2. Safe Update Practices
                                                          1. Transaction Usage
                                                            1. WHERE Clause Validation
                                                              1. Backup Strategies
                                                                1. sql_safe_updates Mode
                                                              2. Deleting Data
                                                                1. Basic DELETE Operations
                                                                  1. DELETE FROM WHERE Syntax
                                                                    1. Conditional Deletion
                                                                      1. All Row Deletion
                                                                      2. Multi-Table Deletes
                                                                        1. JOIN-Based Deletes
                                                                          1. Referential Integrity
                                                                          2. Safe Delete Practices
                                                                            1. Transaction Protection
                                                                              1. WHERE Clause Verification
                                                                                1. Backup Procedures
                                                                                  1. Soft Delete Alternatives
                                                                                  2. DELETE vs. TRUNCATE
                                                                                    1. Performance Differences
                                                                                      1. Transaction Behavior
                                                                                        1. Auto-Increment Handling

                                                                                    Previous

                                                                                    5. Data Types and Constraints

                                                                                    Go to top

                                                                                    Next

                                                                                    7. SQL Fundamentals: Data Query Language (DQL)