{"id":10292,"date":"2026-11-11T11:15:13","date_gmt":"2026-11-11T08:15:13","guid":{"rendered":"https:\/\/www.yunuskaytan.com\/?p=10292"},"modified":"2026-11-11T11:15:13","modified_gmt":"2026-11-11T08:15:13","slug":"sql-update-ve-delete-komutlari","status":"publish","type":"post","link":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-update-ve-delete-komutlari\/?lang=en","title":{"rendered":"SQL UPDATE ve DELETE Komutlar\u0131"},"content":{"rendered":"<p class=\"wp-block-paragraph\">\u0130li\u015fkisel veritaban\u0131 y\u00f6netim sistemlerinde (RDBMS) veriyi sadece okumak ya da yeni kay\u0131t eklemek tek ba\u015f\u0131na yeterli de\u011fildir. Dinamik sistemlerde kullan\u0131c\u0131 bilgileri g\u00fcncellenir, sipari\u015f durumlar\u0131 de\u011fi\u015fir ya da ge\u00e7erlili\u011fini yitiren verilerin sistemden kald\u0131r\u0131lmas\u0131 gerekir. Bu t\u00fcr veri manip\u00fclasyon i\u015flemlerinde SQL dilinin sundu\u011fu en temel iki ara\u00e7 UPDATE ve DELETE komutlar\u0131d\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Veri Manip\u00fclasyonunun Temeli: DML<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL komutlar\u0131 farkl\u0131 kategorilere ayr\u0131l\u0131r. Tablolar\u0131n yap\u0131s\u0131n\u0131 tan\u0131mlayan DDL (Data Definition Language) komutlar\u0131n\u0131n aksine, do\u011frudan tablonun i\u00e7erisindeki kay\u0131tlarla ilgilenen komut grubuna DML (Data Manipulation Language) ad\u0131 verilir. INSERT komutu ile tabloya yeni sat\u0131rlar eklenirken, bu sat\u0131rlar\u0131n \u00fczerinde de\u011fi\u015fiklik yap\u0131lmas\u0131 ve gerekti\u011finde tamamen kald\u0131r\u0131lmas\u0131 s\u00fcrecini UPDATE ve DELETE y\u00f6netir. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu iki komut do\u011frudan canl\u0131 veriyi hedef ald\u0131\u011f\u0131 i\u00e7in yaz\u0131l\u0131m geli\u015ftiricilerin ve veritaban\u0131 y\u00f6neticilerinin en dikkatli kullanmas\u0131 gereken i\u015flemler aras\u0131nda yer al\u0131r. Hatal\u0131 bir filtreleme sonucunda geri d\u00f6n\u00fc\u015f\u00fc zor veri kay\u0131plar\u0131 ya\u015fanabilir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL UPDATE Komutu ile Kay\u0131tlar\u0131 G\u00fcncelleme<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">UPDATE komutu, bir tablodaki mevcut bir veya birden fazla sat\u0131r\u0131n belirli s\u00fctunlar\u0131ndaki de\u011ferleri de\u011fi\u015ftirmek i\u00e7in kullan\u0131l\u0131r. \u0130\u015flem sonucunda yeni bir sat\u0131r eklenmez, var olan sat\u0131r\u0131n verisi g\u00fcncellenir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE tablo_adi\nSET sutun1 = yeni_deger1, sutun2 = yeni_deger2\nWHERE kosul;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu yap\u0131da UPDATE ifadesinden sonra i\u015flem yap\u0131lacak tablo belirtilir. SET anahtar kelimesi ise hangi s\u00fctuna hangi yeni de\u011ferin atanaca\u011f\u0131n\u0131 tan\u0131mlar. WHERE blo\u011fu, g\u00fcncellemenin yaln\u0131zca hangi kay\u0131tlar \u00fczerinde ge\u00e7erli olaca\u011f\u0131n\u0131 s\u0131n\u0131rlar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Tek Bir De\u011feri G\u00fcncelleme<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki \u00f6rnekte, &#8220;kullanicilar&#8221; tablosunda yer alan ve id de\u011feri 10 olan kullan\u0131c\u0131n\u0131n e-posta adresinin nas\u0131l g\u00fcncellendi\u011fi g\u00f6sterilmektedir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE kullanicilar\nSET eposta = 'ahmet.yeni@example.com'\nWHERE id = 10;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu sorgu \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda veritaban\u0131 motoru yaln\u0131zca id de\u011feri 10 olan sat\u0131r\u0131 bulur ve ilgili sat\u0131r\u0131n eposta s\u00fctununa yeni adresi yazar. Tablodaki di\u011fer hi\u00e7bir kullan\u0131c\u0131 bu i\u015flemden etkilenmez.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Birden Fazla S\u00fctunu G\u00fcncelleme<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Tek bir UPDATE sorgusu ile ayn\u0131 sat\u0131rdaki birden fazla s\u00fctun ayn\u0131 anda de\u011fi\u015ftirilebilir. Bunun i\u00e7in SET blo\u011fundaki s\u00fctun atamalar\u0131 aras\u0131na virg\u00fcl koymak yeterlidir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE kullanicilar\nSET durum = 'aktif', son_giris_tarihi = '2023-10-25'\nWHERE id = 10;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00f6rnekte, ayn\u0131 kullan\u0131c\u0131n\u0131n hem hesap durumu hem de son oturum a\u00e7ma tarihi tek bir ad\u0131mda g\u00fcncellenmi\u015ftir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL DELETE Komutu ile Kay\u0131t Silme<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">DELETE komutu, tablodaki belirli sat\u0131rlar\u0131 tamamen kald\u0131rmak i\u00e7in kullan\u0131l\u0131r. Bu i\u015flem sat\u0131r baz\u0131nda ger\u00e7ekle\u015fir; yani belirli bir s\u00fctundaki h\u00fccreyi de\u011fil, t\u00fcm kayd\u0131 tablodan yok eder.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Temel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM tablo_adi\nWHERE kosul;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">DELETE FROM ifadesinin ard\u0131ndan tablonun ad\u0131 yaz\u0131l\u0131r ve hemen ard\u0131ndan silinecek sat\u0131rlar\u0131 filtrelemek i\u00e7in WHERE ko\u015fulu tan\u0131mlan\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Belirli Bir Kayd\u0131 Silme<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki \u00f6rnek, &#8220;siparisler&#8221; tablosunda yer alan ve siparis_no de\u011feri 504 olan kayd\u0131n silinmesini sa\u011flar:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM siparisler\nWHERE siparis_no = 504;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Veritaban\u0131 motoru siparis_no de\u011feri 504 olan tekil sat\u0131r\u0131 tespit eder ve o sat\u0131r\u0131 tablodan fiziksel olarak kald\u0131r\u0131r.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ko\u015fula Ba\u011fl\u0131 Toplu Silme \u0130\u015flemi<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">DELETE komutu yaln\u0131zca tek bir sat\u0131r\u0131 de\u011fil, verilen mant\u0131ksal ko\u015fulu sa\u011flayan birden fazla sat\u0131r\u0131 da silebilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM log_kayitlari\nWHERE olusturma_tarihi &lt; '2023-01-01';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu komut, 2023 y\u0131l\u0131ndan \u00f6nce olu\u015fturulmu\u015f t\u00fcm sistem kay\u0131tlar\u0131n\u0131 tablodan temizlemek i\u00e7in kullan\u0131l\u0131r. Ko\u015fulu sa\u011flayan sat\u0131r say\u0131s\u0131 ne kadar fazlaysa, silinen veri miktar\u0131 da o oranda artar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kritik Nokta: WHERE Ko\u015fulunun \u00d6nemi<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Hem UPDATE hem de DELETE komutlar\u0131nda WHERE ko\u015fulunun kullan\u0131lmas\u0131 zorunlu de\u011fildir; ancak bu ko\u015ful yaz\u0131lmad\u0131\u011f\u0131nda i\u015flem <strong>t\u00fcm tabloya<\/strong> uygulan\u0131r. Bu durum ili\u015fkisel veritabanlar\u0131nda yap\u0131lan en yayg\u0131n ve tehlikeli hatalar\u0131n ba\u015f\u0131nda gelir.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bir UPDATE sorgusunda WHERE ko\u015fulu unutulursa, tablodaki t\u00fcm sat\u0131rlar\u0131n ilgili s\u00fctunlar\u0131 ayn\u0131 de\u011fere e\u015fitlenir.<\/li>\n\n<li>Bir DELETE sorgusunda WHERE ko\u015fulu unutulursa, tablonun yap\u0131s\u0131 korunur ancak tablodaki t\u00fcm kay\u0131tlar geri d\u00f6n\u00fclmez \u015fekilde silinir.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Bu nedenle do\u011frudan \u00fcretim ortam\u0131nda (production) bu komutlar\u0131 \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce g\u00fcvenlik filtreleri uygulanmal\u0131d\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">G\u00fcvenli G\u00fcncelleme ve Silme \u0130\u00e7in En \u0130yi Uygulamalar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Canl\u0131 sistemlerde veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korumak ve olas\u0131 felaketlerin \u00f6n\u00fcne ge\u00e7mek ad\u0131na geli\u015ftiricilerin izlemesi gereken baz\u0131 temel g\u00fcvenlik al\u0131\u015fkanl\u0131klar\u0131 bulunur:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00d6nce SELECT ile test edin: Bir DELETE ya da UPDATE sorgusu yazmadan \u00f6nce, ayn\u0131 WHERE ko\u015fulunu i\u00e7eren bir SELECT sorgusu \u00e7al\u0131\u015ft\u0131r\u0131n. B\u00f6ylece hangi sat\u0131rlar\u0131n etkilenece\u011fini \u00f6nceden g\u00f6rm\u00fc\u015f olursunuz.<\/li>\n\n<li>Transaction mekanizmas\u0131ndan yararlan\u0131n: \u0130\u015flemleri BEGIN TRANSACTION blo\u011fu i\u00e7inde \u00e7al\u0131\u015ft\u0131r\u0131n. Beklenen sat\u0131r say\u0131s\u0131 d\u0131\u015f\u0131nda bir sonu\u00e7la kar\u015f\u0131la\u015f\u0131rsan\u0131z ROLLBACK komutuyla i\u015flemi geri alabilir, i\u015flem do\u011fruysa COMMIT ile kal\u0131c\u0131 hale getirebilirsiniz.<\/li>\n\n<li>Yaz\u0131l\u0131msal g\u00fcvenlik mekanizmalar\u0131n\u0131 (Soft Delete) tercih edin: Verileri fiziksel olarak tablodan silmek yerine, tabloda &#8220;silindi_mi&#8221; \u015feklinde boolean bir s\u00fctun tutarak ilgili kayd\u0131 pasife \u00e7ekmek modern yaz\u0131l\u0131m mimarilerinde daha g\u00fcvenli bir yakla\u015f\u0131md\u0131r.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Transaction ile G\u00fcvenli \u0130\u015flem \u00d6rne\u011fi<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN TRANSACTION;\n\nUPDATE musteriler\nSET bakiye = bakiye - 100\nWHERE musteri_kodu = 'M102';\n\n-- Etkilenen sat\u0131r say\u0131s\u0131n\u0131 kontrol ettikten sonra:\nCOMMIT;\n-- veya hata tespit edilirse:\n-- ROLLBACK;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu yap\u0131 sayesinde veritaban\u0131nda yap\u0131lan i\u015flem do\u011frudan kal\u0131c\u0131 hale gelmez; kontrol mekanizmas\u0131n\u0131n ard\u0131ndan onaylanabilir veya tamamen iptal edilebilir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6zet ve Sonraki Ad\u0131mlar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL UPDATE ve DELETE komutlar\u0131, veritaban\u0131 kay\u0131tlar\u0131n\u0131n ya\u015fam d\u00f6ng\u00fcs\u00fcn\u00fc y\u00f6neten g\u00fc\u00e7l\u00fc ve vazge\u00e7ilmez ara\u00e7lard\u0131r. UPDATE ile veriler d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcrken, DELETE ile sistemden ar\u0131nd\u0131r\u0131l\u0131r. Her iki komutta da WHERE filtresinin hassasiyetle yap\u0131land\u0131r\u0131lmas\u0131, veri kayb\u0131 riskini ortadan kald\u0131ran en temel kurald\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bir sonraki a\u015famada, ili\u015fkili tablolarda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan yabanc\u0131 anahtar (Foreign Key) k\u0131s\u0131tlamalar\u0131n\u0131 ve bu k\u0131s\u0131tlamalar\u0131n ON DELETE CASCADE gibi parametrelerle UPDATE ve DELETE i\u015flemlerine etkilerini inceleyebilirsiniz.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u0130li\u015fkisel veritabanlar\u0131nda mevcut kay\u0131tlar\u0131 g\u00fcncellemek ve silmek i\u00e7in kullan\u0131lan SQL UPDATE ve DELETE komutlar\u0131n\u0131n yap\u0131s\u0131n\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131n\u0131 inceleyin.<\/p>","protected":false},"author":1,"featured_media":10293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[230],"tags":[254,594,593,589,257],"class_list":["post-10292","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani","tag-sql","tag-sql-delete","tag-sql-update","tag-veri-yonetimi","tag-veritabani"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL UPDATE ve DELETE Komutlar\u0131 - Yunus KAYTAN<\/title>\n<meta name=\"description\" content=\"SQL UPDATE ve DELETE komutlar\u0131n\u0131n kullan\u0131m\u0131, s\u00f6zdizimi, WHERE ko\u015fulunun \u00f6nemi ve veri g\u00fcvenli\u011fi y\u00f6ntemlerini kapsaml\u0131 rehberimizden \u00f6\u011frenin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-update-ve-delete-komutlari\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL UPDATE ve DELETE Komutlar\u0131 - Yunus KAYTAN\" \/>\n<meta property=\"og:description\" content=\"SQL UPDATE ve DELETE komutlar\u0131n\u0131n kullan\u0131m\u0131, s\u00f6zdizimi, WHERE ko\u015fulunun \u00f6nemi ve veri g\u00fcvenli\u011fi y\u00f6ntemlerini kapsaml\u0131 rehberimizden \u00f6\u011frenin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-update-ve-delete-komutlari\/\" \/>\n<meta property=\"og:site_name\" content=\"Yunus KAYTAN\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-11T08:15:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-update-ve-delete-komutlari-kapak.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yunuskaytan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yunuskaytan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/\"},\"author\":{\"name\":\"yunuskaytan\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/person\\\/be66986fb499da83a5685de34f68d15a\"},\"headline\":\"SQL UPDATE ve DELETE Komutlar\u0131\",\"datePublished\":\"2026-11-11T08:15:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/\"},\"wordCount\":1040,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-update-ve-delete-komutlari-kapak.jpg\",\"keywords\":[\"sql\",\"sql delete\",\"sql update\",\"veri y\u00f6netimi\",\"veritaban\u0131\"],\"articleSection\":[\"Veritaban\u0131\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/\",\"name\":\"SQL UPDATE ve DELETE Komutlar\u0131 - Yunus KAYTAN\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-update-ve-delete-komutlari-kapak.jpg\",\"datePublished\":\"2026-11-11T08:15:13+00:00\",\"description\":\"SQL UPDATE ve DELETE komutlar\u0131n\u0131n kullan\u0131m\u0131, s\u00f6zdizimi, WHERE ko\u015fulunun \u00f6nemi ve veri g\u00fcvenli\u011fi y\u00f6ntemlerini kapsaml\u0131 rehberimizden \u00f6\u011frenin.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-update-ve-delete-komutlari-kapak.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-update-ve-delete-komutlari-kapak.jpg\",\"width\":1200,\"height\":630,\"caption\":\"SQL UPDATE ve DELETE Komutlar\u0131\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-update-ve-delete-komutlari\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL UPDATE ve DELETE Komutlar\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#website\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\",\"name\":\"Yunus KAYTAN\",\"description\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yunuskaytan.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\",\"name\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-BILISIM-VE-SIBER-GUVENLIK.png\",\"contentUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-BILISIM-VE-SIBER-GUVENLIK.png\",\"width\":400,\"height\":109,\"caption\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/person\\\/be66986fb499da83a5685de34f68d15a\",\"name\":\"yunuskaytan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"caption\":\"yunuskaytan\"},\"sameAs\":[\"http:\\\/\\\/www.yunuskaytan.com\"],\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/en\\\/yk\\\/author\\\/yunuskaytan\\\/?lang=en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL UPDATE ve DELETE Komutlar\u0131 - Yunus KAYTAN","description":"SQL UPDATE ve DELETE komutlar\u0131n\u0131n kullan\u0131m\u0131, s\u00f6zdizimi, WHERE ko\u015fulunun \u00f6nemi ve veri g\u00fcvenli\u011fi y\u00f6ntemlerini kapsaml\u0131 rehberimizden \u00f6\u011frenin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-update-ve-delete-komutlari\/","og_locale":"en_US","og_type":"article","og_title":"SQL UPDATE ve DELETE Komutlar\u0131 - Yunus KAYTAN","og_description":"SQL UPDATE ve DELETE komutlar\u0131n\u0131n kullan\u0131m\u0131, s\u00f6zdizimi, WHERE ko\u015fulunun \u00f6nemi ve veri g\u00fcvenli\u011fi y\u00f6ntemlerini kapsaml\u0131 rehberimizden \u00f6\u011frenin.","og_url":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-update-ve-delete-komutlari\/","og_site_name":"Yunus KAYTAN","article_published_time":"2026-11-11T08:15:13+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-update-ve-delete-komutlari-kapak.jpg","type":"image\/jpeg"}],"author":"yunuskaytan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yunuskaytan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#article","isPartOf":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/"},"author":{"name":"yunuskaytan","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/person\/be66986fb499da83a5685de34f68d15a"},"headline":"SQL UPDATE ve DELETE Komutlar\u0131","datePublished":"2026-11-11T08:15:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/"},"wordCount":1040,"commentCount":0,"publisher":{"@id":"https:\/\/www.yunuskaytan.com\/#organization"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-update-ve-delete-komutlari-kapak.jpg","keywords":["sql","sql delete","sql update","veri y\u00f6netimi","veritaban\u0131"],"articleSection":["Veritaban\u0131"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/","url":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/","name":"SQL UPDATE ve DELETE Komutlar\u0131 - Yunus KAYTAN","isPartOf":{"@id":"https:\/\/www.yunuskaytan.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#primaryimage"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-update-ve-delete-komutlari-kapak.jpg","datePublished":"2026-11-11T08:15:13+00:00","description":"SQL UPDATE ve DELETE komutlar\u0131n\u0131n kullan\u0131m\u0131, s\u00f6zdizimi, WHERE ko\u015fulunun \u00f6nemi ve veri g\u00fcvenli\u011fi y\u00f6ntemlerini kapsaml\u0131 rehberimizden \u00f6\u011frenin.","breadcrumb":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#primaryimage","url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-update-ve-delete-komutlari-kapak.jpg","contentUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-update-ve-delete-komutlari-kapak.jpg","width":1200,"height":630,"caption":"SQL UPDATE ve DELETE Komutlar\u0131"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-update-ve-delete-komutlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.yunuskaytan.com\/"},{"@type":"ListItem","position":2,"name":"SQL UPDATE ve DELETE Komutlar\u0131"}]},{"@type":"WebSite","@id":"https:\/\/www.yunuskaytan.com\/#website","url":"https:\/\/www.yunuskaytan.com\/","name":"Yunus KAYTAN","description":"Information Technology, Cybersecurity, Cybercrimes and Social Engineering","publisher":{"@id":"https:\/\/www.yunuskaytan.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yunuskaytan.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.yunuskaytan.com\/#organization","name":"Information Technology, Cybersecurity, Cybercrimes and Social Engineering","url":"https:\/\/www.yunuskaytan.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/2021\/07\/cropped-BILISIM-VE-SIBER-GUVENLIK.png","contentUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/2021\/07\/cropped-BILISIM-VE-SIBER-GUVENLIK.png","width":400,"height":109,"caption":"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/person\/be66986fb499da83a5685de34f68d15a","name":"yunuskaytan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","caption":"yunuskaytan"},"sameAs":["http:\/\/www.yunuskaytan.com"],"url":"https:\/\/www.yunuskaytan.com\/en\/yk\/author\/yunuskaytan\/?lang=en"}]}},"_links":{"self":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/comments?post=10292"}],"version-history":[{"count":1,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10292\/revisions"}],"predecessor-version":[{"id":10298,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10292\/revisions\/10298"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/media\/10293"}],"wp:attachment":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/media?parent=10292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/categories?post=10292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/tags?post=10292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}