在mysql中设置全局sql_mode [英] setting global sql_mode in mysql

问题描述

我正在尝试在mysql中设置sql_mode，但是会引发错误.

I am trying to set sql_mode in mysql but it throws an error.

命令:

set global sql_mode='NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLE','NO_AUTO_CREATE_USER','NO_ENGINE_SUBSTITUTION'

这不是设置多种模式的正确方法吗? 设置会话和全局模式的优点是什么?哪个是优先的? 我有不同的用户试图用不同的UNC值更新数据库，并插入od将会话模式设置为"NO_BACKSLASH_ESCAPES"，尽管为此我可以使用一种通用的模式.这有道理吗?

Is this not the proper way to set multiple modes? What are the advantages of setting session and global modes? which is preffered? I have different users trying to update the database with different UNC values and insted od setting the session mode to 'NO_BACKSLASH_ESCAPES', I though it would make sense to et a gloabl mode for this. Does this make sense?

请让我知道.

谢谢.

推荐答案

我解决了.

正确的模式是:

set global sql_mode="NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

这篇关于在mysql中设置全局sql_mode的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！