{"id":18326,"date":"2017-07-11T19:47:09","date_gmt":"2017-07-11T18:47:09","guid":{"rendered":"https:\/\/gofilemaker.de\/?post_type=encyclopedia&#038;p=18326"},"modified":"2022-04-26T13:52:23","modified_gmt":"2022-04-26T12:52:23","slug":"sql","status":"publish","type":"encyclopedia","link":"https:\/\/gofilemaker.de\/tr\/soezluek\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">\u0130\u00e7indekiler tablosu<\/p><ul class=\"toc_list\"><li><a href=\"#Was_ist_SQL_und_wofur_wird_SQL_verwendet\">SQL nedir ve ne i\u00e7in kullan\u0131l\u0131r?<\/a><\/li><li><a href=\"#Beispiele_von_SQL-Befehlen_zur_Datenauswahl\">Veri se\u00e7imi i\u00e7in SQL komutlar\u0131na \u00f6rnekler<\/a><\/li><li><a href=\"#FileMaker_und_SQL\">FileMaker ve SQL<\/a><ul><li><a href=\"#Beispiel_fur_eine_SQL-Abfrage_im_FileMaker_Formeleditor\">FileMaker form\u00fcl d\u00fczenleyicisinde SQL sorgusu \u00f6rne\u011fi<\/a><\/li><\/ul><\/li><\/ul><\/div>\n<h2><span id=\"Was_ist_SQL_und_wofur_wird_SQL_verwendet\">SQL nedir ve ne i\u00e7in kullan\u0131l\u0131r?<\/span><\/h2>\n<p>SQL (Structured Query Language), veritabanlar\u0131 olu\u015fturmak ve d\u00fczenlemek ve veritabanlar\u0131 i\u00e7indeki mevcut veri k\u00fcmelerini sorgulamak i\u00e7in kullan\u0131labilen bir veritaban\u0131 dilidir. Veritaban\u0131 dili nispeten basit bir yap\u0131ya sahiptir ve \u0130ngilizce konu\u015fma diline dayanmaktad\u0131r. Bir SQL sorgusu bir veritaban\u0131 sunucusuna g\u00f6nderilirse, sorgudaki t\u00fcm komutlar s\u0131rayla i\u015flenir.<!--more--><\/p>\n<h2><span id=\"Beispiele_von_SQL-Befehlen_zur_Datenauswahl\">Veri se\u00e7imi i\u00e7in SQL komutlar\u0131na \u00f6rnekler<\/span><\/h2>\n<p><strong>SELECT \"Name\" FROM \"Customers\" WHERE \"Customer_ID\"='K00001\u2032<\/strong>\u00a0- Bu komut, \"Customers\" tablosundan \"K00001\" m\u00fc\u015fteri numaras\u0131na sahip m\u00fc\u015fterinin ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p><strong>SELECT \"Ad\", \"E-posta\" FROM \"M\u00fc\u015fteriler\"<\/strong>\u00a0- Bu komut, \"Customers\" tablosundaki t\u00fcm m\u00fc\u015fteri veri kay\u0131tlar\u0131n\u0131n ad\u0131n\u0131 ve e-posta adresini d\u00f6nd\u00fcr\u00fcr. Her veri kayd\u0131 bir sat\u0131r beslemesi ile ayr\u0131l\u0131r.<\/p>\n<p>SQL arac\u0131l\u0131\u011f\u0131yla se\u00e7ilen veriler her zaman e\u015fle\u015fen kriterlere sahip t\u00fcm veri kay\u0131tlar\u0131n\u0131 i\u00e7erir. Dolay\u0131s\u0131yla, ilk \u00f6rnekte \"K00001\" m\u00fc\u015fteri kimli\u011fine sahip iki m\u00fc\u015fteri varsa, SQL komutu sat\u0131r beslemesiyle ayr\u0131lm\u0131\u015f iki veri kayd\u0131 da d\u00f6nd\u00fcr\u00fcr. FileMaker'a bak\u0131n: \u0130lgili kay\u0131tlar i\u00e7in FileMaker her zaman ilgili tablodan yaln\u0131zca ilk kayd\u0131 g\u00f6r\u00fcnt\u00fcler. Birden fazla veri kayd\u0131 bir b\u00f6l\u00fcm arac\u0131l\u0131\u011f\u0131yla g\u00f6r\u00fcnt\u00fclenmelidir. SQL'de, benzersiz veri kay\u0131tlar\u0131 \"DISTINCT\" eklentisi ile se\u00e7ilebilir:<\/p>\n<p><strong>SELECT DISTINCT \"EMail\" FROM \"Addresses\" WHERE \"Customer_ID\"='K00001\u2032<\/strong>\u00a0- \"Adresler\" ilgili tablosunda bu de\u011fere sahip birden fazla m\u00fc\u015fteri kimli\u011fi olsa bile, m\u00fc\u015fteri kimli\u011fi \"K00001\" olan ilk ilgili veri kayd\u0131n\u0131n e-posta adresini d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p>Yer tutucular SQL'de de kullan\u0131labilir:<\/p>\n<p><strong>SELECT * FROM \"Customers\" WHERE \"Customer_ID\"='K00001\u2032<\/strong>\u00a0- M\u00fc\u015fteri kimli\u011fi \"K00001\" de\u011ferini i\u00e7eriyorsa \"Customers\" tablosundaki t\u00fcm alanlar\u0131n de\u011ferlerini d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h2><span id=\"FileMaker_und_SQL\">FileMaker ve SQL<\/span><\/h2>\n<p>FileMaker 12'den beri veriler \"SQLAusf\u00fchren ()\" komutu ile se\u00e7ilebilmektedir. Bu komut sonraki FileMaker s\u00fcr\u00fcmlerinde s\u00fcrekli olarak geni\u015fletilmi\u015f ve geli\u015ftirilmi\u015ftir. FileMaker'da SQL sorgular\u0131 olu\u015ftururken dikkat edilmesi gereken birka\u00e7 \u00f6zellik vard\u0131r. \u0130lk olarak, SQL sorgusundaki her alan ad\u0131 ters virg\u00fcl (in\u00e7 karakteri \") i\u00e7ine al\u0131nmal\u0131d\u0131r. Hedef alan\u0131 bir say\u0131 alan\u0131 olan alan de\u011ferleri \u00e7evreleyen herhangi bir karakter i\u00e7ermemelidir; hedef alan\u0131 bir metin alan\u0131 olan alan de\u011ferleri ters virg\u00fclle \u00e7evrelenmelidir. Ayr\u0131ca, form\u00fcl d\u00fczenleyicide bir SQL sorgusu olu\u015ftururken FileMaker'a \u00f6zg\u00fc kurallara uyulmal\u0131d\u0131r. FileMaker form\u00fcl d\u00fczenleyicisinde ters virg\u00fcl olu\u015fturulacaksa, ters virg\u00fcl\u00fcn metin dizesinin sonu olarak alg\u0131lanmamas\u0131 i\u00e7in metin dizesi i\u00e7inde her zaman ters e\u011fik \u00e7izgi ( \\ ) ile \u00f6ncelenmelidir.<\/p>\n<h3><span id=\"Beispiel_fur_eine_SQL-Abfrage_im_FileMaker_Formeleditor\">FileMaker form\u00fcl d\u00fczenleyicisinde SQL sorgusu \u00f6rne\u011fi<\/span><\/h3>\n<pre><strong>SQL \u00c7al\u0131\u015ft\u0131r<\/strong> (\"SELECT \\\"isim\\\" FROM \\\"m\u00fc\u015fteriler\\\" WHERE \\\"Customer_ID\\\"='\" &amp; $kunden_id &amp; \"'\"; \"\"; \"\")<\/pre>\n<p>Bu \u00f6rnek, basit bir SQL sorgusu ile \"SQLAusf\u00fchren\" komutunun tamam\u0131n\u0131 g\u00f6stermektedir. T\u00fcm alan adlar\u0131 ters virg\u00fcl i\u00e7ine al\u0131nm\u0131\u015ft\u0131r ve her birinin \u00f6n\u00fcnde metin dizesi i\u00e7inde bir ters e\u011fik \u00e7izgi vard\u0131r. Bu \u00f6rnekteki m\u00fc\u015fteri kimli\u011fi bir metin dizesi oldu\u011fundan, $kunden_id de\u011fi\u015fkenindeki kar\u015f\u0131l\u0131k gelen de\u011fer ters virg\u00fcl i\u00e7ine al\u0131nm\u0131\u015ft\u0131r.<\/p>\n<p>FileMaker'da, \"SQL \u00c7al\u0131\u015ft\u0131r\" komutu, de\u011ferleri belirtmek i\u00e7in bir form\u00fcl d\u00fczenleyicisi sa\u011flayan t\u00fcm i\u015flevlerde \u00e7al\u0131\u015ft\u0131r\u0131labilir. Bu, komutun form\u00fcl alanlar\u0131nda veya hesaplanan de\u011ferlere sahip alanlarda ya da kod d\u00fczenleyicisinde \"De\u011fi\u015fken ayarla\" veya \"Alan de\u011feri ayarla\" komutlar\u0131yla kullan\u0131labilece\u011fi anlam\u0131na gelir.<\/p>\n<p>FileMaker, FileMaker'da hangi SQL komutlar\u0131n\u0131n kullan\u0131labilece\u011fini <a href=\"https:\/\/fmhelp.filemaker.com\/docs\/15\/de\/fm15_sql_reference.pdf\" target=\"_blank\" rel=\"noopener\"><strong>FileMaker SQL Referans K\u0131lavuzu<\/strong><\/a>\u00a0(PDF) \u00f6zetlenmi\u015ftir.<\/p>","protected":false},"excerpt":{"rendered":"<p>Was ist SQL und wof\u00fcr wird SQL verwendet? SQL (Structured Query Language) ist eine Datenbanksprache, mit der Datenbanken erstellt und bearbeitet sowie existierende Datenbest\u00e4nde innerhalb von Datenbanken abgefragt werden k\u00f6nnen. Die Datenbanksprache ist verh\u00e4ltnism\u00e4\u00dfig einfach aufgebaut und lehnt sich an englische Umgangssprache an. Wird eine SQL-Abfrage an einen Datenbankserver gesendet, werden alle in der Abfrage [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":35066,"template":"","class_list":["post-18326","encyclopedia","type-encyclopedia","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/encyclopedia\/18326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/encyclopedia"}],"about":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/types\/encyclopedia"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/users\/187"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/encyclopedia\/18326\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/media\/35066"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/media?parent=18326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}