{"id":314,"date":"2025-02-21T10:31:43","date_gmt":"2025-02-21T08:31:43","guid":{"rendered":"https:\/\/com47276.wordpress.com\/?page_id=314"},"modified":"2025-11-13T13:21:08","modified_gmt":"2025-11-13T13:21:08","slug":"sql-keel-harjutus-auto-tabeli-loomine","status":"publish","type":"page","link":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/","title":{"rendered":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine."},"content":{"rendered":"\n

SQL keel ja Xampp. Harjutus. Auto tabeli loomine.<\/strong><\/h2>\n\n\n\n

SQL<\/strong><\/p>\n\n\n\n

Loo autode tabel, kus iga\u00fche kohta on kirjas mark, registrinumber ja tootmisaasta ning registripiirkond. M\u00f5tle, mis v\u00e4li vajab primaar v\u00f5ti :<\/p>\n\n\n

\ncreate table autod(\nMark varchar(50),\nRegNr varchar(10) primary key,\nAasta int,\nRegPiirk int);\n<\/pre><\/div>\n\n\n
Andmete lisamine tabelisse<\/p>\n\n\n
\ninsert into autod(Mark, RegNr, Aasta, RegPiirk)\nvalues \n('Audi', '123 ABC', 2000, 1),\n('Ford', '777 AAA', 1988, 2),\n('Ford', 'FIN 772', 2002, 1),\n('Nissan', '111 CCC', 2006, 1),\n('Toyota', '128 HGT', 2003, 1),\n('VAZ', '544 CCH', 1960, 2);\nselect * from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
genereeri veel 20  autod mockaroo abil:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda<\/p>\n\n\n
\nselect Aasta, Mark\nfrom autod\norder by Aasta DESC;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–V\u00e4ljasta k\u00f5ik erinevad margid (kasuta DISTINCT)<\/p>\n\n\n
\nselect distinct Mark\nfrom autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid<\/p>\n\n\n
\nselect Aasta, RegNr\nfrom autod\nwhere Aasta<1993;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras<\/p>\n\n\n
\nselect Aasta, Mark\nfrom autod\nwhere Aasta<1993\norder by Mark;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN)<\/p>\n\n\n
\nselect MIN(Aasta) 'k\u00f5ige varasem'\nfrom autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK)<\/p>\n\n\n
\nUpdate autod set RegNr='333 KKK'\nWhere RegNr='FIN 772';\nselect Mark, RegNr from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–Kustuta auto id-ga 4<\/p>\n\n\n
\nDelete from autod Where RegNr='#809afe';\nselect * from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
— Lisa uus masin nimekirja. Vaata tabeli sisu.<\/p>\n\n\n
\ninsert into autod(Mark, RegNr, Aasta, RegPiirk)\nvalues ('Nissan', '555 NNN', 2007, 2)\nselect * from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–n\u00e4idake mulle 5 uusimat automarki.<\/p>\n\n\n
\ncreate procedure autod1\nas\nBegin\nselect top 5 Mark, Aasta\nfrom autod\norder by Aasta desc;\nend;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
–n\u00e4ita masina kaubam\u00e4rke, mis algavad t\u00e4hega A<\/p>\n\n\n
\ncreate procedure autod2\nas\nbegin\nselect Mark\nfrom autod\nwhere Mark like 'A%';\nend;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
–automargid, mis sisaldavad a ja aastat (1999; 2005)<\/p>\n\n\n
\ncreate procedure autod3\nas\nbegin\nselect Mark, Aasta\nfrom autod\nwhere (Aasta between 1999 and 2005) and Mark like '%a%';\nend;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\n\n\n\n
XAMPP<\/strong><\/p>\n\n\n\n
Loo autode tabel, kus iga\u00fche kohta on kirjas mark, registrinumber ja tootmisaasta ning registripiirkond. M\u00f5tle, mis v\u00e4li vajab primaar v\u00f5ti :<\/p>\n\n\n
\ncreate table autod(\nMark varchar(50),\nRegNr varchar(10) primary key,\nAasta int,\nRegPiirk int);\n<\/pre><\/div>\n\n\n
———————————————————————————-<\/p>\n\n\n\n
Andmete lisamine tabelisse<\/p>\n\n\n
\ninsert into autod(Mark, RegNr, Aasta, RegPiirk)\nvalues \n('Audi', '123 ABC', 2000, 1),\n('Ford', '777 AAA', 1988, 2),\n('Ford', 'FIN 772', 2002, 1),\n('Nissan', '111 CCC', 2006, 1),\n('Toyota', '128 HGT', 2003, 1),\n('VAZ', '544 CCH', 1960, 2);\nselect * from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
genereeri veel 20  autod mockaroo abil:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda<\/em><\/p>\n\n\n
\nselect Aasta, Mark\nfrom autod\norder by Aasta DESC;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
–V\u00e4ljasta k\u00f5ik erinevad margid (kasuta DISTINCT)<\/p>\n\n\n
\nselect distinct Mark\nfrom autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
\u2014V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid<\/em><\/p>\n\n\n
\nselect Aasta, RegNr\nfrom autod\nwhere Aasta<1993;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
\u2014V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras<\/em><\/p>\n\n\n
\nselect Aasta, Mark\nfrom autod\nwhere Aasta<1993\norder by Mark;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
——————————————————————————-<\/p>\n\n\n\n
\u2014V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN)<\/em><\/p>\n\n\n
\nselect MIN(Aasta) 'k\u00f5ige varasem'\nfrom autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
\u2014Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK)<\/em><\/p>\n\n\n
\nUpdate autod set RegNr='333 KKK'\nWhere RegNr='#03fadf';\nselect Mark, RegNr from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
\u2014Kustuta auto id-ga 4<\/em><\/p>\n\n\n
\n\t\nDelete from autod Where RegNr='#20b158';\nselect * from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
\u2014 Lisa uus masin nimekirja. Vaata tabeli sisu.<\/em><\/p>\n\n\n
\ninsert into autod(Mark, RegNr, Aasta, RegPiirk)\nvalues ('Nissan', '555 NNN', 2007, 2)\nselect * from autod;\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
———————————————————————————-<\/p>\n\n\n\n
\u2014n\u00e4idake mulle 5 uusimat automarki.<\/em><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u2014n\u00e4ita masina kaubam\u00e4rke, mis algavad t\u00e4hega A<\/em><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
\u2014automargid, mis sisaldavad a ja aastat (1999; 2005)<\/em><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
SQL keel ja Xampp. Harjutus. Auto tabeli loomine. SQL Loo autode tabel, kus iga\u00fche kohta on kirjas mark, registrinumber ja […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-314","page","type-page","status-publish","hentry"],"yoast_head":"\nSQL keel ja Xampp. Harjutus. Auto tabeli loomine. - Oleksandra Ryshniak Portfolio<\/title>\n<meta name=\"description\" content=\"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. See \u00fclesanne on seotud t\u00f6\u00f6ga auto tabeliga ja teiste \u00fclesannetega.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. - Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"og:description\" content=\"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. See \u00fclesanne on seotud t\u00f6\u00f6ga auto tabeliga ja teiste \u00fclesannetega.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/\" \/>\n<meta property=\"og:site_name\" content=\"Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T13:21:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/02\/image-47.png\" \/>\n\t<meta property=\"og:image:width\" content=\"245\" \/>\n\t<meta property=\"og:image:height\" content=\"141\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/\",\"name\":\"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. - Oleksandra Ryshniak Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-47.png?w=245\",\"datePublished\":\"2025-02-21T08:31:43+00:00\",\"dateModified\":\"2025-11-13T13:21:08+00:00\",\"description\":\"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. See \u00fclesanne on seotud t\u00f6\u00f6ga auto tabeliga ja teiste \u00fclesannetega.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-47.png\",\"contentUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-47.png\",\"width\":245,\"height\":141},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/sql-keel-harjutus-auto-tabeli-loomine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL keel ja Xampp. Harjutus. Auto tabeli loomine.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\",\"name\":\"Oleksandra Ryshniak Portfolio\",\"description\":\"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. - Oleksandra Ryshniak Portfolio","description":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. See \u00fclesanne on seotud t\u00f6\u00f6ga auto tabeliga ja teiste \u00fclesannetega.","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:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/","og_locale":"et_EE","og_type":"article","og_title":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. - Oleksandra Ryshniak Portfolio","og_description":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. See \u00fclesanne on seotud t\u00f6\u00f6ga auto tabeliga ja teiste \u00fclesannetega.","og_url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/","og_site_name":"Oleksandra Ryshniak Portfolio","article_modified_time":"2025-11-13T13:21:08+00:00","og_image":[{"width":245,"height":141,"url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/02\/image-47.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/","name":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. - Oleksandra Ryshniak Portfolio","isPartOf":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/#primaryimage"},"image":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/#primaryimage"},"thumbnailUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/02\/image-47.png?w=245","datePublished":"2025-02-21T08:31:43+00:00","dateModified":"2025-11-13T13:21:08+00:00","description":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine. See \u00fclesanne on seotud t\u00f6\u00f6ga auto tabeliga ja teiste \u00fclesannetega.","breadcrumb":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/#primaryimage","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/02\/image-47.png","contentUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/02\/image-47.png","width":245,"height":141},{"@type":"BreadcrumbList","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/sql-keel-harjutus-auto-tabeli-loomine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/"},{"@type":"ListItem","position":2,"name":"SQL keel ja Xampp. Harjutus. Auto tabeli loomine."}]},{"@type":"WebSite","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/","name":"Oleksandra Ryshniak Portfolio","description":"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/comments?post=314"}],"version-history":[{"count":1,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/314\/revisions"}],"predecessor-version":[{"id":1799,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/314\/revisions\/1799"}],"wp:attachment":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/media?parent=314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}