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

This article will explain in detail what int types are in MySQL. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Selection of int types

The integer field types include tinyint, smallint, mediumint, int and bigint. The occupied space and storage range are shown in the following figure:

The smaller the storage bytes, the smaller the footprint. Therefore, in line with the principle of minimizing storage, we should try to choose the appropriate integer, here are a few common cases and selection suggestions.

Choose the appropriate type according to the storage area, such as unsigned tinyint for human age (range 0,255, human lifespan will not exceed 255years); sea turtles must be smallint, but if it is the age of the sun, it must be int.

If the stored data is non-negative, it is recommended to use UNSIGNED identification, which can expand the storage range of positive numbers.

Short data use TINYINT or SMALLINT, such as human age, city code.

The field in which the status variable is stored is TINYINT. For example, whether to delete it or not. 0 means not deleted. 1 means it has been deleted.

Primary key column, no negative number. It is recommended to use INT UNSIGNED or BIGINT UNSIGNED; to estimate that the numerical value of the field will exceed 4.2 billion, using the BIGINT type.

The following is a demonstration of the construction table statement:

CREATE TABLE `tb_ int` (`increment_ id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'self-increasing primary key', `stu_ age` tinyint unsigned NOT NULL COMMENT 'student age', `is_ deleted`tinyint unsigned DEFAULT'0' COMMENT'0: not deleted 1: delete', `col1`bigint NOT NULL COMMENT 'bigint field', PRIMARY KEY (`increment_ id`) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='int test table' This is the end of this article on "what are the int types in MySQL?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.