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. Link to comment https://forums.phpfreaks.com/topic/242606-mysql-strict-mode-question/ 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? Link to comment https://forums.phpfreaks.com/topic/242606-mysql-strict-mode-question/#findComment-1246253 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.