{"id":4165,"date":"2021-11-21T13:01:12","date_gmt":"2021-11-21T12:01:12","guid":{"rendered":"https:\/\/www.zeon.nz\/wordpress\/?p=4165"},"modified":"2025-12-28T16:28:36","modified_gmt":"2025-12-28T15:28:36","slug":"sql-osszefoglalo","status":"publish","type":"post","link":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/","title":{"rendered":"SQL \u00f6sszefoglal\u00f3"},"content":{"rendered":"\n<p>Tananyag: <a href=\"https:\/\/www.w3schools.com\/sql\/default.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\">https:\/\/www.w3schools.com\/sql\/default.asp<\/a><br \/>\nTesztk\u00e9rd\u00e9sek: <a href=\"https:\/\/www.w3schools.com\/sql\/sql_quiz.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\">https:\/\/www.w3schools.com\/sql\/sql_quiz.asp<\/a><\/p>\n<h1>XAMPP haszn\u00e1lata<\/h1>\n<ul>\n<li><code>setup_xampp.bat<\/code>: egyszer kell futtatni, konfigur\u00e1ci\u00f3s \u00e1llom\u00e1nyok be\u00e1ll\u00edt\u00e1sa<\/li>\n<li>ind\u00edt\u00e1s: <code>xampp-control.exe<\/code><\/li>\n<li>Start Apache, MySQL<\/li>\n<li>MySQL melletti Admin gomb -&gt; phpMyAdmin-t nyitja meg<\/li>\n<\/ul>\n<h1>Alapfogalmak<\/h1>\n<ul>\n<li>SQL jelent\u00e9se: Structured Query Language<\/li>\n<li>RDBMS: Relational Database Management System (Rel\u00e1ci\u00f3s adatb\u00e1zis kezel\u0151 rendszer)<\/li>\n<li>Az SQL kis\/nagybet\u0171re nem \u00e9rz\u00e9keny, de szok\u00e1s az utas\u00edt\u00e1sokat, z\u00e1rad\u00e9kokat nagybet\u0171vel, t\u00e1bl\u00e1k, mez\u0151k nev\u00e9t, felt\u00e9teleket kisbet\u0171kkel \u00edrni.<\/li>\n<li>SQL megjegyz\u00e9sek:\n<ul>\n<li>egysoros komment: <code>--<\/code><\/li>\n<li>t\u00f6bbsoros komment: <code>\/* ... *\/<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Adatb\u00e1zis szerkezete:<\/p>\n<ul>\n<li>Database\n<ul>\n<li>Table\n<ul>\n<li>Column (Field)<\/li>\n<li>Row (Record)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1>Legfontosabb SQL utas\u00edt\u00e1sok \u00e9s csoportos\u00edt\u00e1suk<\/h1>\n<h2>DDL (Data Definition Language):<\/h2>\n<ul>\n<li><code>CREATE<\/code>: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers).<\/li>\n<li><code>DROP<\/code>: This command is used to delete objects from the database.<\/li>\n<li><code>ALTER<\/code>: This is used to alter the structure of the database.<\/li>\n<li><code>TRUNCATE<\/code>: This is used to remove all records from a table. (Maga a t\u00e1bla nem t\u00f6rl\u0151dik!)<\/li>\n<\/ul>\n<h2>DML(Data Manipulation Language):<\/h2>\n<ul>\n<li><code>INSERT<\/code>: It is used to insert data into a table.<\/li>\n<li><code>UPDATE<\/code>: It is used to update existing data within a table.<\/li>\n<li><code>DELETE<\/code>: It is used to delete records from a database table.<\/li>\n<li><code>LOCK<\/code>: Table control concurrency.<\/li>\n<\/ul>\n<h2>DQL (Data Query Language):<\/h2>\n<ul>\n<li><code>SELECT<\/code>: It is used to retrieve data from the database.<\/li>\n<\/ul>\n<h2>DCL (Data Control Language):<\/h2>\n<ul>\n<li><code>GRANT<\/code>: This command gives users access privileges to the database.<\/li>\n<li><code>REVOKE<\/code>: This command withdraws the user\u2019s access privileges given by using the <code>GRANT<\/code> command.<\/li>\n<\/ul>\n<h1>Adatb\u00e1zisok kezel\u00e9se<\/h1>\n<p>Adatb\u00e1zis l\u00e9trehoz\u00e1sa:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE DATABASE adatb\u00e1zisn\u00e9v\r\nCHARACTER SET utf8\r\nCOLLATE utf8_hungarian_ci;<\/pre>\n<p>Adatb\u00e1zis t\u00f6rl\u00e9se:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DROP DATABASE adatb\u00e1zisn\u00e9v;<\/pre>\n<h1>T\u00e1bl\u00e1k kezel\u00e9se<\/h1>\n<h2>T\u00e1bla l\u00e9trehoz\u00e1sa<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE TABLE table_name (\r\n    column1 datatype,\r\n    column2 datatype,\r\n    column3 datatype,\r\n    ...\r\n);<\/pre>\n<p>P\u00e9lda:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE TABLE Persons (\r\n    PersonID int,\r\n    LastName varchar(255),\r\n    FirstName varchar(255),\r\n    Address varchar(255),\r\n    City varchar(255)\r\n);<\/pre>\n<h2>T\u00e1bla t\u00f6rl\u00e9se<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DROP TABLE table_name;<\/pre>\n<h2>T\u00e1bla csonkol\u00e1sa (Truncate)<\/h2>\n<p>A <code>TRUNCATE<\/code> utas\u00edt\u00e1sa t\u00f6rli a sorokat a t\u00e1bl\u00e1b\u00f3l, de <strong>nem t\u00f6rli mag\u00e1t a t\u00e1bl\u00e1t<\/strong>!<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">TRUNCATE TABLE table_name;<\/pre>\n<h2>T\u00e1bla mod\u00f3s\u00edt\u00e1sa<\/h2>\n<p>A t\u00e1bl\u00e1k az <code>ALTER TABLE<\/code> utas\u00edt\u00e1ssal m\u00f3dos\u00edthat\u00f3k:<\/p>\n<ul>\n<li>oszlopok hozz\u00e1ad\u00e1sa, m\u00f3dos\u00edt\u00e1sa, t\u00f6rl\u00e9se egy l\u00e9tez\u0151 t\u00e1bl\u00e1ban<\/li>\n<li>k\u00fcl\u00f6nf\u00e9le k\u00e9nyszerek (constraints) hozz\u00e1ad\u00e1sa, t\u00f6rl\u00e9se egy l\u00e9tez\u0151 t\u00e1bl\u00e1ban<\/li>\n<\/ul>\n<h3>SQL Constraints (k\u00e9nyszerek)<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_notnull.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>NOT NULL<\/code><\/a> &#8211; Ensures that a column cannot have a <code>NULL<\/code> value<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_unique.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>UNIQUE<\/code><\/a> &#8211; Ensures that all values in a column are different<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_primarykey.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>PRIMARY KEY<\/code><\/a> &#8211; A combination of a <code>NOT NULL<\/code> and <code>UNIQUE<\/code>. Uniquely identifies each row in a table<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_autoincrement.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>AUTO_INCREMENT<\/code><\/a>: Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table.<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_foreignkey.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>FOREIGN KEY<\/code><\/a> &#8211; Prevents actions that would destroy links between tables<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_check.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>CHECK<\/code><\/a> &#8211; Ensures that the values in a column satisfies a specific condition<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_default.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>DEFAULT<\/code><\/a> &#8211; Sets a default value for a column if no value is specified<\/li>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/sql_create_index.asp\"  target=\"_blank\" rel=\"external nofollow\"   class=\"wp-links-icon\"><code>CREATE INDEX<\/code><\/a> &#8211; Used to create and retrieve data from the database very quickly<\/li>\n<\/ul>\n<h3>T\u00e1bla m\u00f3dos\u00edt\u00e1sa &#8211; Oszlop hozz\u00e1ad\u00e1sa:<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">ALTER TABLE table_name\r\nADD column_name datatype;<\/pre>\n<h3>T\u00e1bla m\u00f3dos\u00edt\u00e1sa &#8211; Oszlop t\u00f6rl\u00e9se:<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">ALTER TABLE table_name\r\nDROP column_name datatype;<\/pre>\n<h3>Els\u0151dleges kulcs (PRIMARY KEY)<\/h3>\n<p>Az els\u0151dleges kulcsot l\u00e9tre lehet hozni:<\/p>\n<ul>\n<li>t\u00e1bla l\u00e9trehoz\u00e1sa sor\u00e1n<\/li>\n<li>t\u00e1bla l\u00e9trehoz\u00e1sa ut\u00e1n<\/li>\n<\/ul>\n<h3>Els\u0151dleges kulcs l\u00e9trehoz\u00e1sa a t\u00e1bla l\u00e9trehoz\u00e1sa sor\u00e1n:<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE TABLE Persons (\r\n    ID int NOT NULL AUTO_INCREMENT,\r\n    LastName varchar(255) NOT NULL,\r\n    FirstName varchar(255),\r\n    Age int,\r\n    PRIMARY KEY (ID)    -- els\u0151dleges kulcs\r\n);<\/pre>\n<p>Els\u0151dleges kulcs elnevez\u00e9se:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE TABLE Persons (\r\n    ID int NOT NULL,\r\n    LastName varchar(255) NOT NULL,\r\n    FirstName varchar(255),\r\n    Age int,\r\n    CONSTRAINT PK_Person PRIMARY KEY (ID)   -- els\u0151dleges kulcs, elnevez\u00e9ssel\r\n);<\/pre>\n<h3>Els\u0151dleges kulcs l\u00e9trehoz\u00e1sa a t\u00e1bla l\u00e9trehoz\u00e1sa UT\u00c1N:<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">ALTER TABLE Persons\r\nADD PRIMARY KEY (ID);<\/pre>\n<p>Elnevez\u00e9ssel:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">ALTER TABLE Persons\r\nADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);<\/pre>\n<h2>Idegen kulcs (FOREIGN KEY)<\/h2>\n<p>Az idegen kulcsot l\u00e9tre lehet hozni:<\/p>\n<ul>\n<li>t\u00e1bla l\u00e9trehoz\u00e1sa sor\u00e1n<\/li>\n<li>t\u00e1bla l\u00e9trehoz\u00e1sa ut\u00e1n<\/li>\n<\/ul>\n<h3>Idegen kulcs l\u00e9trehoz\u00e1sa a t\u00e1bla l\u00e9trehoz\u00e1sa sor\u00e1n:<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE TABLE Orders (\r\n    OrderID int NOT NULL,\r\n    OrderNumber int NOT NULL,\r\n    PersonID int,\r\n    PRIMARY KEY (OrderID),\r\n    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)     --idegen kulcs\r\n);<\/pre>\n<p>Elnevez\u00e9ssel:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">CREATE TABLE Orders (\r\n    OrderID int NOT NULL,\r\n    OrderNumber int NOT NULL,\r\n    PersonID int,\r\n    PRIMARY KEY (OrderID),\r\n    CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)\r\n);<\/pre>\n<h3>Idegen kulcs l\u00e9trehoz\u00e1sa a t\u00e1bla l\u00e9trehoz\u00e1sa UT\u00c1N:<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">ALTER TABLE Orders\r\nADD FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);<\/pre>\n<p>Elnevez\u00e9ssel:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">ALTER TABLE Orders\r\nADD CONSTRAINT FK_PersonOrder FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);<\/pre>\n<h1>Adatok kezel\u00e9se<\/h1>\n<h2>\u00daj sor besz\u00far\u00e1sa t\u00e1bl\u00e1ba<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">INSERT INTO table_name (column1, column2, column3, ...)\r\nVALUES (value1, value2, value3, ...);<\/pre>\n<p>Ha a t\u00e1bla minden mez\u0151j\u00e9be visz\u00fcnk be adatot, akkor nem kell megadni a mez\u0151neveket, viszont nagyon fontos, hogy az adatok ugyanolyan sorrendben legyenek megadva, mint a mez\u0151nevek a t\u00e1bl\u00e1ban.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">INSERT INTO table_name\r\nVALUES (value1, value2, value3, ...);<\/pre>\n<blockquote><p>Megjegyz\u00e9s:<\/p>\n<ul>\n<li>Ha nem adunk meg \u00e9rt\u00e9ket egy mez\u0151nek, akkor az alap\u00e9rtelmezett \u00e9rt\u00e9k (<code>DEFAULT<\/code> k\u00e9nyszer), vagy <code>NULL<\/code> \u00e9rt\u00e9k ker\u00fcl be\u00e1ll\u00edt\u00e1sra<\/li>\n<li>Nem kell megadni \u00e9rt\u00e9ket olyan mez\u0151knek, amelyekre be van \u00e1ll\u00edtva az <code>AUTO_INCREMENT<\/code> k\u00e9nyszer, ezek \u00e9rt\u00e9ke automatikusan gener\u00e1l\u00f3dik (eg\u00e9sz sz\u00e1m)<\/li>\n<\/ul>\n<\/blockquote>\n<h2>Adatsorok m\u00f3dos\u00edt\u00e1sa t\u00e1bl\u00e1ban<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">UPDATE table_name\r\nSET column1 = value1, column2 = value2, ...\r\nWHERE  condition;<\/pre>\n<p>Pl.:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">UPDATE Customers\r\nSET ContactName = 'Alfred Schmidt', City= 'Frankfurt'\r\nWHERE CustomerID = 1;<\/pre>\n<p>A fenti utas\u00edt\u00e1s a nevet \u00e9s a v\u00e1rost m\u00f3dos\u00edtja az 1-es azonos\u00edt\u00f3j\u00fa v\u00e1s\u00e1rl\u00f3 eset\u00e9n.<\/p>\n<blockquote><p>Megjegyz\u00e9s:<br \/>\nVigy\u00e1zat: Nagyon fontos az <code>UPDATE<\/code> utas\u00edt\u00e1s eset\u00e9n, hogy a <code>WHERE<\/code> z\u00e1rad\u00e9k hat\u00e1rozza meg, hogy mely sorokat szeretn\u00e9nk m\u00f3dos\u00edtani. Ha a <code>WHERE<\/code> z\u00e1rad\u00e9kot elhagyjuk, akkor a t\u00e1bla \u00f6sszes sor\u00e1t m\u00f3dos\u00edtja!!!<\/p><\/blockquote>\n<h2>Adatok t\u00f6rl\u00e9se t\u00e1bl\u00e1b\u00f3l<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DELETE FROM table_name\r\nWHERE condition;<\/pre>\n<p>Pl.:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DELETE FROM Customers\r\nWHERE CustomerName='Alfreds Futterkiste';<\/pre>\n<p>Az &#8216;Alfreds Futterkiste&#8217; nev\u0171 v\u00e1s\u00e1rl\u00f3(k) t\u00f6rl\u00e9se a t\u00e1bl\u00e1b\u00f3l.<\/p>\n<blockquote><p>Megjegyz\u00e9s:<br \/>\nAhogy az <code>UPDATE<\/code> eset\u00e9n, \u00fagy a <code>DELETE<\/code>-n\u00e9l is figyelni kell a <code>WHERE<\/code> z\u00e1rad\u00e9kra; elhagy\u00e1sa eset\u00e9n az \u00f6sszes sor t\u00f6rl\u0151dik a t\u00e1bl\u00e1b\u00f3l!!!<\/p><\/blockquote>\n<h1>Lek\u00e9rdez\u00e9sek<\/h1>\n<h2>SELECT utas\u00edt\u00e1s \u00e1ltal\u00e1nos alakja:<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT [DISTINCT] ...\r\nFROM ...\r\nWHERE ...\r\nGROUP BY ...\r\nHAVING ...\r\nORDER BY ...\r\nLIMIT ...<\/pre>\n<h2>Egyszer\u0171, egyt\u00e1bl\u00e1s lek\u00e9rdez\u00e9sek<\/h2>\n<ol>\n<li>Jelen\u00edtsd meg a varos t\u00e1bla \u00f6sszes adat\u00e1t:\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT * FROM varos;<\/pre>\n<\/li>\n<li>Jelen\u00edtsd meg a 20000 f\u0151n\u00e9l nagyobb v\u00e1rosok nev\u00e9t \u00e9s n\u00e9pess\u00e9g\u00e9t, n\u00e9pess\u00e9g szerint cs\u00f6kken\u0151 sorrendben:\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT varos.vnev, varos.nepesseg\r\nFROM varos\r\nWHERE varos.nepesseg &gt; 20000\r\nORDER BY nepesseg DESC;<\/pre>\n<\/li>\n<\/ol>\n<h2>Egyszer\u0171 lek\u00e9rdez\u00e9s, sz\u00e1m\u00edtott mez\u0151<\/h2>\n<p>Jelen\u00edtsd meg a 20000 f\u0151n\u00e9l nagyobb v\u00e1rosok nev\u00e9t \u00e9s n\u00e9ps\u0171r\u0171s\u00e9g\u00e9t, n\u00e9ps\u0171r\u0171s\u00e9g szerint cs\u00f6kken\u0151 sorrendben:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT `varos`.`vnev`, `varos`.`nepesseg` \/ `varos`.`terulet` AS `n\u00e9ps\u0171r\u0171s\u00e9g`\r\nFROM `varos`\r\nWHERE `varos`.`nepesseg` &gt; 20000\r\nORDER BY `n\u00e9ps\u0171r\u0171s\u00e9g` DESC<\/pre>\n<h2>T\u00f6bbt\u00e1bl\u00e1s lek\u00e9rdez\u00e9sek<\/h2>\n<p>Jelen\u00edts\u00fck meg a 20000 f\u0151n\u00e9l nagyobb v\u00e1rosok nev\u00e9t, n\u00e9pess\u00e9g\u00e9t \u00e9s a megy\u00e9t. Az adatokat megye szerint n\u00f6vekv\u0151, azon bel\u00fcl n\u00e9pess\u00e9g szerint cs\u00f6kken\u0151 sorrendbe rendezz\u00fck!<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT varos.vnev, varos.nepesseg, megye.mnev\r\nFROM varos INNER JOIN megye ON varos.megyeid = megye.id\r\nWHERE varos.nepesseg &gt; 20000 AND varos.nepesseg &lt; 30000\r\nORDER BY megye.mnev ASC, varos.nepesseg DESC<\/pre>\n<h2>Egyszer\u0171 lek\u00e9rdez\u00e9s, \u00f6sszes\u00edt\u0151 (aggreg\u00e1tum) f\u00fcggv\u00e9nyekkel<\/h2>\n<p>Aggreg\u00e1tum f\u00fcggv\u00e9nyek:<\/p>\n<ul>\n<li><code>SUM()<\/code><\/li>\n<li><code>AVG()<\/code><\/li>\n<li><code>MIN()<\/code>, <code>MAX()<\/code><\/li>\n<li><code>COUNT()<\/code><\/li>\n<\/ul>\n<p>Sz\u00e1m\u00edtsuk ki az \u00f6sszn\u00e9pess\u00e9get:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT SUM(varos.nepesseg) AS `\u00d6sszn\u00e9pess\u00e9g`\r\nFROM varos<\/pre>\n<h2>Egyszer\u0171 lek\u00e9rdez\u00e9s, \u00f6sszes\u00edt\u0151 (aggreg\u00e1tum) f\u00fcggv\u00e9nyekkel, csoportos\u00edtott mez\u0151vel<\/h2>\n<p>Sz\u00e1m\u00edtsuk ki az \u00f6sszn\u00e9pess\u00e9get megy\u00e9nk\u00e9nt, \u00e9s rendezz\u00fck \u00f6sszn\u00e9pess\u00e9g szerint cs\u00f6kken\u0151be!<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT megye.mnev AS `Megye`, SUM(varos.nepesseg) AS `Megye lakoss\u00e1ga`\r\nFROM varos INNER JOIN megye ON varos.megyeid = megye.id\r\nGROUP BY megye.mnev\r\nORDER BY `Megye lakoss\u00e1ga` DESC<\/pre>\n<h2>WHERE z\u00e1rad\u00e9k<\/h2>\n<ul>\n<li>rel\u00e1ci\u00f3s m\u0171veletek: (<code>&lt;<\/code>, <code>&gt;<\/code>, <code>=<\/code>, <code>&lt;=<\/code>, <code>&gt;=<\/code>, <code>&lt;&gt;<\/code>)<\/li>\n<li>logikai m\u0171veletek: <code>AND<\/code>, <code>OR<\/code>, <code>NOT<\/code><\/li>\n<li><code>BETWEEN ... AND ...<\/code><\/li>\n<li><code>IN(..., ..., ..., ...,)<\/code><\/li>\n<\/ul>\n<h2>Sztringek<\/h2>\n<ul>\n<li><code>''<\/code> k\u00f6z\u00f6tt<\/li>\n<li>helyettes\u00edt\u0151 karakterek:\n<ul>\n<li><code>%<\/code>: b\u00e1rmilyen karakter, tetsz\u0151leges sz\u00e1mban<\/li>\n<li><code>_<\/code>: b\u00e1rmilyen karakter, 1 darab<\/li>\n<\/ul>\n<\/li>\n<li>sztringek \u00f6sszehasonlit\u00e1sa: <code>LIKE<\/code>, <code>NOT LIKE<\/code> vs <code>=<\/code>, <code>&lt;&gt;<\/code><\/li>\n<\/ul>\n<h2>SQL f\u00fcggv\u00e9nyek<\/h2>\n<h3>String f\u00fcggv\u00e9nyek<\/h3>\n<ul>\n<li><code>CONCAT()<\/code> : 2 vagy t\u00f6bb string \u00f6sszef\u0171z\u00e9se<\/li>\n<li><code>LCASE()<\/code>, <code>UCASE()<\/code>: kis- ill. nagybet\u0171ss\u00e9 alak\u00edt\u00e1s<\/li>\n<li><code>LEFT()<\/code>, <code>RIGHT()<\/code>: a string elej\u00e9r\u0151l ill v\u00e9g\u00e9r\u0151l lev\u00e1g egy adott sz\u00e1m\u00fa karaktert<\/li>\n<li><code>LENGTH()<\/code>: string hossza<\/li>\n<li><code>REPLACE()<\/code>: egy sz\u00f6vegr\u00e9szlet helyettes\u00edt\u00e9se egy m\u00e1sik sz\u00f6veggel<\/li>\n<li><code>SUBSTRING()<\/code>: r\u00e9szsztringet ad vissza egy stringb\u0151l<\/li>\n<\/ul>\n<h3>numerikus f\u00fcggv\u00e9nyek:<\/h3>\n<ul>\n<li><code>SIN()<\/code>, <code>COS()<\/code>, <code>TAN()<\/code>, &#8230; : sz\u00f6gf\u00fcggv\u00e9nyek<\/li>\n<li><code>CEIL()<\/code>, <code>CEILING()<\/code>: felfel\u00e9 kerek\u00edt\u00e9s<\/li>\n<li><code>FLOOR()<\/code>: lefel\u00e9 kerek\u00edt\u00e9s<\/li>\n<li><code>ROUND()<\/code>: kerek\u00edt\u00e9s<\/li>\n<li><code>MOD()<\/code>, <code>DIV()<\/code>: marad\u00e9kos oszt\u00e1s, marad\u00e9k k\u00e9pz\u00e9s<\/li>\n<li><code>POW()<\/code>, <code>POWER()<\/code>: hatv\u00e1nyoz\u00e1s<\/li>\n<li><code>SQRT()<\/code>: gy\u00f6kvon\u00e1s<\/li>\n<\/ul>\n<h3>d\u00e1tum f\u00fcggv\u00e9nyek:<\/h3>\n<ul>\n<li>d\u00e1tum \u00e9s id\u0151 form\u00e1tum: <code>'yyyy-mm-dd 00:00:00.000'<\/code><\/li>\n<li><code>NOW()<\/code>: aktu\u00e1lis d\u00e1tum \u00e9s id\u0151<\/li>\n<li><code>YEAR()<\/code>, <code>MONTH()<\/code>, <code>DAY()<\/code>: egy adott d\u00e1tumb\u00f3l \u00e9vet, h\u00f3napot, napot adj\u00e1k vissza<\/li>\n<li><code>HOUR()<\/code>, <code>MINUTE()<\/code>, <code>SECOND()<\/code>: egy adott d\u00e1tumb\u00f3l \u00f3r\u00e1t, percet, mp-t adj\u00e1k vissza<\/li>\n<li><code>WEEK()<\/code>: h\u00e9t sorsz\u00e1ma (0..52)<\/li>\n<li><code>WEEKDAY()<\/code>: h\u00e9t napja, 0-monday, 1-tuesday, &#8230;<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Tananyag: https:\/\/www.w3schools.com\/sql\/default.asp Tesztk\u00e9rd\u00e9sek: https:\/\/www.w3schools.com\/sql\/sql_quiz.asp XAMPP haszn\u00e1lata setup_xampp.bat: egyszer kell futtatni, konfigur\u00e1ci\u00f3s \u00e1llom\u00e1nyok be\u00e1ll\u00edt\u00e1sa ind\u00edt\u00e1s: xampp-control.exe Start Apache, MySQL MySQL melletti [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[89],"tags":[],"class_list":["post-4165","post","type-post","status-publish","format-standard","hentry","category-adatbazis-kezeles"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL \u00f6sszefoglal\u00f3 | SZT2<\/title>\n<meta name=\"description\" content=\"Adatb\u00e1zis-kezel\u00e9s, (My)SQL tananyag \u00f6sszefoglal\u00f3.\" \/>\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.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL \u00f6sszefoglal\u00f3 | SZT2\" \/>\n<meta property=\"og:description\" content=\"Adatb\u00e1zis-kezel\u00e9s, (My)SQL tananyag \u00f6sszefoglal\u00f3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/\" \/>\n<meta property=\"og:site_name\" content=\"SZT2\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-21T12:01:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-28T15:28:36+00:00\" \/>\n<meta name=\"author\" content=\"ZEoN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZEoN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/\"},\"author\":{\"name\":\"ZEoN\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#\\\/schema\\\/person\\\/e4bd2f19be2b1e7fbf3c74374a3c1d56\"},\"headline\":\"SQL \u00f6sszefoglal\u00f3\",\"datePublished\":\"2021-11-21T12:01:12+00:00\",\"dateModified\":\"2025-12-28T15:28:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/\"},\"wordCount\":1234,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#organization\"},\"articleSection\":[\"Adatb\u00e1zis-kezel\u00e9s\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/\",\"url\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/\",\"name\":\"SQL \u00f6sszefoglal\u00f3 | SZT2\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#website\"},\"datePublished\":\"2021-11-21T12:01:12+00:00\",\"dateModified\":\"2025-12-28T15:28:36+00:00\",\"description\":\"Adatb\u00e1zis-kezel\u00e9s, (My)SQL tananyag \u00f6sszefoglal\u00f3.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/adatbazis-kezeles\\\/sql-osszefoglalo\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL \u00f6sszefoglal\u00f3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/\",\"name\":\"SZT2\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#organization\",\"name\":\"SZT2\",\"url\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/banner-20210908.jpg\",\"contentUrl\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/banner-20210908.jpg\",\"width\":1980,\"height\":396,\"caption\":\"SZT2\"},\"image\":{\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.zeon.nz\\\/wordpress\\\/#\\\/schema\\\/person\\\/e4bd2f19be2b1e7fbf3c74374a3c1d56\",\"name\":\"ZEoN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2d33f30762e4650f4db40848e354d9c868d0a0105bb3e00e428ad4859259e2f6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2d33f30762e4650f4db40848e354d9c868d0a0105bb3e00e428ad4859259e2f6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2d33f30762e4650f4db40848e354d9c868d0a0105bb3e00e428ad4859259e2f6?s=96&d=mm&r=g\",\"caption\":\"ZEoN\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL \u00f6sszefoglal\u00f3 | SZT2","description":"Adatb\u00e1zis-kezel\u00e9s, (My)SQL tananyag \u00f6sszefoglal\u00f3.","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.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/","og_locale":"en_US","og_type":"article","og_title":"SQL \u00f6sszefoglal\u00f3 | SZT2","og_description":"Adatb\u00e1zis-kezel\u00e9s, (My)SQL tananyag \u00f6sszefoglal\u00f3.","og_url":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/","og_site_name":"SZT2","article_published_time":"2021-11-21T12:01:12+00:00","article_modified_time":"2025-12-28T15:28:36+00:00","author":"ZEoN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZEoN","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/#article","isPartOf":{"@id":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/"},"author":{"name":"ZEoN","@id":"https:\/\/www.zeon.nz\/wordpress\/#\/schema\/person\/e4bd2f19be2b1e7fbf3c74374a3c1d56"},"headline":"SQL \u00f6sszefoglal\u00f3","datePublished":"2021-11-21T12:01:12+00:00","dateModified":"2025-12-28T15:28:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/"},"wordCount":1234,"commentCount":0,"publisher":{"@id":"https:\/\/www.zeon.nz\/wordpress\/#organization"},"articleSection":["Adatb\u00e1zis-kezel\u00e9s"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/","url":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/","name":"SQL \u00f6sszefoglal\u00f3 | SZT2","isPartOf":{"@id":"https:\/\/www.zeon.nz\/wordpress\/#website"},"datePublished":"2021-11-21T12:01:12+00:00","dateModified":"2025-12-28T15:28:36+00:00","description":"Adatb\u00e1zis-kezel\u00e9s, (My)SQL tananyag \u00f6sszefoglal\u00f3.","breadcrumb":{"@id":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.zeon.nz\/wordpress\/adatbazis-kezeles\/sql-osszefoglalo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.zeon.nz\/wordpress\/"},{"@type":"ListItem","position":2,"name":"SQL \u00f6sszefoglal\u00f3"}]},{"@type":"WebSite","@id":"https:\/\/www.zeon.nz\/wordpress\/#website","url":"https:\/\/www.zeon.nz\/wordpress\/","name":"SZT2","description":"","publisher":{"@id":"https:\/\/www.zeon.nz\/wordpress\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.zeon.nz\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/www.zeon.nz\/wordpress\/#organization","name":"SZT2","url":"https:\/\/www.zeon.nz\/wordpress\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/www.zeon.nz\/wordpress\/#\/schema\/logo\/image\/","url":"https:\/\/www.zeon.nz\/wordpress\/wp-content\/uploads\/2021\/11\/banner-20210908.jpg","contentUrl":"https:\/\/www.zeon.nz\/wordpress\/wp-content\/uploads\/2021\/11\/banner-20210908.jpg","width":1980,"height":396,"caption":"SZT2"},"image":{"@id":"https:\/\/www.zeon.nz\/wordpress\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.zeon.nz\/wordpress\/#\/schema\/person\/e4bd2f19be2b1e7fbf3c74374a3c1d56","name":"ZEoN","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/2d33f30762e4650f4db40848e354d9c868d0a0105bb3e00e428ad4859259e2f6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2d33f30762e4650f4db40848e354d9c868d0a0105bb3e00e428ad4859259e2f6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d33f30762e4650f4db40848e354d9c868d0a0105bb3e00e428ad4859259e2f6?s=96&d=mm&r=g","caption":"ZEoN"}}]}},"_links":{"self":[{"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/posts\/4165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/comments?post=4165"}],"version-history":[{"count":15,"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/posts\/4165\/revisions"}],"predecessor-version":[{"id":4355,"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/posts\/4165\/revisions\/4355"}],"wp:attachment":[{"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/media?parent=4165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/categories?post=4165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeon.nz\/wordpress\/wp-json\/wp\/v2\/tags?post=4165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}