How to handle "data truncated for column 'x' at row y" in sql?

Example:

INSERT INTO users (age) VALUES ("twenty");

This message indicates that the data provided doesn’t fit the data type of the column.

Solution:

-- Ensure the data type of the input matches the column’s data type
INSERT INTO users (age) VALUES (20);