What is the difference between INT and TINYINT data types?
Answers
Answered by
12
hello mate,
The difference is the amount ofmemory allocated to each integer, and how large a number they each can store. The following example creates a table using the bigint, int, smallint, andtinyint data types. Values are inserted into each column and returned in theSELECT statement.
hope it help you!
The difference is the amount ofmemory allocated to each integer, and how large a number they each can store. The following example creates a table using the bigint, int, smallint, andtinyint data types. Values are inserted into each column and returned in theSELECT statement.
hope it help you!
Answered by
15
The difference between INT and TINYINT data types are following – The TINYINT data types are tiny in nature.
They are of 1 bytes (0 – 255 unsigned). On the other hand, the INT data types represent 4 bytes (0 - 4,294,967,295 unsigned).
Unsigned data types are available in the MySQL while rest data types use signed ranges.
But in case of TINYINT, there is an exception. TINYINT in the SQL server is always unsigned.
Similar questions