MySQL Mode

[philippryce]

i need to find out how to change my mysql mode from strict, i have no idea how, any ideas?

[fenway]

[a href=\"http://dev.mysql.com/doc/mysql/en/server-sql-mode.html\" target=\"_blank\"]This refman page[/a] has all the details you need.

[philippryce]

i've tryed that and dont understand most of it, the select doesnt work even on root login and the set doesnt work ether.
any help/way to do it other than using querys?

[philippryce]

any one? what can i do to change the mode?

[fenway]

[!--quoteo(post=372449:date=May 8 2006, 05:53 PM:name=philip pryce)--][div class=\'quotetop\']QUOTE(philip pryce @ May 8 2006, 05:53 PM) [snapback]372449[/snapback][/div][div class=\'quotemain\'][!--quotec--]
i've tryed that and dont understand most of it, the select doesnt work even on root login and the set doesnt work ether.
any help/way to do it other than using querys?
[/quote]
I don't know what to tell you -- the select can't not work in MySQL 5, or even 4.1 for that matter. You can _always_ set the session modes, though you can, in principle, add a "sql-mode" line to your my.cnf file, though I haven't ever tried.