MySQL Database

  1. Data Types and Constraints
    1. Numeric Data Types
      1. Integer Types
        1. TINYINT
          1. Range and Storage
            1. Signed vs. Unsigned
              1. Use Cases
              2. SMALLINT
                1. Range and Storage
                  1. Performance Considerations
                  2. MEDIUMINT
                    1. MySQL-Specific Type
                      1. Storage Efficiency
                      2. INT (INTEGER)
                        1. Standard Integer Type
                          1. Common Usage Patterns
                          2. BIGINT
                            1. Large Number Storage
                              1. 64-bit Integer Support
                            2. Fixed-Point Types
                              1. DECIMAL (NUMERIC)
                                1. Precision and Scale
                                  1. Exact Numeric Storage
                                    1. Financial Calculations
                                  2. Floating-Point Types
                                    1. FLOAT
                                      1. Single Precision
                                        1. Approximate Storage
                                          1. Performance Characteristics
                                          2. DOUBLE (REAL)
                                            1. Double Precision
                                              1. Scientific Calculations
                                                1. Precision Limitations
                                              2. Numeric Type Selection
                                                1. Performance Considerations
                                                  1. Storage Requirements
                                                    1. Precision Requirements
                                                  2. String Data Types
                                                    1. Character String Types
                                                      1. CHAR
                                                        1. Fixed-Length Strings
                                                          1. Padding Behavior
                                                            1. Performance Characteristics
                                                            2. VARCHAR
                                                              1. Variable-Length Strings
                                                                1. Length Specification
                                                                  1. Storage Overhead
                                                                2. Text Types
                                                                  1. TINYTEXT
                                                                    1. Small Text Storage
                                                                      1. Length Limitations
                                                                      2. TEXT
                                                                        1. Medium Text Storage
                                                                          1. Common Usage
                                                                          2. MEDIUMTEXT
                                                                            1. Large Text Storage
                                                                              1. Extended Capacity
                                                                              2. LONGTEXT
                                                                                1. Maximum Text Storage
                                                                                  1. Very Large Documents
                                                                                2. Binary String Types
                                                                                  1. BINARY
                                                                                    1. Fixed-Length Binary
                                                                                      1. Byte-Oriented Storage
                                                                                      2. VARBINARY
                                                                                        1. Variable-Length Binary
                                                                                          1. Binary Data Handling
                                                                                        2. Binary Large Object Types
                                                                                          1. TINYBLOB
                                                                                            1. BLOB
                                                                                              1. MEDIUMBLOB
                                                                                                1. LONGBLOB
                                                                                                2. Enumerated and Set Types
                                                                                                  1. ENUM
                                                                                                    1. Predefined Value Lists
                                                                                                      1. Storage Efficiency
                                                                                                        1. Validation Benefits
                                                                                                        2. SET
                                                                                                          1. Multiple Value Selection
                                                                                                            1. Bit-Based Storage
                                                                                                              1. Use Case Scenarios
                                                                                                            2. Character Sets and Collations
                                                                                                              1. Character Set Selection
                                                                                                                1. Collation Rules
                                                                                                                  1. Unicode Support
                                                                                                                2. Date and Time Data Types
                                                                                                                  1. DATE Type
                                                                                                                    1. Date Range and Format
                                                                                                                      1. Storage Requirements
                                                                                                                        1. Input Formats
                                                                                                                        2. TIME Type
                                                                                                                          1. Time Range and Format
                                                                                                                            1. Fractional Seconds
                                                                                                                              1. Time Zone Considerations
                                                                                                                              2. DATETIME Type
                                                                                                                                1. Combined Date and Time
                                                                                                                                  1. Range and Precision
                                                                                                                                    1. Storage Characteristics
                                                                                                                                    2. TIMESTAMP Type
                                                                                                                                      1. Automatic Initialization
                                                                                                                                        1. Time Zone Handling
                                                                                                                                          1. Update Behavior
                                                                                                                                          2. YEAR Type
                                                                                                                                            1. Year-Only Storage
                                                                                                                                              1. Two vs. Four Digit Years
                                                                                                                                                1. Deprecated Features
                                                                                                                                                2. Date and Time Functions
                                                                                                                                                  1. Current Date/Time Functions
                                                                                                                                                    1. Date Arithmetic
                                                                                                                                                      1. Formatting Functions
                                                                                                                                                    2. Constraints and Modifiers
                                                                                                                                                      1. Column Constraints
                                                                                                                                                        1. PRIMARY KEY
                                                                                                                                                          1. Single Column Keys
                                                                                                                                                            1. Composite Keys
                                                                                                                                                              1. Auto-Generated Keys
                                                                                                                                                              2. FOREIGN KEY
                                                                                                                                                                1. Reference Specifications
                                                                                                                                                                  1. Referential Actions
                                                                                                                                                                    1. Constraint Naming
                                                                                                                                                                    2. UNIQUE
                                                                                                                                                                      1. Uniqueness Enforcement
                                                                                                                                                                        1. Multiple Unique Constraints
                                                                                                                                                                          1. Null Value Handling
                                                                                                                                                                          2. NOT NULL
                                                                                                                                                                            1. Null Value Prevention
                                                                                                                                                                              1. Default Value Interaction
                                                                                                                                                                              2. DEFAULT
                                                                                                                                                                                1. Default Value Assignment
                                                                                                                                                                                  1. Expression Defaults
                                                                                                                                                                                    1. Automatic Defaults
                                                                                                                                                                                    2. CHECK
                                                                                                                                                                                      1. Value Validation
                                                                                                                                                                                        1. Expression Constraints
                                                                                                                                                                                          1. MySQL 8.0 Support
                                                                                                                                                                                          2. AUTO_INCREMENT
                                                                                                                                                                                            1. Automatic Value Generation
                                                                                                                                                                                              1. Sequence Management
                                                                                                                                                                                                1. Custom Starting Values
                                                                                                                                                                                              2. Table-Level Constraints
                                                                                                                                                                                                1. Constraint Naming
                                                                                                                                                                                                  1. Constraint Management
                                                                                                                                                                                                    1. Constraint Validation

                                                                                                                                                                                                Previous

                                                                                                                                                                                                4. SQL Fundamentals: Data Definition Language (DDL)

                                                                                                                                                                                                Go to top

                                                                                                                                                                                                Next

                                                                                                                                                                                                6. SQL Fundamentals: Data Manipulation Language (DML)