{"id":1153,"date":"2020-01-01T11:59:54","date_gmt":"2020-01-01T06:29:54","guid":{"rendered":"https:\/\/www.guru99.com\/mysql-tutorial.html"},"modified":"2026-05-09T12:37:07","modified_gmt":"2026-05-09T07:07:07","slug":"mysql-tutorial","status":"publish","type":"post","link":"https:\/\/www.guru99.com\/mysql-tutorial.html","title":{"rendered":"MySQL Tutorial for Beginners","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<!-- [element-157882] -->\n<style>.responsive-guru99-rectangle-above1{width:300px;height:100px}\n.responsive-guru99-rectangle-above1 {\n  margin-right: 6px;\n }\n \n.desktop-only {\n  display: none;\n}\n.mobile-only {\n  display: block;\n}\n@media(min-width: 768px) {\n  .responsive-guru99-rectangle-above1 {\n   float: left;\n   width: 309px !important;\n   height: 250px !important;\n  }\n  \n  .desktop-only {\n    display: block;\n  }\n  \n  .mobile-only {\n    display: none;\n  }\n}\n@media(max-width: 768px) {\n  .responsive-guru99-rectangle-above1 {\n   width: 345px !important;\n   height: 100px !important;\n   padding-bottom: 15px;\n  }\n<\/style>\n\n\n\n<div style=\"float:left;padding-right:6px;\" class=\"responsive-guru99-rectangle-above1 desktop-only\">\n  <a href=\"https:\/\/guru99.live\/ojvv97\" rel=\"sponsored noopener\" target=\"_blank\" onclick=\"gtag(&#039;event&#039;, &#039;mysql_tutorials&#039;, { &#039;event_category&#039;: &#039;MySQL Tutorial&#039;, &#039;event_action&#039;:&#039;Click&#039;,&#039;event_label&#039;:&#039;ManageEngine v1&#039; });\">\n    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.guru99.com\/images\/300x250-manageengine-sql-ads.gif\" alt=\"ManageEngine Application Manager\" width=\"300\" height=\"250\">\n  <\/a>\n<\/div>\n<div style=\"float:left;padding-right:6px;\" class=\"responsive-guru99-rectangle-above1 mobile-only\" id=\"guru99_top_banner\">\n  <a href=\"https:\/\/guru99.live\/474ise\" rel=\"sponsored noopener\" target=\"_blank\" onclick=\"gtag(&#039;event&#039;, &#039;mysql_tutorials&#039;, { &#039;event_category&#039;: &#039;MySQL Tutorial&#039;, &#039;event_action&#039;:&#039;Click&#039;,&#039;event_label&#039;:&#039;ManageEngine v2&#039; });\">\n    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.guru99.com\/images\/300x100-manageengine-sql-ads.gif\" alt=\"ManageEngine Application Manager\" width=\"300\" height=\"100\">\n  <\/a>\n<\/div>\n<!-- [\/element-157882] -->\n<h2>MySQL Tutorial Summary<\/h2>\n<hr>\n<p>MySQL is the most popular open-source database management system. This MySQL tutorial for beginners covers all concepts like MySQL basics, normalization, and MySQL Workbench installation. Later in this MySQL tutorial, Commands like Select, Insert, Group By and advance topics like Wildcards &amp; Functions are covered.<\/p>\n\n\n<script type=\"text\/javascript\">!function(e,t){(e=t.createElement(\"script\")).src=\"https:\/\/cdn.convertbox.com\/convertbox\/js\/embed.js\",e.id=\"app-convertbox-script\",e.async=true,e.dataset.uuid=\"37ed7c7c-8ffa-41a9-9264-26aac657f888\",document.getElementsByTagName(\"head\")[0].appendChild(e)}(window,document);<\/script>\n\n\n<h3>What should I know?<\/h3>\n<hr>\n<p>This MySQL for beginners tutorial is designed for both experts and beginners having no prior Database experience.<\/p>\n<h2>MySQL Syllabus<\/h2>\n<h3>Database Fundamentals<\/h3>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/introduction-to-database-sql.html\" data-lasso-id=\"185598\">What is a Database? <\/a><\/strong> \u2014 Definition, Meaning, Types, Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/introduction-to-mysql-workbench.html\" data-lasso-id=\"185599\">MySQL Workbench Tutorial for Beginners<\/a><\/strong> \u2014 How to Install &amp; Use<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Database Design<\/h3>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/database-design.html\" data-lasso-id=\"185600\">Database Design in DBMS Tutorial<\/a><\/strong> \u2014 Learn Data Modeling<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/database-normalization.html\" data-lasso-id=\"185601\">What is Normalization in SQL?<\/a><\/strong> \u2014 1NF, 2NF, 3NF, BCNF Database (DBMS) Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 3<\/strong><\/td>\n<td><strong><a href=\"\/er-modeling.html\" data-lasso-id=\"185602\">What is ER Modeling?<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>SQL Basics<\/h3>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/what-is-sql.html\" data-lasso-id=\"185603\">What is SQL?<\/a><\/strong> \u2014 Learn SQL Basics, SQL Full Form &amp; How to Use<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/how-to-create-a-database.html\" data-lasso-id=\"185604\">MySQL Create Table<\/a><\/strong> \u2014 How to Create Database in MySQL<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 3<\/strong><\/td>\n<td><strong><a href=\"\/select-statement.html\" data-lasso-id=\"185605\">MySQL SELECT Statement<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 4<\/strong><\/td>\n<td><strong><a href=\"\/where-clause.html\" data-lasso-id=\"185606\">MySQL WHERE Clause<\/a><\/strong> \u2014 AND, OR, IN, NOT IN Query Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 5<\/strong><\/td>\n<td><strong><a href=\"\/insert-into.html\" data-lasso-id=\"185607\">MySQL INSERT INTO Query<\/a><\/strong> \u2014 How to add Row in Table (Example)<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 6<\/strong><\/td>\n<td><strong><a href=\"\/delete-and-update.html\" data-lasso-id=\"185608\">MySQL DELETE Query<\/a><\/strong> \u2014 How to Delete Row from a Table<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Data Sorting<\/h3>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/order-by-desc-and-asc.html\" data-lasso-id=\"185609\">ORDER BY in MySQL<\/a><\/strong> \u2014 DESC &amp; ASC Query with EXAMPLE<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/group-by.html\" data-lasso-id=\"185610\">SQL GROUP BY and HAVING Clause<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 3<\/strong><\/td>\n<td><strong><a href=\"\/wildcards.html\" data-lasso-id=\"185611\">MySQL Wildcards Tutorial<\/a><\/strong> \u2014 Like, NOT Like, Escape, ( % ), ( _ )<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 4<\/strong><\/td>\n<td><strong><a href=\"\/regular-expressions.html\" data-lasso-id=\"185612\">MYSQL Regular Expressions<\/a><\/strong> \u2014 MYSQL Regular Expressions with Syntax<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 5<\/strong><\/td>\n<td><strong><a href=\"\/functions.html\" data-lasso-id=\"185613\">MySQL Functions<\/a><\/strong> \u2014 String, Numeric, User-Defined, Stored<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 6<\/strong><\/td>\n<td><strong><a href=\"\/aggregate-functions.html\" data-lasso-id=\"185614\">MySQL Aggregate Functions Tutorial<\/a><\/strong> \u2014 SUM, AVG, MAX, MIN , COUNT, DISTINCT<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Must Know Stuff!<\/h3>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/null.html\" data-lasso-id=\"185615\">MySQL IS NULL &amp; IS NOT NULL Tutorial<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/auto-increment.html\" data-lasso-id=\"185616\">MySQL AUTO_INCREMENT<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 3<\/strong><\/td>\n<td><strong><a href=\"\/alter-drop-rename.html\" data-lasso-id=\"185617\">MYSQL Commands<\/a><\/strong> \u2014 ALTER, DROP, RENAME, MODIFY<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 4<\/strong><\/td>\n<td><strong><a href=\"\/limit.html\" data-lasso-id=\"185618\">MySQL LIMIT &amp; OFFSET<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- [element-157884] -->\n<style>.responsive-guru99-rectangle-above3{width:300px;height:100px}\n.responsive-guru99-rectangle-above1 {\n  margin-right: 6px;\n }\n \n.desktop-only {\n  display: none;\n}\n.mobile-only {\n  display: block;\n}\n@media(min-width: 768px) {\n  .responsive-guru99-rectangle-above3 {\n   width: 728px !important;\n   height: 90px !important;\n  }\n  \n  .desktop-only {\n    display: block;\n  }\n  \n  .mobile-only {\n    display: none;\n  }\n}\n@media(max-width: 767px) {\n  .responsive-guru99-rectangle-above3 {\n   width: 300px !important;\n   height: 100px !important;\n   padding-bottom: 15px;\n  }\n}\n<\/style>\n\n\n\n<div class=\"responsive-guru99-rectangle-above3 desktop-only\">\n  <a href=\"https:\/\/guru99.live\/58w8yb\" rel=\"sponsored noopener\" target=\"_blank\" onclick=\"gtag(&#039;event&#039;, &#039;mysql_tutorials&#039;, { &#039;event_category&#039;: &#039;MySQL Tutorial&#039;, &#039;event_action&#039;:&#039;Click&#039;,&#039;event_label&#039;:&#039;ManageEngine v5&#039; });\">\n    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.guru99.com\/images\/728x90-manageengine-sql-ads.gif\" alt=\"ManageEngine Application Manager\" width=\"728\" height=\"90\">\n  <\/a>\n<\/div>\n<div class=\"responsive-guru99-rectangle-above3 mobile-only\" id=\"guru99_top_banner\">\n  <a href=\"https:\/\/guru99.live\/bq866x\" rel=\"sponsored noopener\" target=\"_blank\" onclick=\"gtag(&#039;event&#039;, &#039;mysql_tutorials&#039;, { &#039;event_category&#039;: &#039;MySQL Tutorial&#039;, &#039;event_action&#039;:&#039;Click&#039;,&#039;event_label&#039;:&#039;ManageEngine v7&#039; });\">\n    <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.guru99.com\/images\/300x100-manageengine-sql-ads.gif\" alt=\"ManageEngine Application Manager\" width=\"300\" height=\"100\">\n  <\/a>\n<\/div>\n<!-- [\/element-157884] -->\n<h3>Most Dreaded Topics!<\/h3>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/sub-queries.html\" data-lasso-id=\"185619\">MySQL SubQuery Tutorial<\/a><\/strong> \u2014 Learn with Example<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/unions.html\" data-lasso-id=\"185620\">MySQL UNION<\/a><\/strong> \u2014 Complete Tutorial<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 3<\/strong><\/td>\n<td><strong><a href=\"\/joins.html\" data-lasso-id=\"185621\">MySQL JOINS Tutorial<\/a><\/strong> \u2014 INNER, OUTER, LEFT, RIGHT, CROSS<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 4<\/strong><\/td>\n<td><strong><a href=\"\/views.html\" data-lasso-id=\"185622\">MySQL Views<\/a><\/strong> \u2014 How to Create View from Tables with Examples<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 5<\/strong><\/td>\n<td><strong><a href=\"\/indexes.html\" data-lasso-id=\"185623\">MySQL Index Tutorial<\/a><\/strong> \u2014 Create, Add &amp; Drop<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 6<\/strong><\/td>\n<td><strong><a href=\"\/php-practical-example.html\" data-lasso-id=\"185624\">MySQL and PHP<\/a><\/strong> \u2014 Your First Application using MySQL and PHP<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 7<\/strong><\/td>\n<td><strong><a href=\"\/mysql-certification-guide.html\" data-lasso-id=\"185625\">MySQL Certifications<\/a><\/strong> \u2014 Oracle MySQL 5.6 Certification with Study Guide<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 8<\/strong><\/td>\n<td><strong><a href=\"\/sql-vs-mysql.html\" data-lasso-id=\"185626\">SQL vs MySQL<\/a><\/strong> \u2014 What&#8217;s the Difference Between SQL and MySQL?<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 9<\/strong><\/td>\n<td><strong><a href=\"\/sql-tools.html\" data-lasso-id=\"185627\">Best SQL Tools<\/a><\/strong> \u2014 25 Best SQL Tools | Database Software &amp; IDE<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 10<\/strong><\/td>\n<td><strong><a href=\"\/sql-interview-questions-answers.html\" data-lasso-id=\"185628\">SQL Interview Questions<\/a><\/strong> \u2014 Top 50 SQL Interview Questions and Answers<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 11<\/strong><\/td>\n<td><strong><a href=\"\/mysql-interview-questions.html\" data-lasso-id=\"10314820\">MySQL Interview Questions<\/a><\/strong> \u2014 Top 50 MySQL Interview Questions and Answers<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>MariaDB<\/strong><\/p>\n<table class=\"table\">\n<tbody>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 1<\/strong><\/td>\n<td><strong><a href=\"\/mariadb-tutorial-install.html\" data-lasso-id=\"323748\">MariaDB Tutorial<\/a><\/strong> \u2014 Learn Syntax, Commands with Examples<\/td>\n<\/tr>\n<tr>\n<td class=\"responsivetable\">\ud83d\udc49<strong> Lesson 2<\/strong><\/td>\n<td><strong><a href=\"\/mariadb-vs-mysql.html\" data-lasso-id=\"323749\">MariaDB vs MySQL<\/a><\/strong> \u2014 What is the Difference Between MariaDB &amp; MySQL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div>\n<h2><span id=\"what_is_mysql\">What is MySQL?<\/span><\/h2>\n<p><strong>MySQL<\/strong> is an open-source database management system used to organize data into one or more tables, having data types related to each other. These data types are used to extract, modify, or structure the data. It also allows implementing a database in computer systems, managing users, database integrity testing, and backup creation.<\/p>\n<\/div>\n<div>\n<h2><span id=\"importance_of_learning_mysql\">Why Learn MySQL?<\/span><\/h2>\n<p>Learning MySQL helps to understand how database management systems work. It also enhances your logical thinking and problem-solving ability. Moreover, database management systems are used in every industry, so there is a huge demand for MySQL professionals in the market. You can learn MySQL to get a job and for knowledge purposes as well.<\/p>\n<\/div>\n<h2>Prerequisites for learning MySQL Tutorial?<\/h2>\n<p>This MySQL course is designed for beginners having no prior Database knowledge. However, if you have a basic knowledge of computer, database, and Database Management Systems, it will help you learn MySQL more easily and efficiently.<\/p>\n<h2>What will you learn in this MySQL Tutorial?<\/h2>\n<p>In this MySQL tutorial, you will learn about database fundamentals, MySQL Workbench, MySQL basics, Normalization, ER model, Data sorting in MySQL, MySQL Wildcards, MySQL functions, Advanced MySQL operations, SQL interview questions, and many more interesting concepts about MySQL.<\/p>\n\n\n<div id=\"cbox-JBPv1Kyp2sbr1JFu\"><\/div>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>MySQL Tutorial Summary MySQL is the most popular open-source database management system. This MySQL tutorial for beginners covers all concepts like MySQL basics, normalization, and MySQL Workbench installation. Later in this MySQL tutorial, Commands like Select, Insert, Group By and advance topics like Wildcards &amp; Functions are covered. What should I know? This MySQL for&#8230;<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":55,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[5],"tags":[140,161],"coauthors":[494],"class_list":["post-1153","post","type-post","status-publish","format-standard","hentry","category-sql","tag-ads-disabled","tag-convertbox-sir"],"taxonomy_info":{"category":[{"value":5,"label":"SQL"}],"post_tag":[{"value":140,"label":"ADS-Disabled"},{"value":161,"label":"Convertbox-Sir"}]},"featured_image_src_large":false,"author_info":{"display_name":"Marcus Allen","author_link":"https:\/\/www.guru99.com\/author\/marcus"},"comment_info":1,"category_info":[{"term_id":5,"name":"SQL","slug":"sql","term_group":0,"term_taxonomy_id":5,"taxonomy":"category","description":"","parent":0,"count":42,"filter":"raw","cat_ID":5,"category_count":42,"category_description":"","cat_name":"SQL","category_nicename":"sql","category_parent":0}],"tag_info":[{"term_id":140,"name":"ADS-Disabled","slug":"ads-disabled","term_group":0,"term_taxonomy_id":140,"taxonomy":"post_tag","description":"","parent":0,"count":1145,"filter":"raw"},{"term_id":161,"name":"Convertbox-Sir","slug":"convertbox-sir","term_group":0,"term_taxonomy_id":161,"taxonomy":"post_tag","description":"","parent":0,"count":799,"filter":"raw"}],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/posts\/1153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/comments?post=1153"}],"version-history":[{"count":7,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/posts\/1153\/revisions"}],"predecessor-version":[{"id":165435,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/posts\/1153\/revisions\/165435"}],"wp:attachment":[{"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/media?parent=1153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/categories?post=1153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/tags?post=1153"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.guru99.com\/wp-json\/wp\/v2\/coauthors?post=1153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}