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

If you find this site useful and are a book buyer/reader... You can support my site by clicking on one of the Links below to Abe books By doing this, I will receive a small commision on your purchase and making your purchase will not cost you any more money than if you went directly the site yourself! Abe Books sells books at a fraction of the original cost. I have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars including shipping costs Click on applicable icon to find books at Abe Books on ...
MySQL	MySQL & Php

Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. If it is printed they likely have a copy. I have also included a generic link to Abe Books below. Once on their site, you will find that they have a nice, easy to use search engine so to find what you are looking for.