The differences between int and integer in mysql are: different types, different default values and different storage.

First, the types are different.

1, int: In mysql, the data type of int is the basic data type, which is the unpacking of integer.

2.integer: In mysql, the data type of integer is the reference data type, which is the packaging of int.

Second, the default values are different.

1, int: when the field type is set to int type, the default value of the field is 0.

2. Integer: when the field type is set to integer type, the default value of the field is empty.

Third, storage is different.

1 and int: int are objects that directly store numerical values.

2.integer:integer needs to instantiate an object, which is actually to generate an address where a pointer points to the object.