{"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\/cs\/glosar\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">Obsah<\/p><ul class=\"toc_list\"><li><a href=\"#Was_ist_SQL_und_wofur_wird_SQL_verwendet\">Co je SQL a k \u010demu se pou\u017e\u00edv\u00e1?<\/a><\/li><li><a href=\"#Beispiele_von_SQL-Befehlen_zur_Datenauswahl\">P\u0159\u00edklady p\u0159\u00edkaz\u016f SQL pro v\u00fdb\u011br dat<\/a><\/li><li><a href=\"#FileMaker_und_SQL\">FileMaker a SQL<\/a><ul><li><a href=\"#Beispiel_fur_eine_SQL-Abfrage_im_FileMaker_Formeleditor\">P\u0159\u00edklad dotazu SQL v editoru vzorc\u016f aplikace FileMaker<\/a><\/li><\/ul><\/li><\/ul><\/div>\n<h2><span id=\"Was_ist_SQL_und_wofur_wird_SQL_verwendet\">Co je SQL a k \u010demu se pou\u017e\u00edv\u00e1?<\/span><\/h2>\n<p>SQL (Structured Query Language) je datab\u00e1zov\u00fd jazyk, kter\u00fd lze pou\u017e\u00edt k vytv\u00e1\u0159en\u00ed a \u00faprav\u00e1m datab\u00e1z\u00ed a k dotazov\u00e1n\u00ed na existuj\u00edc\u00ed datov\u00e9 sady v datab\u00e1z\u00edch. Tento datab\u00e1zov\u00fd jazyk m\u00e1 pom\u011brn\u011b jednoduchou strukturu a vych\u00e1z\u00ed z anglick\u00e9ho hovorov\u00e9ho jazyka. Pokud je datab\u00e1zov\u00e9mu serveru odesl\u00e1n dotaz v jazyce SQL, jsou v\u0161echny p\u0159\u00edkazy v dotazu zpracov\u00e1ny postupn\u011b.<!--more--><\/p>\n<h2><span id=\"Beispiele_von_SQL-Befehlen_zur_Datenauswahl\">P\u0159\u00edklady p\u0159\u00edkaz\u016f SQL pro v\u00fdb\u011br dat<\/span><\/h2>\n<p><strong>SELECT \"Name\" FROM \"Customers\" WHERE \"Customer_ID\"='K00001'<\/strong>\u00a0- Tento p\u0159\u00edkaz vr\u00e1t\u00ed jm\u00e9no z\u00e1kazn\u00edka s \u010d\u00edslem \"K00001\" z tabulky \"Z\u00e1kazn\u00edci\".<\/p>\n<p><strong>SELECT \"Name\", \"EMail\" FROM \"Customers\"<\/strong>\u00a0- Tento p\u0159\u00edkaz vr\u00e1t\u00ed jm\u00e9no a e-mailovou adresu v\u0161ech datov\u00fdch z\u00e1znam\u016f o z\u00e1kazn\u00edc\u00edch z tabulky \"Z\u00e1kazn\u00edci\". Ka\u017ed\u00fd datov\u00fd z\u00e1znam je odd\u011blen posuvem \u0159\u00e1dku.<\/p>\n<p>Data vybran\u00e1 pomoc\u00ed SQL obsahuj\u00ed v\u017edy v\u0161echny datov\u00e9 z\u00e1znamy s odpov\u00eddaj\u00edc\u00edmi krit\u00e9rii. Pokud tedy v prvn\u00edm p\u0159\u00edkladu existuj\u00ed dva z\u00e1kazn\u00edci s ID z\u00e1kazn\u00edka \"K00001\", vr\u00e1t\u00ed p\u0159\u00edkaz SQL tak\u00e9 dva datov\u00e9 z\u00e1znamy, kter\u00e9 jsou odd\u011bleny \u0159\u00e1dkov\u00fdm posuvn\u00edkem. Viz FileMaker: U souvisej\u00edc\u00edch z\u00e1znam\u016f FileMaker v\u017edy zobraz\u00ed pouze prvn\u00ed z\u00e1znam ze souvisej\u00edc\u00ed tabulky. V\u00edce datov\u00fdch z\u00e1znam\u016f mus\u00ed b\u00fdt zobrazeno prost\u0159ednictv\u00edm odd\u00edlu. V jazyce SQL lze jedine\u010dn\u00e9 datov\u00e9 z\u00e1znamy vybrat pomoc\u00ed dopl\u0148ku \"DISTINCT\":<\/p>\n<p><strong>SELECT DISTINCT \"EMail\" FROM \"Addresses\" WHERE \"Customer_ID\"='K00001'<\/strong>\u00a0- Vr\u00e1t\u00ed e-mailovou adresu prvn\u00edho souvisej\u00edc\u00edho datov\u00e9ho z\u00e1znamu, jeho\u017e ID z\u00e1kazn\u00edka je \"K00001\", i kdy\u017e v souvisej\u00edc\u00ed tabulce \"Adresy\" existuje n\u011bkolik ID z\u00e1kazn\u00edk\u016f s touto hodnotou.<\/p>\n<p>Z\u00e1stupn\u00e9 znaky lze pou\u017e\u00edt tak\u00e9 v jazyce SQL:<\/p>\n<p><strong>SELECT * FROM \"Customers\" WHERE \"Customer_ID\"='K00001'<\/strong>\u00a0- Vr\u00e1t\u00ed hodnoty v\u0161ech pol\u00ed z tabulky \"Z\u00e1kazn\u00edci\", pokud ID z\u00e1kazn\u00edka obsahuje hodnotu \"K00001\".<\/p>\n<h2><span id=\"FileMaker_und_SQL\">FileMaker a SQL<\/span><\/h2>\n<p>Od verze FileMaker 12 lze data vyb\u00edrat pomoc\u00ed p\u0159\u00edkazu \"SQLAusf\u00fchren ()\". Tento p\u0159\u00edkaz byl v n\u00e1sleduj\u00edc\u00edch verz\u00edch FileMakeru pr\u016fb\u011b\u017en\u011b roz\u0161i\u0159ov\u00e1n a vylep\u0161ov\u00e1n. P\u0159i vytv\u00e1\u0159en\u00ed dotaz\u016f SQL v aplikaci FileMaker je t\u0159eba upozornit na n\u011bkolik zvl\u00e1\u0161tnost\u00ed. Za prv\u00e9, ka\u017ed\u00fd n\u00e1zev pole v dotazu SQL by m\u011bl b\u00fdt uzav\u0159en v uvozovk\u00e1ch (palcov\u00fd znak \"). Hodnoty pol\u00ed, jejich\u017e c\u00edlov\u00fdm polem je \u010d\u00edseln\u00e9 pole, nesm\u00ed obsahovat \u017e\u00e1dn\u00e9 okoln\u00ed znaky; hodnoty pol\u00ed, jejich\u017e c\u00edlov\u00fdm polem je textov\u00e9 pole, mus\u00ed b\u00fdt obklopeny uvozovkami. P\u0159i vytv\u00e1\u0159en\u00ed dotazu SQL v editoru vzorc\u016f je nav\u00edc nutn\u00e9 dodr\u017eovat pravidla specifick\u00e1 pro FileMaker. M\u00e1-li b\u00fdt v editoru vzorc\u016f FileMaker vytvo\u0159ena obr\u00e1cen\u00e1 \u010d\u00e1rka, mus\u00ed j\u00ed v textov\u00e9m \u0159et\u011bzci v\u017edy p\u0159edch\u00e1zet zp\u011btn\u00e9 lom\u00edtko ( \\ ), aby obr\u00e1cen\u00e1 \u010d\u00e1rka nebyla rozpozn\u00e1na jako konec textov\u00e9ho \u0159et\u011bzce.<\/p>\n<h3><span id=\"Beispiel_fur_eine_SQL-Abfrage_im_FileMaker_Formeleditor\">P\u0159\u00edklad dotazu SQL v editoru vzorc\u016f aplikace FileMaker<\/span><\/h3>\n<pre><strong>Spustit SQL<\/strong> (\"SELECT \\\"name\\\" FROM \\\"z\u00e1kazn\u00edci\\\" WHERE \\\"Customer_ID\\\"='\" &amp; $kunden_id &amp; \"'\"; \"\"; \"\")<\/pre>\n<p>Tento p\u0159\u00edklad ukazuje kompletn\u00ed p\u0159\u00edkaz \"SQLAusf\u00fchren\" s jednoduch\u00fdm dotazem SQL. V\u0161echny n\u00e1zvy pol\u00ed jsou uzav\u0159eny v uvozovk\u00e1ch a p\u0159ed ka\u017ed\u00fdm z nich je v textov\u00e9m \u0159et\u011bzci zp\u011btn\u00e9 lom\u00edtko. Proto\u017ee ID z\u00e1kazn\u00edka v tomto p\u0159\u00edkladu je textov\u00fd \u0159et\u011bzec, je odpov\u00eddaj\u00edc\u00ed hodnota z prom\u011bnn\u00e9 $kunden_id uzav\u0159ena v uvozovk\u00e1ch.<\/p>\n<p>V aplikaci FileMaker lze p\u0159\u00edkaz \"Execute SQL\" spustit ve v\u0161ech funkc\u00edch, kter\u00e9 poskytuj\u00ed editor vzorc\u016f pro zad\u00e1v\u00e1n\u00ed hodnot. To znamen\u00e1, \u017ee p\u0159\u00edkaz lze pou\u017e\u00edt v pol\u00edch vzorc\u016f nebo v pol\u00edch s vypo\u010dten\u00fdmi hodnotami nebo v editoru skript\u016f pomoc\u00ed p\u0159\u00edkaz\u016f \"Nastavit prom\u011bnnou\" nebo \"Nastavit hodnotu pole\".<\/p>\n<p>FileMaker popsal, kter\u00e9 p\u0159\u00edkazy SQL jsou ve FileMakeru k dispozici v <a href=\"https:\/\/fmhelp.filemaker.com\/docs\/15\/de\/fm15_sql_reference.pdf\" target=\"_blank\" rel=\"noopener\"><strong>Referen\u010dn\u00ed p\u0159\u00edru\u010dka FileMaker SQL<\/strong><\/a>\u00a0(PDF) shrnuto.<\/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\/cs\/wp-json\/wp\/v2\/encyclopedia\/18326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/encyclopedia"}],"about":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/types\/encyclopedia"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/users\/187"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/encyclopedia\/18326\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media\/35066"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media?parent=18326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}