MySQL: Setting sql_mode permanently
MySQL sql_mode “TRADITIONAL”, a.k.a. “strict mode”, is defined by the MySQL docs as: “give an error instead of a warning” when inserting an incorrect value into a column. Here’s how to ensure that your sql_mode is set to “TRADITIONAL”. First, check your current setting: mysql mysql> SELECT @@GLOBAL.sql_mode; +——————-+ | @@GLOBAL.sql_mode | +——————-+ | | … Read more