Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql smallint range

--			SIGNED										  UNSIGNED
--			Min               		Max                   Min Max
TINYINT     -128                    127                   0   255
SMALLINT    -32767                  32767                 0   65535
MEDIUMINT   -8388608                388608                0   16777215
INT         -2147483648             2147483647            0   4294967295
INTEGER     -2147483648             2147483647            0   4294967295
BIGINT      -9223372036854775808    9223372036854775808   0   18446744073709551615
Comment
PREVIOUS NEXT
Code Example
Sql :: t-sql select min from two values 
Sql :: remove spaces sql server 
Sql :: ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 
Sql :: sql update from select 
Sql :: add created and updatedAt fields in mysql 
Sql :: oracle add months to sysdate 
Sql :: check mysql port 
Sql :: Sql creating roles 
Sql :: sql update alias 
Sql :: row number mysql 
Sql :: set auto increment from 1 
Sql :: view linked servers 
Sql :: login to mysql 
Sql :: mysql delete 
Sql :: Database "mem:testdb" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-200] 90149/90149 (Help) 
Sql :: compare date in sql 
Sql :: add user mysql wordpress 
Sql :: sql server date now 
Sql :: alter tablespace add datafile 
Sql :: postgresql insert select 
Sql :: add user mysql 
Sql :: sql like query 
Sql :: sql update table based on another table 
Sql :: delete role postgres 
Sql :: show column from sql server 
Sql :: grant read only privileges postgres user 
Sql :: sql server obtener fecha en formato dd/mm/yyyy 
Sql :: check mysql username and password ubuntu 
Sql :: mysql between date range 
Sql :: install beautifulsoup from terminal 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =