My MYSQL learning experience (1): simple grammar MYSQL display width of integer data types can specify the display width, while SQLSERVER not create a table CREATE TABLE tb_emp (id BIGINT (1)) id field 2012 Cheap Nike Air Jordan 1 High Heels For Sale Black White Red data Women Air Jordan 4 type BIGINT ( 1), noting that the latter figure 1, which shows the data type specified display width, specify the number of values that can be displayed in numbers. For example, suppose declare Nike Air Max 2014 Men a field of type INT YEAR INT (4) The statement specified data fields in the year generally show only four digit width. In SQLSERVER is being given in the CREATE TABLE abc (id INT (11)) Message 2716, Level 16, State 1, Line 1 The first one column, parameters or variables: int data 2014 Air Jordan 13 (XIII) Retro type can not specify the column width. Display width and data type of the range is irrelevant. Digit number Nike shoes online indicates the maximum possible 180-159222 Nike LeBron 7 VII Soldier Grey Yellow Running Shoes width is specified MYSQL show, there will be a space filled if you Women Air Jordan 6 insert a value greater Women Air Jordan 5 than the width of the display, as long as the value does not exceed the range of the integer type, the median value when the value is still Air Jordan Women Nike Shoes Global less than Nike Air Force one the specified width It can Air Jordan Others be inserted, and can be displayed. For Nike Air Max 2014 Women example, insert a numerical field to year 19999, when using select query time, MYSQL display will be complete with a five digit 19999, instead Nike Shoes of four-digit value if you do not specify a display width, for each MYSQL type specify the default width value tips: display width for display only, and can not limit the range and space, for example: INT (3) will occupy 4 bytes of storage space, and the Air Jordan Fusion maximum allowed will not be 999, but the maximum allowed integer INT. If wrong place, welcome Paizhuan o (∩_∩) omy MYSQL learning experience (2): Data Type Width