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

This article shows you what Tinyint in Mysql refers to. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Occupied byte

Both tinyint (1) and tinyint (3) occupy one byte.

At the same time, the range of values is the same.

Zerofill

If the column is set to tinyint (3) zerofill

When the stored data is 2, it will be stored as 002.

Unsigned

If the column is set to unsigned, values range from 0 to 255.

On the contrary, the value range is-128 ~ 127.

Correlation

Tinyint 1 byte

Smallint 2 bytes

3 bytes of Mediumint

4 bytes of Int

Bigint 5 bytes

The number of stored characters represented by varchar (10) 10 (Chinese, English, numbers...)

What does Tinyint in Mysql refer to? have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are 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.