Mysql Data Types Tutorials

MYSQL Numeric Data Types

This tutorial will help you to understand about “MYSQL Numeric Data Types”.Storage Required For Numeic TypesInteger TypesStorage Required For Numeic TypesData TypeStorage RequiredTINY INT1 byteSMALL INT2 bytesMEDIUM INT3 bytesINT INTEGER4 bytesBIGINT8 bytesFLOAT(p)4 bytesDOUBLE[PRECISION], REAL8 bytesDECIMAL(M,D), NUMERIC(M,D)Various see the below detailsBIT(M)approximately(M+7)/ 8 bytesValues for decimal, numeric,Storage for the integer and fractional parts of each value are determined separately. Each multiple of nine digits requires four bytes and “leftover” digits require some […]... Read More »

MYSQL Date And Time Types

This tutorial will help you to understand about “MYSQL Date and Time Data Types”. Storage Required For Date And Time TypesYEAR TypeTIME TypeDATE, DATETIME AND TIMESTAMP TypeStorage Requirements for Date and Time TypesTIME, DATETIME, TIMESTAMP storage details showed in following table.Data TypeStorage RequiredYEAR1 byteDATE3 byteTIME3 byteDATETIME8 byteTIMESTAMP4 byteYEAR TypeThe default year type is 1 byte type is used to represent year values. It can be declared as YEAR(4) or YEAR(2). […]... Read More »

MYSQL String Data Types

This tutorial will help you to understand about “MYSQL String Types”. It contains the storage required for string types, CHAR type, VARCHAR type, TEXT types, BLOB types, ENUM type and SET TYPE. Storage Required For String TypesCHAR ,VARCHAR TYPETEXT TYPESBLOB TYPESENUM TYPESET TYPEStorage Requirements for String TypesIn the following table, M represents the declared column length in 1.characters for nonbinary string types and 2.bytes for binary string types.L represents the […]... Read More »