{"id":3883,"date":"2024-11-14T11:15:11","date_gmt":"2024-11-14T08:15:11","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/sql-delete-sorgulari-kisa-bir-rehber\/"},"modified":"2024-11-14T11:15:11","modified_gmt":"2024-11-14T08:15:11","slug":"sql-delete-sorgulari-kisa-bir-rehber","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sql-delete-sorgulari-kisa-bir-rehber\/","title":{"rendered":"SQL DELETE Sorgular\u0131: K\u0131sa Bir Rehber"},"content":{"rendered":"

SQL DELETE Sorgular\u0131: K\u0131sa Bir Rehber<\/p>\n

Veritaban\u0131 y\u00f6netimi i\u00e7in vazge\u00e7ilmez ara\u00e7lardan biri olan SQL, verilerinizi etkili bir \u015fekilde y\u00f6netmenizi sa\u011flar. Bu makalede, SQL’deki DELETE sorgular\u0131 \u00fczerinde duraca\u011f\u0131z. DELETE sorgular\u0131, veritaban\u0131n\u0131zdaki verileri silmek i\u00e7in kullan\u0131l\u0131r. Bu sorgulamalar\u0131 etkili bir \u015fekilde kullanabilmek, veritaban\u0131n\u0131z\u0131 d\u00fczenli tutmak ve performans\u0131 art\u0131rmak i\u00e7in \u00f6nemlidir.<\/p>\n

Temel DELETE Sorgular\u0131<\/h2>\n

Temel bir DELETE sorgusu, silmek istedi\u011finiz verilerin bulundu\u011fu tablo ad\u0131n\u0131 ve silme ko\u015fullar\u0131n\u0131 belirtir. \u0130\u015fte genel bir DELETE sorgusu yap\u0131s\u0131:<\/p>\n

“`sql
\nDELETE FROM tablo_ad\u0131
\nWHERE ko\u015ful;
\n“`<\/p>\n

\u00d6rne\u011fin, “m\u00fc\u015fteriler” tablosundan “\u015fehir” s\u00fctunu “\u0130stanbul” olan kay\u0131tlar\u0131 silmek i\u00e7in \u015fu sorguyu kullanabilirsiniz:<\/p>\n

“`sql
\nDELETE FROM m\u00fc\u015fteriler
\nWHERE \u015fehir = ‘\u0130stanbul’;
\n“`<\/p>\n

Bu sorguda, “m\u00fc\u015fteriler” tablosundan, “\u015fehir” s\u00fctunu “\u0130stanbul” de\u011ferine e\u015fit olan t\u00fcm kay\u0131tlar silinecektir. “WHERE” ko\u015fulu belirtilmezse, tablodan t\u00fcm kay\u0131tlar silinecektir.<\/p>\n

DELETE Sorgular\u0131nda Kullan\u0131lan Ko\u015fullar<\/h2>\n

DELETE sorgular\u0131nda \u00e7e\u015fitli ko\u015fullar kullanarak silme i\u015flemini daha spesifik hale getirebilirsiniz. \u0130\u015fte baz\u0131 yayg\u0131n ko\u015fullar:<\/p>\n