Comments on: sql_mode: a suggestion https://shlomi-noach.github.io/blog/mysql/sql_mode-a-suggestion Blog by Shlomi Noach Sun, 11 Jan 2009 19:00:37 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Roland Bouman https://shlomi-noach.github.io/blog/mysql/sql_mode-a-suggestion/comment-page-1#comment-286 Sun, 11 Jan 2009 19:00:37 +0000 https://shlomi-noach.github.io/blog/?p=505#comment-286 “May I offer my suggestion, then, that future MySQL installations come with a strict sql_mode. ”

On windows, they do. The typical Next/Next/Finish installation procedure leaves you with this setting:

# Set the SQL mode to strict
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

STRICT_TRANS_TABLES is “a strict sql_mode”. If you do the “Detailed Configuration” procedure you are prompted for it, and you can *uncheck* strict mode (it is on by default and explicitly disrecommended to disable it, see: http://farm4.static.flickr.com/3081/3187938357_257ec2bdc3_o.png)

What always blew my mind is how different things are on Linux. That said I can’t say it has posed much of a problem to me because once you update your configuration to reflect your preferences, you keep on reusing that for subsequent installations.

regards,

Roland.

]]>