Example Analysis of mysql Integer Type

Most people do not understand the knowledge points of this "mysql integer type instance analysis" article, so the editor summarizes the following contents, detailed contents, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "mysql integer type instance analysis" article.

Description

1. For integer types, MySQL supports specifying the display width (n) after the type name.

2. All integer types have an optional attribute UNSIGNED. You can use this option if you need to save a non-negative value in the field or if the upper limit value is large.

When a column is specified as zerofill, MySQL automatically adds a UNSIGNED attribute to the column.

The integer type also has a unique AUTO_INCREMENT property, indicating that the value of the column is self-increasing.

Example

Create table T1, with id1 and id2 fields, and specify numerical widths of int and int (5) mysql > create table T1 (id1 int,id2 int (5)); mysql > desc T1. The above is about "mysql integer type instance analysis". I believe you all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about it, please pay attention to the industry information channel.