MySQL Data Types : MySql « Database « Perl

1. Perl
2. Database
3. MySql

MySQL Data Types

   
Data Type   Description

TINYINT        between 0 and 255 if UNSIGNED clause is applied; else the range is between -128 and 127.
SMALLINT       between 0 and 65535 (UNSIGNED) or -32768 and 32767.
MEDIUM INT     0 to 16777215 with UNSIGNED clause or -8388608 and 8388607.
INT UNSIGNED   between 0 and 4294967295 or -2147683648 and 2147683647.
BIGINT         Huge numbers (-9223372036854775808 to 9223372036854775807).
FLOAT          Floating point numbers (single precision).
DOUBLE         Floating point numbers (double precision).
DECIMAL        Floating point numbers represented as strings.

   
    
    
  

Related examples in the same category