Reject INSERT
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
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
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