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

This article is about how to use integers in MySQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Integer types of MySQL data types

When doing data types, the range of choices is as small as possible to meet the needs. The smaller the scope, the less resources.

Mysql > create table stu (- > stuid tinyint->); Query OK, 0 rows affected (0.00 sec)

Unsigned integers unsigned unsigned integers have no negative numbers, unsigned integers are twice as large as integers.

Mysql > create table stu1 (- > stuid tinyint unsigned->)

The integer supports the display width, which is the minimum number of display digits. For example, int (11) indicates that the integer is at least 11 bits, and if there are not enough bits, fill it with 0. The display width does not work by default and must be combined with zerofill to work. The display width does not determine the size of the integer display, but is preceded by 0 when the number of digits specified is not enough.

Mysql > create table stu2 (- > sutid int (5) zerofill->); thank you for reading! This is the end of this article on "how to use integers 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, you can 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.