MySQL Database

  1. SQL Fundamentals: Data Definition Language (DDL)
    1. Database Management
      1. Creating Databases
        1. CREATE DATABASE Syntax
          1. Character Set Specification
            1. Collation Settings
              1. Database Options
              2. Database Selection
                1. USE Statement
                  1. Default Database Context
                    1. Database Switching
                    2. Database Information
                      1. SHOW DATABASES Command
                        1. Information Schema Queries
                          1. Database Metadata
                          2. Database Removal
                            1. DROP DATABASE Syntax
                              1. Safety Considerations
                                1. Backup Before Deletion
                              2. Table Management
                                1. Table Creation
                                  1. CREATE TABLE Syntax
                                    1. Column Definitions
                                      1. Data Type Specification
                                        1. Null/Not Null Constraints
                                          1. Default Values
                                          2. Table Options
                                            1. Storage Engine Selection
                                              1. Character Set and Collation
                                                1. Auto-Increment Settings
                                                2. Constraint Definitions
                                                  1. Primary Key Constraints
                                                    1. Foreign Key Constraints
                                                      1. Unique Constraints
                                                        1. Check Constraints
                                                      2. Table Information
                                                        1. SHOW TABLES Command
                                                          1. Table Structure Examination
                                                            1. DESCRIBE Command
                                                              1. SHOW CREATE TABLE
                                                                1. Information Schema Queries
                                                              2. Table Modification
                                                                1. ALTER TABLE Operations
                                                                  1. Adding Columns
                                                                    1. Column Position Specification
                                                                      1. Default Value Assignment
                                                                      2. Modifying Columns
                                                                        1. Data Type Changes
                                                                          1. Constraint Modifications
                                                                          2. Renaming Columns
                                                                            1. Dropping Columns
                                                                              1. Dependency Considerations
                                                                                1. Data Loss Implications
                                                                                2. Table Renaming
                                                                                  1. Constraint Management
                                                                                    1. Adding Constraints
                                                                                      1. Dropping Constraints
                                                                                        1. Modifying Constraints
                                                                                    2. Table Removal
                                                                                      1. DROP TABLE Command
                                                                                        1. Single Table Deletion
                                                                                          1. Multiple Table Deletion
                                                                                            1. Dependency Handling
                                                                                            2. TRUNCATE TABLE Command
                                                                                              1. Fast Data Removal
                                                                                                1. Auto-Increment Reset
                                                                                                  1. Transaction Considerations

                                                                                            Previous

                                                                                            3. MySQL Architecture

                                                                                            Go to top

                                                                                            Next

                                                                                            5. Data Types and Constraints