On Fri, Mar 28, 2008 at 3:46 PM, obed <obed.listas@stripped> wrote:
> Hi all, i'm not trying to make trouble or bother someone with this
> information, I'm a mysql user and I love it, I just wanna know your
> point of view about it.
When you're talking about using Perl, you are right: it's hard to
notice warnings. Only in new versions of Perl do the warnings become
available via DBD::mysql, and they don't do anything -- you have to
check explicitly for warnings. Changing them to errors with SQL_MODE
is a good idea, but that doesn't change every warning to an error
You don't have to restart the server to make strict mode take effect.
Set the variable globally:
mysql> set global sql_mode = 'STRICT_ALL_TABLES';
Any new connections to the server will now be in strict mode.