INT

Difficulty

Last Reviewed

Notes

Reference Link

Reviewed

Status

Tags

(show you how to use integer data type.)

In MySQL, the INT data type is used to store whole numbers, which are numbers without a fractional component. This includes both positive and negative integers as well as zero. Examples of integers include 1, 100, 4, -10. Non-integer examples are 1.2 or 5/3, which cannot be stored in an INT column.

‣

MySQL Integer Types

‣

Signed and Unsigned Integers

‣

Characteristics of MySQL Integer Types

‣

Default Signed Integer Example

‣

Using INT for a column example

‣

INT

MySQL Integer Types

Signed and Unsigned Integers

Characteristics of MySQL Integer Types

Default Signed Integer Example

Using INT for a column example

Using INT UNSIGNED example