UsefulLinks
Computer Science
Databases
MariaDB Database
1. Introduction to MariaDB
2. Installation and Initial Setup
3. SQL Fundamentals
4. Data Types
5. Advanced Querying
6. Built-in Functions
7. Advanced MariaDB Features
8. Storage Engines
9. Indexing and Performance Optimization
10. Database Administration
11. Security
12. Replication and High Availability
4.
Data Types
4.1.
Numeric Types
4.1.1.
Integer Types
4.1.1.1.
TINYINT
4.1.1.2.
SMALLINT
4.1.1.3.
MEDIUMINT
4.1.1.4.
INT
4.1.1.5.
BIGINT
4.1.2.
Fixed-Point Types
4.1.2.1.
DECIMAL
4.1.2.2.
NUMERIC
4.1.3.
Floating-Point Types
4.1.3.1.
FLOAT
4.1.3.2.
DOUBLE
4.1.4.
BOOLEAN
4.1.4.1.
Representation and Storage
4.2.
String Types
4.2.1.
CHAR and VARCHAR
4.2.1.1.
Differences and Use Cases
4.2.1.2.
Length Limits
4.2.2.
TEXT Types
4.2.2.1.
TINYTEXT
4.2.2.2.
TEXT
4.2.2.3.
MEDIUMTEXT
4.2.2.4.
LONGTEXT
4.2.3.
BINARY and VARBINARY
4.2.3.1.
Use Cases
4.2.3.2.
Storage Differences
4.2.4.
ENUM
4.2.4.1.
Defining Enumerated Values
4.2.4.2.
Use Cases and Limitations
4.2.5.
SET
4.2.5.1.
Defining Sets of Values
4.2.5.2.
Use Cases and Limitations
4.3.
Date and Time Types
4.3.1.
DATE
4.3.2.
TIME
4.3.3.
DATETIME
4.3.4.
TIMESTAMP
4.3.5.
YEAR
4.3.5.1.
Range and Storage
4.4.
JSON Data Type
4.4.1.
Storing JSON Documents
4.4.2.
JSON Validation
4.4.3.
JSON Functions
4.5.
Spatial Data Types
4.5.1.
Geometry Types
4.5.2.
Use Cases in GIS Applications
Previous
3. SQL Fundamentals
Go to top
Next
5. Advanced Querying