Mysql "length/values" field!


When you create table in phpMyadmin, you have to define the data types and length/values etc fields for the table… I am bit confused about length/values field in case of string and character it will be the maximum number of characters but what does it mean for numeric data types as int and float? as field length of int (1) will accept max number “2147483647”


The number is display width (to which shorter values are padded in left; longer values are left as they are), not constraint.