Reject INSERT

The INSERT migh be rejected for various reasons. e.g. Incorrect type of data. Here we try to insert a string "tall" for the height column while our table definition indicated that it is a FLOAT.

INSERT INTO person (name, height, weight, birthday, occupation, gender)
       VALUES ("Foo Bar", "tall", 100, DATE('1971-05-02'), 'sportsman', 'male');

ERROR 1265 (01000): Data truncated for column 'height' at row 1