Chiaki Posted July 22, 2011 Share Posted July 22, 2011 Is there any way to turn off strict-mode for certain databases instead of the entire server? I have strict-mode enabled, and I would rather not turn it off for the entire server if possible. I has tried using SET @@session.sql_mode=''; to clear it all together, but it do nothing to change SELECT @@session.sql_mode. It stays the same as global.sql_mode. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 22, 2011 Share Posted July 22, 2011 Yes, you can change most of those variables per-session -- why do you think otherwise? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.