{"id":1894,"date":"2019-04-21T14:27:45","date_gmt":"2019-04-21T06:27:45","guid":{"rendered":"https:\/\/www.yusian.com\/blog\/?p=1894"},"modified":"2020-12-02T14:43:44","modified_gmt":"2020-12-02T06:43:44","slug":"ddl%e5%b8%b8%e7%94%a8%e6%93%8d%e4%bd%9c%e5%8f%8a%e5%b8%b8%e8%a7%81%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/www.yusian.com\/blog\/database\/2019\/04\/21\/1427451894.html","title":{"rendered":"DDL\u5e38\u7528\u64cd\u4f5c\u53ca\u5e38\u89c1\u95ee\u9898"},"content":{"rendered":"<p><strong>DDL\uff08data defination language\uff09\u6570\u636e\u5b9a\u4e49\u8bed\u8a00<\/strong><\/p>\n<h3>1\u3001\u5b57\u7b26\u7f16\u7801\u95ee\u9898<\/h3>\n<ul>\n<li>\u67e5\u770b\u5f53\u524d\u7f16\u7801\u65b9\u5f0f\uff0cshow variables like \u2018%char%\u2019;<\/li>\n<li>\u8bbe\u7f6e\u5f53\u524d\u64cd\u4f5c\u53ca\u663e\u793a\u7f16\u7801\u65b9\u5f0f set names utf8;<\/li>\n<li>\u4fee\u6539xxx\u8868\u7684\u9ed8\u8ba4\u5b57\u7b26\u96c6\uff1aalter table xxx default character set utf8;<\/li>\n<li>\u4fee\u6539\u6570\u636e\u5e93xxx\u9ed8\u8ba4\u5b57\u7b26\u96c6\uff1aalter database xxx default character set utf8;<\/li>\n<li>\u4fee\u6539\u8868\u521b\u5efa\u5b57\u6bb5\u9ed8\u8ba4\u5b57\u7b26\u96c6\uff1aalter table xxx default character set utf8 collate utf8_general_ci;<\/li>\n<li>\u4fee\u6539\u8868\u6240\u6709\u5b57\u6bb5\u9ed8\u8ba4\u5b57\u7b26\u96c6\u53ca\u5f53\u524d\u5b57\u7b26\u96c6\uff1aalter table xxx convert to character set utf8 collate utf8_general_ci;<\/li>\n<li>\u4fee\u6539\u67d0\u5b57\u6bb5\u7684\u5b57\u7b26\u96c6\uff1aalter table xxx change xxx chracter set utf8 not null \u2026..;<\/li>\n<\/ul>\n<h3>2\u3001\u4ec0\u4e48\u65f6\u5019\u9700\u8981\u52a0\u2019table\u2019\u8fd9\u4e2a\u5173\u952e\u5b57\uff1f<\/h3>\n<ul>\n<li>DDL\u76f8\u5173\u7684\u8868\u64cd\u4f5c\u90fd\u9700\u8981talbe\u5173\u952e\u5b57\uff0c\u7b80\u5355\u4e00\u70b9\u7406\u89e3\uff0c\u589e\u3001\u5220\u3001\u6539\u3001\u67e5\u8fd9\u4e9b\u5bf9\u8868\u7684\u64cd\u4f5c\u8bed\u53e5\u4e0d\u9700\u8981talbe\u5173\u952e\u5b57\uff1b<\/li>\n<\/ul>\n<h3>3\u3001drop\u3001delete\u3001truncate\u7684\u533a\u522b<\/h3>\n<ul>\n<li>\u6574\u4e2a\u8868\u5220\u9664\u4f7f\u7528drop table xxx\uff1b<\/li>\n<li>\u5220\u9664\u8868\u4e2d\u6240\u6709\u6570\u636e\u4f7f\u7528truncate xxx\uff0c\u6548\u679c\u76f8\u5f53\u4e8edelete from xxx\uff0c\u4e0d\u540c\u7684\u662ftruncate\u4f1a\u590d\u4f4d\u81ea\u589e\u5b57\u6bb5\u7684\u503c;<\/li>\n<li>\u5220\u9664\u8868\u4e2d\u90e8\u5206\u6570\u636e\u4f7f\u7528delete from xxx where\uff1b<\/li>\n<\/ul>\n<h3>4\u3001\u4fee\u6539\u6570\u636e\u5e93\u7528\u6237\u5bc6\u7801\u7684\u4e09\u79cd\u65b9\u5f0f<\/h3>\n<ul>\n<li>\u5728mysql\u6570\u636e\u5e93\u7684user\u8868\u4e2d\u4fee\u6539\u5bf9\u5e94\u6570\u636e\n<pre><code class=\"language-sql line-numbers\">update user set authentication_string = password(\u2018******\u2019) where user = \u2018root'\n<\/code><\/pre>\n<\/li>\n<li>\u4f7f\u7528mysqladmin\u4fee\u6539\n<pre><code class=\"language-sql line-numbers\">mysqladmin -uroot -pxxxx password \u2018xxxxxx'\n<\/code><\/pre>\n<\/li>\n<li>\u4f7f\u7528sudo mysqld \u2014skip-grant-tables\u547d\u4ee4\n<ul>\n<li>\u7ed5\u8fc7\u5bc6\u7801\u7684\u6821\u9a8c\uff0c\u7136\u540e\u518d\u901a\u8fc7\u7b2c\u4e00\u79cd\u65b9\u5f0f\u4fee\u6539\u5bc6\u7801<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>5\u3001\u65b0\u589e\u4e00\u4e2a\u7528\u6237<\/h3>\n<pre><code class=\"language-sql line-numbers\">create user xxx@localhost identified by \u2018xxxxxx'\n<\/code><\/pre>\n<h3>6\u3001\u5220\u9664\u4e00\u4e2a\u7528\u6237<\/h3>\n<pre><code class=\"language-sql line-numbers\">drop user xxxx@localhost\n<\/code><\/pre>\n<h3>7\u3001\u521b\u5efa\u4e00\u4e2a\u8868\uff0c\u6307\u5b9a\u5b57\u7b26\u7f16\u7801\u3001\u5f15\u64ce<\/h3>\n<pre><code class=\"language-sql line-numbers\">create table xxx(xx varchar(4)) engine=InnoDB charset=utf8 collate=utf8_general_ci\n<\/code><\/pre>\n<h3>8\u3001\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u5b57\u7b26\u96c6\uff1b<\/h3>\n<ul>\n<li>show chracter set\n<pre><code class=\"language-sql line-numbers\">mysql&gt; show character set;\n+----------+---------------------------------+---------------------+--------+\n| Charset  | Description                     | Default collation   | Maxlen |\n+----------+---------------------------------+---------------------+--------+\n| big5     | Big5 Traditional Chinese        | big5_chinese_ci     |      2 |\n| dec8     | DEC West European               | dec8_swedish_ci     |      1 |\n| cp850    | DOS West European               | cp850_general_ci    |      1 |\n| hp8      | HP West European                | hp8_english_ci      |      1 |\n| koi8r    | KOI8-R Relcom Russian           | koi8r_general_ci    |      1 |\n| latin1   | cp1252 West European            | latin1_swedish_ci   |      1 |\n| latin2   | ISO 8859-2 Central European     | latin2_general_ci   |      1 |\n| swe7     | 7bit Swedish                    | swe7_swedish_ci     |      1 |\n| ascii    | US ASCII                        | ascii_general_ci    |      1 |\n| ujis     | EUC-JP Japanese                 | ujis_japanese_ci    |      3 |\n| sjis     | Shift-JIS Japanese              | sjis_japanese_ci    |      2 |\n| hebrew   | ISO 8859-8 Hebrew               | hebrew_general_ci   |      1 |\n| tis620   | TIS620 Thai                     | tis620_thai_ci      |      1 |\n| euckr    | EUC-KR Korean                   | euckr_korean_ci     |      2 |\n| koi8u    | KOI8-U Ukrainian                | koi8u_general_ci    |      1 |\n| gb2312   | GB2312 Simplified Chinese       | gb2312_chinese_ci   |      2 |\n| greek    | ISO 8859-7 Greek                | greek_general_ci    |      1 |\n| cp1250   | Windows Central European        | cp1250_general_ci   |      1 |\n| gbk      | GBK Simplified Chinese          | gbk_chinese_ci      |      2 |\n| latin5   | ISO 8859-9 Turkish              | latin5_turkish_ci   |      1 |\n| armscii8 | ARMSCII-8 Armenian              | armscii8_general_ci |      1 |\n| utf8     | UTF-8 Unicode                   | utf8_general_ci     |      3 |\n| ucs2     | UCS-2 Unicode                   | ucs2_general_ci     |      2 |\n| cp866    | DOS Russian                     | cp866_general_ci    |      1 |\n| keybcs2  | DOS Kamenicky Czech-Slovak      | keybcs2_general_ci  |      1 |\n| macce    | Mac Central European            | macce_general_ci    |      1 |\n| macroman | Mac West European               | macroman_general_ci |      1 |\n| cp852    | DOS Central European            | cp852_general_ci    |      1 |\n| latin7   | ISO 8859-13 Baltic              | latin7_general_ci   |      1 |\n| utf8mb4  | UTF-8 Unicode                   | utf8mb4_general_ci  |      4 |\n| cp1251   | Windows Cyrillic                | cp1251_general_ci   |      1 |\n| utf16    | UTF-16 Unicode                  | utf16_general_ci    |      4 |\n| utf16le  | UTF-16LE Unicode                | utf16le_general_ci  |      4 |\n| cp1256   | Windows Arabic                  | cp1256_general_ci   |      1 |\n| cp1257   | Windows Baltic                  | cp1257_general_ci   |      1 |\n| utf32    | UTF-32 Unicode                  | utf32_general_ci    |      4 |\n| binary   | Binary pseudo charset           | binary              |      1 |\n| geostd8  | GEOSTD8 Georgian                | geostd8_general_ci  |      1 |\n| cp932    | SJIS for Windows Japanese       | cp932_japanese_ci   |      2 |\n| eucjpms  | UJIS for Windows Japanese       | eucjpms_japanese_ci |      3 |\n| gb18030  | China National Standard GB18030 | gb18030_chinese_ci  |      4 |\n+----------+---------------------------------+---------------------+--------+\n41 rows in set (0.00 sec)\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>9\u3001\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u652f\u6301\u7684\u5f15\u64ce<\/h3>\n<ul>\n<li>show engines;\n<pre><code class=\"language-sql line-numbers\">mysql&gt; show engines;\n+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+\n| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |\n+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+\n| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |\n| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |\n| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |\n| BLACKHOLE          | YES     | \/dev\/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |\n| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |\n| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |\n| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |\n| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |\n| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |\n+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+\n9 rows in set (0.00 sec)\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>10\u3001\u4fee\u6539\u6570\u636e\u5e93\u5b57\u7b26\u96c6<\/h3>\n<ul>\n<li>\u67e5\u770b\u6570\u636e\u5e93\u5b57\u7b26\u96c6 show create database xxxx\n<pre><code class=\"language-sql line-numbers\">mysql&gt; show create database sian;\n+----------+---------------------------------------------------------------+\n| Database | Create Database                                               |\n+----------+---------------------------------------------------------------+\n| sian     | CREATE DATABASE `sian` \/*!40100 DEFAULT CHARACTER SET utf8 *\/ |\n+----------+---------------------------------------------------------------+\n1 row in set (0.00 sec)\n<\/code><\/pre>\n<\/li>\n<li>\u4fee\u6539\u6570\u636e\u5e93\u5b57\u7b26\u96c6\n<pre><code class=\"language-sql line-numbers\">mysql&gt; alter database sian charset = utf8;\nQuery OK, 1 row affected (0.00 sec)\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>11\u3001\u4fee\u6539\u6570\u636e\u5e93\u8868\u5f15\u64ce<\/h3>\n<ul>\n<li>\u67e5\u770b\u6570\u636e\u5e93\u8868\u5f15\u64ce\n<pre><code class=\"language-sql line-numbers\">mysql&gt; show create table user;\nCREATE TABLE `user` (\n`id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n`user_name` varchar(20) NOT NULL COMMENT '\u7528\u6237\u540d',\n`sex` enum('\u7537','\u5973') NOT NULL DEFAULT '\u7537',\n`password` char(32) NOT NULL COMMENT '\u5bc6\u7801',\n`email` varchar(50) NOT NULL COMMENT '\u7528\u6237\u90ae\u7bb1',\n`address` varchar(50) DEFAULT NULL,\n`fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '\u7528\u6237\u4f59\u989d',\n`age` tinyint(3) unsigned NOT NULL COMMENT '\u5e74\u9f84',\n`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '\u521b\u5efa\u65f6\u95f4',\nPRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8\n<\/code><\/pre>\n<\/li>\n<li>\u4fee\u6539\u6570\u636e\u5e93\u8868\u5f15\u64ce\n<pre><code class=\"language-sql line-numbers\">mysql&gt; alter table user engine = innodb;\nQuery OK, 0 rows affected (0.04 sec)\nRecords: 0  Duplicates: 0  Warnings: 0\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>12\u3001\u4fee\u6539\u8868\u5b57\u7b26\u96c6<\/h3>\n<ul>\n<li>alter table user charset = utf8\n<pre><code class=\"language-sql line-numbers\">mysql&gt; alter table user charset = utf8;\nQuery OK, 0 rows affected (0.00 sec)\nRecords: 0  Duplicates: 0  Warnings: 0\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>13\u3001\u67e5\u770b\u6570\u636e\u5e93\u8868\u72b6\u6001\uff1b<\/h3>\n<ul>\n<li>show tables status;\n<pre><code class=\"language-cmd line-numbers\">mysql&gt; show table status \\G\n*************************** 1. row ***************************\n         Name: mark\n       Engine: InnoDB\n      Version: 10\n   Row_format: Dynamic\n         Rows: 6\nAvg_row_length: 2730\n  Data_length: 16384\nMax_data_length: 0\n Index_length: 0\n    Data_free: 0\nAuto_increment: 8\n  Create_time: 2019-04-22 20:22:38\n  Update_time: 2019-04-22 20:22:38\n   Check_time: NULL\n    Collation: utf8_general_ci\n     Checksum: NULL\nCreate_options:\n      Comment:\n*************************** 2. row ***************************\n         Name: user\n       Engine: InnoDB\n      Version: 10\n   Row_format: Dynamic\n         Rows: 6\nAvg_row_length: 2730\n  Data_length: 16384\nMax_data_length: 0\n Index_length: 0\n    Data_free: 0\nAuto_increment: 7\n  Create_time: 2019-04-22 21:12:39\n  Update_time: NULL\n   Check_time: NULL\n    Collation: utf8_general_ci\n     Checksum: NULL\nCreate_options:\n      Comment:\n*************************** 3. row ***************************\n         Name: users\n       Engine: InnoDB\n      Version: 10\n   Row_format: Dynamic\n         Rows: 0\nAvg_row_length: 0\n  Data_length: 16384\nMax_data_length: 0\n Index_length: 0\n    Data_free: 0\nAuto_increment: 1\n  Create_time: 2019-04-20 11:29:16\n  Update_time: NULL\n   Check_time: NULL\n    Collation: latin1_swedish_ci\n     Checksum: NULL\nCreate_options:\n      Comment:\n3 rows in set (0.00 sec)\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>14\u3001\u6570\u636e\u7c7b\u578bint(n)\u4e2d\u7684n\u4ee3\u8868\u542b\u4e49<\/h3>\n<ul>\n<li>int\u7c7b\u578b\u53ef\u5b58\u50a8\u6700\u5927\u6570\u503c\u7531\u7c7b\u578b\u672c\u8eab\u51b3\u5b9a(4\u4e2a\u5b57\u8282)\uff0cn\u53ea\u5728zerofill\u65f6\u6709\u6548\uff0c\u5c0f\u4e8en\u957f\u5ea6\u6570\u636e\u524d\u9762\u88ab0\n<pre><code class=\"language-sql line-numbers\">mysql&gt; desc t_int;\n+-------+---------------------------+------+-----+---------+-------+\n| Field | Type                      | Null | Key | Default | Extra |\n+-------+---------------------------+------+-----+---------+-------+\n| num   | int(10) unsigned zerofill | YES  |     | NULL    |       |\n| num_u | int(10) unsigned          | YES  |     | NULL    |       |\n+-------+---------------------------+------+-----+---------+-------+\n2 rows in set (0.00 sec)\n\nmysql&gt; select * from t_int;\n+------------+-------+\n| num        | num_u |\n+------------+-------+\n| 0000000123 |   456 |\n+------------+-------+\n1 row in set (0.00 sec)\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>15\u3001\u6570\u636e\u7c7b\u578bchar(n)\u4e2d\u7684n\u542b\u4e49<\/h3>\n<ul>\n<li>char\u7c7b\u578b\u4e2dn\u5373\u8868\u793a\u5b58\u50a8\u7684\u6700\u5927\u5b57\u7b26\u6570\uff0c\u5b57\u7b26\u4e0d\u7b49\u4e8e\u5b57\u8282<\/li>\n<li>select length(\u5b57\u6bb5\u540d)\u53ef\u67e5\u8be2\u5b57\u8282\u957f\u5ea6\uff0c\u5728utf8\u4e2d\u4e00\u4e2a\u4e2d\u6587\u5b57\u7b26\u53603\u4e2a\u5b57\u8282(gbk\u4e2d\u4e3a2\u4e2a\u5b57\u8282)<\/li>\n<li>select char_length(\u5b57\u6bb5\u540d)\u53ef\u67e5\u8be2\u5b57\u7b26\u957f\u5ea6\uff0c\u4e0en\u4e00\u81f4\uff1b<\/li>\n<li>\u5982\u679c\u662fvarchar\uff0c\u5219length(varc)\u5219\u662f\u5b9e\u9645\u6570\u636e\u7684\u5b57\u7b26\u6570\uff1b<\/li>\n<\/ul>\n<pre><code class=\"language-sql line-numbers\">mysql&gt; insert into t_char values('123');\nERROR 1136 (21S01): Column count doesn't match value count at row 1\nmysql&gt; insert into t_char(c) values('123');\nQuery OK, 1 row affected (0.01 sec)\n\n\nmysql&gt; select * from t_char;\n+----+-----+\n| id | c   |\n+----+-----+\n|  1 | 123 |\n+----+-----+\n1 row in set (0.00 sec)\n\n\nmysql&gt; insert into t_char(c) vlaues('12345');\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vlaues('12345')' at line 1\n\nmysql&gt; insert into t_char(c) values('\u4f59\u897f\u5b89');\nQuery OK, 1 row affected (0.01 sec)\n\n\nmysql&gt; select * from t_char;\n+----+-----------+\n| id | c         |\n+----+-----------+\n|  1 | 123       |\n|  2 | \u4f59\u897f\u5b89    |\n+----+-----------+\n2 rows in set (0.00 sec)\n\n\nmysql&gt; select length(c) from t_char;\n+-----------+\n| length(c) |\n+-----------+\n|         3 |\n|         9 |\n+-----------+\n2 rows in set (0.01 sec)\n\n\nmysql&gt; select char_length(c) from t_char;\n+----------------+\n| char_length(c) |\n+----------------+\n|              3 |\n|              3 |\n+----------------+\n2 rows in set (0.00 sec)\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DDL\uff08data defination language\uff09\u6570\u636e\u5b9a\u4e49\u8bed\u8a00 1\u3001\u5b57\u7b26\u7f16\u7801\u95ee\u9898 \u67e5\u770b\u5f53\u524d\u7f16\u7801\u65b9\u5f0f\uff0cshow variables like \u2018%char%\u2019; \u8bbe\u7f6e\u5f53\u524d\u64cd\u4f5c\u53ca\u663e\u793a\u7f16\u7801\u65b9\u5f0f set names utf8; \u4fee\u6539xxx\u8868\u7684\u9ed8\u8ba4\u5b57\u7b26\u96c6\uff1aalter table xxx default character set utf8; \u4fee\u6539\u6570\u636e\u5e93xxx\u9ed8\u8ba4\u5b57\u7b26\u96c6\uff1aalter database xxx default character set utf8; \u4fee\u6539\u8868\u521b\u5efa\u5b57\u6bb5\u9ed8\u8ba4\u5b57\u7b26\u96c6\uff1aalter table xxx default character set utf8 collate utf8_general_ci; \u4fee\u6539\u8868\u6240\u6709\u5b57\u6bb5\u9ed8\u8ba4\u5b57\u7b26\u96c6\u53ca\u5f53\u524d\u5b57\u7b26\u96c6\uff1aalter table xxx convert to character set utf8 collate utf8_general_ci; \u4fee\u6539\u67d0\u5b57\u6bb5\u7684\u5b57\u7b26\u96c6\uff1aalter table xxx change xxx chracter set utf8 not null [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[282],"tags":[327,22],"class_list":["post-1894","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts\/1894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/comments?post=1894"}],"version-history":[{"count":0,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/posts\/1894\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/media?parent=1894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/categories?post=1894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yusian.com\/blog\/wp-json\/wp\/v2\/tags?post=1894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}