Snippets Collections
# In file /etc/my.cnf or /etc/mysql/my.cnf (depending on your operating system), change
# "sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES" or add following

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

# This should take care of the problem. Another way  to change sql_mode directly would be

mysql -u root -p -e „SET GLOBAL sql_mode = ‚NO_ENGINE_SUBSTITUTION‘;“

# But the later option only seems to set the mode temporarely, so I would advise going
# for the my.cnf file.
star

Mon Jun 07 2021 20:53:33 GMT+0000 (UTC) https://www.neovision.ch/wie-sie-den-strict-modus-von-mysql-deaktivieren-konnen/

#mysql #strict #no-default-value

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension