sql - Strict data validation with MySQL -

i working mysql workbench , noticed table accepting pretty values without doing data validation. setting sql_mode "strict_all_tables" solved of problems.

however, when insert floating point value in integer column, value rounded nearest int.

my question is: there way force mysql workbench throw error instead of doing rounding operation?

thanks!

it design dilemma between being friendly , doing mean, or being pain-in-the-a@@ , making work harder.

if such validation valuable, add frontend interface performs sorts of validations, including cross-field , cross-table validation. while you're @ it, helpfully suggest field values correlation historical values, etc.