{"id":756,"date":"2014-09-17T14:05:31","date_gmt":"2014-09-17T12:05:31","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=756"},"modified":"2014-09-17T14:24:18","modified_gmt":"2014-09-17T12:24:18","slug":"mysql-strict-mode-aktif-mi-pasif-mi","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2014\/09\/mysql-strict-mode-aktif-mi-pasif-mi\/","title":{"rendered":"Mysql Strict Mode Aktif mi , Pasif mi?"},"content":{"rendered":"

Mysql Strict Mode Aktif mi , Pasif mi?<\/p>\n

Bunu mysql sunucunuzda a\u015fa\u011f\u0131daki sorguyu \u00e7al\u0131\u015ft\u0131rarak \u00f6\u011frenebilirsiniz.<\/p>\n

mysql> SELECT @@sql_mode;<\/strong>
\n+——————————————–+
\n| @@sql_mode |
\n+——————————————–+
\n| STRICT_TRANS_TABLES<\/strong>,NO_ENGINE_SUBSTITUTION |
\n+——————————————–+
\n1 row in set (0.00 sec)<\/span><\/p>\n

Yukar\u0131da aktif g\u00f6z\u00fck\u00fcyor.<\/p>\n

Bunu do\u011frulaman\u0131n bir di\u011fer yolu ise a\u015fa\u011f\u0131daki sorgudur.<\/p>\n

mysql> SHOW VARIABLES LIKE ‘%SQL%’;<\/strong>
\nConnection id:\u00a0\u00a0\u00a0 159718988
\nCurrent database: *** NONE ***<\/p>\n

+————————–+——————————————–+
\n| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+————————–+——————————————–+
\n| sql_auto_is_null\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_big_selects\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_big_tables\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_buffer_result\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_log_bin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_log_off\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_low_priority_updates | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_max_join_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 18446744073709551615\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_mode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | STRICT_TRANS_TABLES<\/strong>,NO_ENGINE_SUBSTITUTION |
\n| sql_notes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_quote_show_create\u00a0\u00a0\u00a0 | ON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_safe_updates\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_select_limit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 18446744073709551615\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_slave_skip_counter\u00a0\u00a0 | 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| sql_warnings\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+————————–+——————————————–+
\n15 rows in set (0.01 sec)<\/p>\n

Kapatmak i\u00e7in my.cnf ya da my.ini dosyan\u0131z\u0131 a\u00e7\u0131n\u0131z.<\/p>\n

sql-mode=”STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION”<\/strong><\/p>\n

Yukar\u0131daki gibi bir sat\u0131r g\u00f6r\u00fcyor iseniz bunu a\u015fa\u011f\u0131daki gibi de\u011fi\u015ftirip mysql servisini restart edebilirsiniz.<\/p>\n

sql-mode=”NO_ENGINE_SUBSTITUTION”<\/strong><\/p>\n

E\u011fer b\u00f6yle bir sat\u0131r yok ise kendiniz a\u015fa\u011f\u0131daki sat\u0131r\u0131 ekleyip servisi restart edebilirsiniz.<\/p>\n

sql_mode=NO_ENGINE_SUBSTITUTION<\/strong><\/p>\n

Ayr\u0131ca belirtmekte fayda var ki , e\u011fer strict mode aktif \u00e7al\u0131\u015f\u0131yor iseniz mysql g\u00fcvenli\u011finiz daha \u00fcst seviyededir. Fakat sunucu \u00fczerinde birden \u00e7ok fazla db \u00e7al\u0131\u015ft\u0131r\u0131yor iseniz a\u00e7man\u0131zda bir sak\u0131nca bulunmamaktad\u0131r. Bu modda MySQL\u2019e has bir \u00e7ok \u00f6zellik veritaban\u0131 uyumlulu\u011fu amac\u0131yla devre d\u0131\u015f\u0131 b\u0131rak\u0131l\u0131r. Daha do\u011fru sorgular yazman\u0131z ve bir\u00e7ok farkl\u0131 nedenden dolay\u0131 strict mode tavsiye edilir.<\/p>\n

Ayhan ARDA<\/p>\n

\"Share<\/a>