4 ms·
1. Yes, applications can set sql_mode themselves at the session level. An admin cannot prevent this. http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.ht
by AaronBBrown 14y ago
1. Yes, applications can set sql_mode themselves at the session level. An admin cannot prevent this. http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html
- einhverfr 14y agoSo, what good is setting a sensible default as a DBA if the dev guys can override it? I mean it's fine if you only allow one app to write to your db, but once you have more than one, the fact that the option to ignore invalid data even exists ought to make one very nervous if the data stored is worth anything.
- AaronBBrown 14y agoA dev can only override it for their session, not at the global level.