Shulou(Shulou.com)06/02 Report--

Editor to share with you what kind of data type smallint refers to, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Smallint is an exact numerical data type whose precision remains unchanged after the arithmetic operation. It requires 2 bytes of storage and the syntax is [[UNSIGNED] SMALLINT].

One of the data types.

Function: requires 2 bytes of stored integers.

Syntax:

[UNSIGNED] SMALLINT

SMALLINT data type is an exact numerical data type, and its precision does not change after arithmetic operation. It requires 2 bytes of storage.

Signed SMALLINT values range from-2 ^ 15 (2 ^ 15 represents the 15th power of 2) to 2 ^ 15-1, that is,-32768 to 32767.

Unsigned SMALLINT values range from 0 to 2 ^ 16-1, that is, 0 to 65535. INT is 4 bytes of data with a value range of-2 ^ 31-2 ^ 31, so taking into account the most big data range, the smallint type is preferred.

The above is all the content of the article "what data type does smallint refer to". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.