INT

INT is a SQL data type in the Data Types category. Standard integer type. Range: -2147483648 to 2147483647 (signed). Use BIGINT for larger values. The syntax is INT[(length)] [UNSIGNED]. It returns integer. A typical example: CREATE TABLE t (id INT AUTO_INCREMENT PRIMARY KEY, age INT UNSIGNED); -- INT: 4 bytes, range -2^31 to 2^31-1 A close relative is VARCHAR(n), which variable-length string with a maximum length. Most common string type. Efficient for varying-length data. A close relative is TEXT, which for large text content (up to 65535 bytes in MySQL). Variants: TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT. A close relative is BOOLEAN / BOOL, which stores TRUE or FALSE values. In MySQL, BOOLEAN is an alias for TINYINT(1) (0=false, 1=true). More about this category: SQL column data types — INT, VARCHAR, TEXT, BOOLEAN, DATE, TIMESTAMP, JSON, DECIMAL. Related Data Types entries: VARCHAR(n), TEXT, BOOLEAN / BOOL, DATE, TIMESTAMP / DATETIME, DECIMAL / NUMERIC, JSON, FLOAT / DOUBLE.