Mysql Strict Mode Aktif mi , Pasif mi?

<p>Mysql Strict Mode Aktif mi &comma; Pasif mi&quest;<&sol;p>&NewLine;<p>Bunu mysql sunucunuzda a&scedil;a&gbreve;&inodot;daki sorguyu çal&inodot;&scedil;t&inodot;rarak ö&gbreve;renebilirsiniz&period;<&sol;p>&NewLine;<p><span class&equals;"mediumtext">mysql&gt&semi; <strong>SELECT &commat;&commat;sql&lowbar;mode&semi;<&sol;strong><br &sol;>&NewLine;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;<br &sol;>&NewLine;&vert; &commat;&commat;sql&lowbar;mode &vert;<br &sol;>&NewLine;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;<br &sol;>&NewLine;&vert; <strong>STRICT&lowbar;TRANS&lowbar;TABLES<&sol;strong>&comma;NO&lowbar;ENGINE&lowbar;SUBSTITUTION &vert;<br &sol;>&NewLine;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;<br &sol;>&NewLine;1 row in set &lpar;0&period;00 sec&rpar;<&sol;span><&sol;p>&NewLine;<p>Yukar&inodot;da aktif gözüküyor&period;<&sol;p>&NewLine;<p>Bunu do&gbreve;rulaman&inodot;n bir di&gbreve;er yolu ise a&scedil;a&gbreve;&inodot;daki sorgudur&period;<&sol;p>&NewLine;<p>mysql&gt&semi; <strong>SHOW VARIABLES LIKE &&num;8216&semi;&percnt;SQL&percnt;&&num;8217&semi;&semi;<&sol;strong><br &sol;>&NewLine;Connection id&colon;    159718988<br &sol;>&NewLine;Current database&colon; &ast;&ast;&ast; NONE &ast;&ast;&ast;<&sol;p>&NewLine;<p>&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;<br &sol;>&NewLine;&vert; Variable&lowbar;name            &vert; Value                                      &vert;<br &sol;>&NewLine;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;<br &sol;>&NewLine;&vert; sql&lowbar;auto&lowbar;is&lowbar;null         &vert; OFF                                        &vert;<br &sol;>&NewLine;&vert; sql&lowbar;big&lowbar;selects          &vert; ON                                         &vert;<br &sol;>&NewLine;&vert; sql&lowbar;big&lowbar;tables           &vert; OFF                                        &vert;<br &sol;>&NewLine;&vert; sql&lowbar;buffer&lowbar;result        &vert; OFF                                        &vert;<br &sol;>&NewLine;&vert; sql&lowbar;log&lowbar;bin              &vert; ON                                         &vert;<br &sol;>&NewLine;&vert; sql&lowbar;log&lowbar;off              &vert; OFF                                        &vert;<br &sol;>&NewLine;&vert; sql&lowbar;low&lowbar;priority&lowbar;updates &vert; OFF                                        &vert;<br &sol;>&NewLine;&vert; sql&lowbar;max&lowbar;join&lowbar;size        &vert; 18446744073709551615                       &vert;<br &sol;>&NewLine;&vert; sql&lowbar;mode                 &vert; <strong>STRICT&lowbar;TRANS&lowbar;TABLES<&sol;strong>&comma;NO&lowbar;ENGINE&lowbar;SUBSTITUTION &vert;<br &sol;>&NewLine;&vert; sql&lowbar;notes                &vert; ON                                         &vert;<br &sol;>&NewLine;&vert; sql&lowbar;quote&lowbar;show&lowbar;create    &vert; ON                                         &vert;<br &sol;>&NewLine;&vert; sql&lowbar;safe&lowbar;updates         &vert; OFF                                        &vert;<br &sol;>&NewLine;&vert; sql&lowbar;select&lowbar;limit         &vert; 18446744073709551615                       &vert;<br &sol;>&NewLine;&vert; sql&lowbar;slave&lowbar;skip&lowbar;counter   &vert; 0                                          &vert;<br &sol;>&NewLine;&vert; sql&lowbar;warnings             &vert; OFF                                        &vert;<br &sol;>&NewLine;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8212&semi;&&num;8211&semi;&plus;<br &sol;>&NewLine;15 rows in set &lpar;0&period;01 sec&rpar;<&sol;p>&NewLine;<p>Kapatmak için my&period;cnf ya da my&period;ini dosyan&inodot;z&inodot; aç&inodot;n&inodot;z&period;<&sol;p>&NewLine;<p><strong>sql-mode&equals;&&num;8221&semi;STRICT&lowbar;TRANS&lowbar;TABLES&comma;NO&lowbar;ENGINE&lowbar;SUBSTITUTION&&num;8221&semi;<&sol;strong><&sol;p>&NewLine;<p>Yukar&inodot;daki gibi bir sat&inodot;r görüyor iseniz bunu a&scedil;a&gbreve;&inodot;daki gibi de&gbreve;i&scedil;tirip mysql servisini restart edebilirsiniz&period;<&sol;p>&NewLine;<p><strong>sql-mode&equals;&&num;8221&semi;NO&lowbar;ENGINE&lowbar;SUBSTITUTION&&num;8221&semi;<&sol;strong><&sol;p>&NewLine;<p>E&gbreve;er böyle bir sat&inodot;r yok ise kendiniz a&scedil;a&gbreve;&inodot;daki sat&inodot;r&inodot; ekleyip servisi restart edebilirsiniz&period;<&sol;p>&NewLine;<p><strong>sql&lowbar;mode&equals;NO&lowbar;ENGINE&lowbar;SUBSTITUTION<&sol;strong><&sol;p>&NewLine;<p>Ayr&inodot;ca belirtmekte fayda var ki &comma; e&gbreve;er strict mode aktif çal&inodot;&scedil;&inodot;yor iseniz mysql güvenli&gbreve;iniz daha üst seviyededir&period; Fakat sunucu üzerinde birden çok fazla db çal&inodot;&scedil;t&inodot;r&inodot;yor iseniz açman&inodot;zda bir sak&inodot;nca bulunmamaktad&inodot;r&period; Bu modda MySQL’e has bir çok özellik veritaban&inodot; uyumlulu&gbreve;u amac&inodot;yla devre d&inodot;&scedil;&inodot; b&inodot;rak&inodot;l&inodot;r&period; Daha do&gbreve;ru sorgular yazman&inodot;z ve birçok farkl&inodot; nedenden dolay&inodot; strict mode tavsiye edilir&period;<&sol;p>&NewLine;<p>Ayhan ARDA<&sol;p>&NewLine;&NewLine;