MySQL Signed: Meaning for Integer Data Types

In MySQL, ‘signed’ is a data type modifier used to specify the sign property of integer data types. When an integer column is declared as signed, it can store positive numbers, negative numbers, and zero. The ‘signed’ modifier can be used with integer data types such as INT, INTEGER, SMALLINT, TINYINT, MEDIUMINT, BIGINT, etc. ‘signed’ is the default sign property, so if not specified as signed or unsigned, the integer data type will be considered as having a signed property. Example of usage of the ‘signed’ modifier:

CREATE TABLE example (
    id INT signed,
    age TINYINT signed
);