MariaDB merupakan versi pengembangan terbuka dan mandiri dari MySQL. Sejak diakuisisinya MySQL oleh Oracle pada September 2010, Monty Program sebagai penulis awal kode sumber MySQL memisahkan diri dari pengembangan dan membuat versi yang lebih mandiri yakni MariaDB.
Dalam tulisan ini saya share tentang Tipe data pada Database Baru, Sebagai berikut :
Numeric Data Types:
1. TINYINT : Tiny integer, -128 to 127 signed
2. BOOLEAN : Synonym for TINYINT(1)
3. SMALLINT : Small integer from -32768 to 32767 signed
4. MEDIUMINT : Medium integer from -8388608 to 8388607 signed
5. INT : Integer from -2147483648 to 2147483647 signed
6. INTEGER : Synonym for INT
7. BIGINT : Large integer
8. DECIMAL : A packed "exact" fixed-point number.
9. DEC, NUMERIC, FIXED :Synonyms for DECIMAL
9. FLOAT : Single-precision floating-point number
10. DOUBLE : Normal-size (double-precision) floating-point number
11. DOUBLE PRECISION : REAL and DOUBLE PRECISION are synonyms for DOUBLE.
12. BIT : Bit field type
String Data Types :
1. CHAR : Fixed-length string.
2. VARCHAR : Variable-length string.
3. BINARY : Fixed-length binary byte string.
4. CHAR BYTE : Alias for BINARY.
5. VARBINARY : Variable-length binary byte string.
6. TINYBLOB : Tiny binary large object up to 255 bytes.
7. BLOB : Binary large object up to 65,535 bytes.
8. MEDIUMBLOB : Medium binary large object up to 16,777,215 bytes.
9. LONGBLOB : Long BLOB holding up to 4GB.
10. TINYTEXT : A TEXT column with a maximum length of 255 characters.
11. TEXT : A TEXT column with a maximum length of 65,535 characters.
12. MEDIUMTEXT : A TEXT column with a maximum length of 16,777,215 characters.
13. LONGTEXT : A TEXT column with a maximum length of 4,294,967,295 characters.
14. JSON Data Type : Compatibility data type that is an alias for LONGTEXT.
15. ENUM : Enumeration, or string object that can have one value chosen from a list of values.
16. ROW : Data type for stored procedure variables.
Date and Time Data Types
1. DATE : The date type YYYY-MM-DD
2. TIME : Time format HH:MM:SS.ssssss
3. DATETIME : Date and time combination displayed as YYYY-MM-DD HH:MM:SS.
4. TIMESTAMP : YYYY-MM-DD HH:MM:SS
5. YEAR : Data Type A four-digit year
Other Data Types Articles
1. Geometry Types : Supported geometry types
2. AUTO_INCREMENT : Automatic increment.
3. AUTO_INCREMENT FAQ : Frequently-asked questions about auto_increment.
oleh fsakti
FASANA IT | Tutorial Computer
Updated at :
16.35
