philippryce Posted May 7, 2006 Share Posted May 7, 2006 i need to find out how to change my mysql mode from strict, i have no idea how, any ideas? Quote Link to comment Share on other sites More sharing options...
fenway Posted May 7, 2006 Share Posted May 7, 2006 [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. Quote Link to comment Share on other sites More sharing options...
philippryce Posted May 8, 2006 Author Share Posted May 8, 2006 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 Link to comment Share on other sites More sharing options...
philippryce Posted May 9, 2006 Author Share Posted May 9, 2006 any one? what can i do to change the mode? Quote Link to comment Share on other sites More sharing options...
fenway Posted May 10, 2006 Share Posted May 10, 2006 [!--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. 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.