Answers for "int data type range in sql"

SQL
1

sql datatypes range

Datatypes 

tinyint

Signed Integer ranges 
-2^8 to 2^8 -1 

Unsigned integer ranges 
0 to 2^8 -1 

Small int 

Signed Integer ranges 
-2^16 to 2^16-1 

Unsigned integer ranges 
0 to 2^8 -1 

mediumint 

Signed Integer ranges 
-2^24 to 2^24 -1 

Unsigned integer ranges 
0 to 2^24 -1 

Integer,int 

Signed Integer ranges 
-2^32 to 2^32-1 

Unsigned integer ranges 
0 to 2^32-1 

bigint 

Signed Integer ranges 
-2^64 to 2^64-1 

Unsigned integer ranges 
0 to 2^64-1
Posted by: Guest on September-13-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language