Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - What is the maximum length of int in MySQL database?
What is the maximum length of int in MySQL database?
The maximum length of int is 1 1 bit.

Integer data (all numbers) from -2 3 1(-2 147 483 648) to 2 31(2147 483 647). The storage size is 4 bytes.

If the length of the field int type is not specified when creating the table, the system will generate a field with the length of 1 1 by default. 1 1 is also the maximum length of int type, where the first digit represents the symbol+or-and the last ten digits represent numbers. ?

If the length is specified, the field is actually a field with the length of 1 1, because as long as it is an int type, the system has allocated the length of 1 1 bit. ?

Extended data

Data type of MySQL:

Integer types: BIT, BOOL, TINY INT, SMALL INT, MEDIUM INT, INT, BIG INT.

Floating point type: floating point, double precision, decimal.

String types: CHAR, VARCHAR, TINY TEXT, TEXT, MEDIUM TEXT, LONGTEXT, TINY BLOB, BLOB, MEDIUM BLOB, LONG BLOB.

Date type: date, date time, timestamp, time and year.

Other data types: BINARY, VARBINARY, ENUM, SET, Geometry, Point, MultiPoint, LineString, MultiLineString, Polygon, GeometryCollection, etc.

References:

Baidu encyclopedia -MySQL