The length of int is not defined by itself, and the system is already defined.
If you define a varchar type of 1, you must never enter ABC.
int (M), Integer (m) 32-bit integer (4 bytes ...)
But it's not that it's okay to say, there is a zerofll in MySQL, when the table is selected 0 fill after the storage will be very different, then if you choose Int (4) You store 12 is stored in the database is 0012, if you fill in 12345, At this point, the specified width is exceeded and stored as is.
< Span style= "Font-family:verdana; line-height:22.5px; font-size:12px; " > similar to int: Tinyint, smallint, Mediumint int and Bigint ( zerofill "
varchar (21845) This is the maximum value of varchar.
VarChar is a variable field, depending on the length of the data you actually store, but with a maximum value, such as varchar (200), you can store up to 200 characters, and if you store 201 characters you will get an error. For example char[3], you can only put the string "123"if you insert the data "1234" the error will be . Varcahr .
similar: CHAR (Length),VARCHAR (Length),TINYINT (Length),SMALLINT (Length),mediumint (Length),INT (Length),BIGINT (Length),FLOAT (Length, decimals),DOUBLE (Length, decimals)and theDECIMAL (Length, decimals).
The field length implications for MySQL are problematic.