Home >> SQL >> Difference between Tinyint and smallint in SQL

Difference between Tinyint and smallint in SQL

TINYINT                       SMALLINT

1 Byte                            2Bytes

4 digits                           5 digits

-128 to 127 signed         -32,768 to 32,767 signed

0 to 255 unsigned          0 to 65,535 unsigned

Post Your Comment

Next Questions
Difference between enum and set
Difference between signed and unsigned
Operators
Arithmetic Operators
Comparison Operators
Logical Operators
What is key
What is super key
What is candidate key
What is primary key
What is unique key
What is foreign key
What is join
What is cross join
What is natural join
What is outer join
What is self join
What is aggregate function
COUNT(*) aggregate function
AVG() aggregate function
MIN() aggregate function
MAX() aggregate function
SUM() aggregate function
STDED() aggregate function
CONCAT() function

Copyright ©2022 coderraj.com. All Rights Reserved.