If I leave length/values field of integer type blank in MySQL how much length of data can it store?

mysql integer datafield
Rolen Koh picture Rolen Koh · Mar 15, 2013 · Viewed 19.5k times · Source

When creating a table we normally make id field of integer type. But if I don't specify any value in length field how much length data will it store?

Answer

Vince K picture Vince K · Jun 28, 2013

I found an explanation elsewhere that says the value/length you specify when creating a numeric column only comes into play if you are using zerofill queries. Example here.

If you stored a value of 5
INT(4) would display 0005
INT(11) would display 00000000005

There's a note in mysql docs that tells of possible trouble when making it too small, so personally I just leave it blank when making a new numeric column.

Related questions

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?

What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL? In what cases should these be used?

Read More
MySQL Error 1264: out of range value for column

As I SET cust_fax in a table in MySQL like this: cust_fax integer(10) NOT NULL, and then I insert value like this: INSERT INTO database values ('3172978990'); but then it say `error 1264` out of value for column …

Read More
What is the biggest ID number that autoincrement can produce in mysql

I have an database that is rapidly filled with data we talk about 10-20k rows per day. What is a limit of an ID with and autoincrement option? If ID is created as INTEGER then I can do max …

Read More