Working with MySQL SQL (Microsoft web hosting) 36 TINYINT An 8-bit integer
Wednesday, December 13th, 2006Working with MySQL SQL 36 TINYINT An 8-bit integer represented as one byte. SMALLINT A 16-bit integer represented as 2 bytes. MEDIUMINT A 24-bit integer represented as 3 bytes. INT, INTEGER A 32-bit integer represented as 4 bytes. BIGINT A 64-bit integer represented as 8 bytes. FLOAT A floating-point number; 8-digit precision represented as 4 bytes. DOUBLE A floating-point number; 16-digit precision represented as 8 bytes. DECIMAL(p, s) A fixed-point number, saved as a character string; an arbitrary number of digits represented as 1 byte per digit + 2 bytes overhead. DATE The date in the form 2001-12-31, in the range 1000-01-01 to 9999-12-31, represented as 3 bytes. TIME The time in the form 23:59:59, represented as 3 bytes. DATETIME A combination of DATE and TIME in the form 2002-10-05 23:59:59, represented as 8 bytes. YEAR The year (1900 2155), represented as 1 byte. TIMESTAMP The date and time in the form 20011231325959 for times between 1970 and 2038, represented as 4 bytes. CHAR(n) A character string with a specified length; a maximum of 255 characters represented as n bytes. VARCHAR(n) A character string with variable length; a maximum of n characters (n < 256), represented as 1 byte per character or (actual length) + 1. TINYTEXT A character string with variable length; a maximum of 255 characters, represented as n + 1 bytes. TEXT A character string with variable length; a maximum of 216 - 1 char acters represented as n + 2 bytes. MEDIUMTEXT A character string with variable length; a maximum of 224 - 1 characters, represented as n + 3 bytes. LONGTEXT A character string with variable length, maximum of 232 - 1 characters, represented as n + 4 bytes. TINYBLOB Binary data with variable length; a maximum of 255 bytes. BLOB Binary data with variable length; a maximum of 216 - 1 bytes. MEDIUMBLOB Binary data with variable length; a maximum of 224 - 1 bytes. LONGBLOB Binary data with variable length; a maximum of 232 - 1 bytes.
Hint: This post is supported by Gama web hosting php services