The display bit width of MySQL----data

Problem: The columns in the MySQL table can define the bit width that it displays, so does the definition of bit width affect the range of data values?

Test:

1. Define a table for testing

CREATE table t (x int,y int (2), Z int (2) zerofill);

2. Insert the data for testing

INSERT into t (x, y, z) VALUES (9,9,9); #插入一些在范围内的数据.

INSERT into t (x, y, z) VALUES (100,100,100); #插入超出范围的数据.

3. Test:

select * from T;

　　　　

Conclusion:

It is useful to display the width of a bit or to fill it by 0, but it does not work if the data exceeds that range.

The display bit width of MySQL----data