MySQL Data Types

Text Data Types

 CHAR( )      fixed from 0 to 255 characters long 
 VARCHAR( )   variable from 0 to 255 characters long 
 TINYTEXT     maximum length of 255 characters 
 TEXT         maximum length of 65535 characters 
 BLOB         maximum length of 65535 characters 
 MEDIUMTEXT   maximum length of 16777215 characters 
 MEDIUMBLOB   maximum length of 16777215 characters 
 LONGTEXT     maximum length of 4294967295 characters 
 LONGBLOB     maximum length of 4294967295 characters
 

Numeric Data Types

 TINYINT( )     -128 to 127 SIGNED or 0 to 255 UNSIGNED 
 SMALLINT( )    -32768 to 32767 SIGNED or 0 to 65535 UNSIGNED 
 MEDIUMINT( )   -8388608 to 8388607 SIGNED or 0 to 16777215 UNSIGNED 
 INT( )         -2147483648 to 2147483647 SIGNED or 0 to 4294967295 UNSIGNED 
 BIGINT( )      -9223372036854775808 to 9223372036854775807 SIGNED or 0 to 18446744073709551615 UNSIGNED 
 FLOAT          small number with a floating decimal point 
 DOUBLE( , )    large number with a floating decimal point
 DECIMAL( , )   DOUBLE stored as a string , allowing for a fixed decimal point
  

Date Data Types

 DATE      YYYY-MM-DD 
 DATETIME  YYYY-MM-DD HH:MM:SS 
 TIMESTAMP YYYYMMDDHHMMSS 
 TIME      HH:MM:SS
 
 Collapse All    Expand All
Custom Search

MySQL Information and Resources