Answer: MySQL server has many data types that cover many options to save on storage and limit the input from applications however the table below lists the most used types.
Type (length) | Description |
CHAR (length) | Fixed length string size |
VARCHAR (length) | Variable length string (255 max length) |
TEXT | Character string (64k max) |
INT (length) | Integer (number) with limit set by the length, range can be set from -2147483648 to +2147483647 |
INT (length) UNSIGNED | Integer number with limit set by the length, range from 0 to 4294967295 |
BIGINT | Very large integer number, range from -9223372036854775808 to 9223372036854775870 |
BIGINT UNSIGNED | Same as above but range from 0 to 18446744073709557615 |
DATE | Date type as, YYYY-MM-DD |
TIME | Time type as, HH:MM:SS |
DATATIME | Date and time stored together as YYYY-MM-DD HH:MM:SS |
ENUM | Set value like yes or no |
SERIAL | Auto increment of BIGINT UNSIGNED (MySQL 5.0 and above) |
DECIMAL (length, Dec) | Decimal number, like 10.41 |