MariaDB Database

  1. Data Types
    1. Numeric Types
      1. Integer Types
        1. TINYINT
          1. SMALLINT
            1. MEDIUMINT
              1. INT
                1. BIGINT
                2. Fixed-Point Types
                  1. DECIMAL
                    1. NUMERIC
                    2. Floating-Point Types
                      1. FLOAT
                        1. DOUBLE
                        2. BOOLEAN
                          1. Representation and Storage
                        3. String Types
                          1. CHAR and VARCHAR
                            1. Differences and Use Cases
                              1. Length Limits
                              2. TEXT Types
                                1. TINYTEXT
                                  1. TEXT
                                    1. MEDIUMTEXT
                                      1. LONGTEXT
                                      2. BINARY and VARBINARY
                                        1. Use Cases
                                          1. Storage Differences
                                          2. ENUM
                                            1. Defining Enumerated Values
                                              1. Use Cases and Limitations
                                              2. SET
                                                1. Defining Sets of Values
                                                  1. Use Cases and Limitations
                                                2. Date and Time Types
                                                  1. DATE
                                                    1. TIME
                                                      1. DATETIME
                                                        1. TIMESTAMP
                                                          1. YEAR
                                                            1. Range and Storage
                                                          2. JSON Data Type
                                                            1. Storing JSON Documents
                                                              1. JSON Validation
                                                                1. JSON Functions
                                                                2. Spatial Data Types
                                                                  1. Geometry Types
                                                                    1. Use Cases in GIS Applications

                                                                  Previous

                                                                  3. SQL Fundamentals

                                                                  Go to top

                                                                  Next

                                                                  5. Advanced Querying