{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"MySQL Rezerv Kelimelerinden Kaynaklanan Hatalardan Ka\u00e7\u0131nma","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"iXQ6ql1Lj0\"><a href=\"https:\/\/fatihsoysal.com\/blog\/mysql-rezerv-kelimelerinden-kaynaklanan-hatalardan-kacinma\/\">MySQL Rezerv Kelimelerinden Kaynaklanan Hatalardan Ka\u00e7\u0131nma<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/mysql-rezerv-kelimelerinden-kaynaklanan-hatalardan-kacinma\/embed\/#?secret=iXQ6ql1Lj0\" width=\"600\" height=\"338\" title=\"&#8220;MySQL Rezerv Kelimelerinden Kaynaklanan Hatalardan Ka\u00e7\u0131nma&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"iXQ6ql1Lj0\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Merhaba! Fatih Soysal olarak, bu yaz\u0131mda MySQL veritaban\u0131 y\u00f6netim sisteminde s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan bir sorunu ele alaca\u011f\u0131z: rezerv kelimeler. Rezerv kelimeler, MySQL'in i\u00e7sel i\u015flevleri i\u00e7in ayr\u0131lm\u0131\u015f olan ve veri taban\u0131 nesneleri (tablolar, s\u00fctunlar vb.) isimlendirmede kullan\u0131lmamas\u0131 gereken \u00f6zel kelimelerdir. Bu kelimeleri yanl\u0131\u015fl\u0131kla kullanmak, beklenmedik hatalara ve sorgu sorunlar\u0131na yol a\u00e7abilir. \u00d6rne\u011fin, \"select\", \"from\", \"where\" gibi kelimeleri tablo veya s\u00fctun isimleri olarak kullanmak ciddi sorunlar yarat\u0131r. Bu nedenle, rezerv kelime kullan\u0131m\u0131ndan kaynaklanan sorunlardan nas\u0131l ka\u00e7\u0131naca\u011f\u0131m\u0131z\u0131 detayl\u0131 bir \u015fekilde inceleyece\u011fiz."}