{"id":4466,"date":"2018-10-31T08:39:38","date_gmt":"2018-10-31T08:39:38","guid":{"rendered":"https:\/\/dbtut.com\/?p=4466"},"modified":"2018-11-28T07:34:55","modified_gmt":"2018-11-28T07:34:55","slug":"tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/","title":{"rendered":"Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL"},"content":{"rendered":"

 <\/p>\n

Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … on duplicate key update …’. In my recent work, i found that there were some traps when using them, and this article is to show what will happen and why.<\/p>\n

<\/h3>\n

1) replace into<\/h3>\n
CREATE TABLE `t1` (\r\n\r\n\u00a0 `a` int(11) NOT NULL AUTO_INCREMENT,\r\n\r\n\u00a0 `b` int(11) DEFAULT NULL,\r\n\r\n\u00a0 `c` int(11) DEFAULT NULL,\r\n\r\n\u00a0 PRIMARY KEY (`a`),\r\n\r\n\u00a0 UNIQUE KEY `uniq_b` (`b`)\r\n\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8<\/pre>\n
 <\/p>\n
Replace a duplicate row:<\/strong><\/p>\n
mysql> select * from t1;\u00a0\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 1 |\u00a0 \u00a0 1 |\u00a0 \u00a0 2 |\r\n\r\n| 2 |\u00a0 \u00a0 2 | NULL |\r\n\r\n+---+------+------+<\/pre>\n
mysql> replace into t1(b,c) values (1,9);\u00a0\r\n\r\nQuery OK, 2 rows affected (0.07 sec)<\/pre>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 2 |\u00a0 \u00a0 2 | NULL |\r\n\r\n| 3 |\u00a0 \u00a0 1 |\u00a0 \u00a0 9 |\r\n\r\n+---+------+------+<\/pre>\n
 <\/p>\n
After we used ‘replace into …’ on the unique key, the (1,1,2) was deleted and a new row (3,1,9) was\u00a0inserted, it’s not just replaced values at the (1,1,2) row because the column ‘a’ used the\u00a0AUTO_INCREMENT value ‘3’.<\/p>\n
 <\/p>\n
Column name must be specified:<\/strong><\/p>\n
If you didn’t specify the column name, for example:<\/p>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 1 |\u00a0 \u00a0 1 |\u00a0 \u00a0 2 |\r\n\r\n| 2 |\u00a0 \u00a0 2 | NULL |\r\n\r\n+---+------+------+<\/pre>\n
mysql> replace into t1(b) values (1);\r\n\r\nQuery OK, 2 rows affected (0.06 sec)<\/pre>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 2 |\u00a0 \u00a0 2 | NULL |\r\n\r\n| 3 |\u00a0 \u00a0 1 | NULL |\r\n\r\n+---+------+------+<\/pre>\n
 <\/p>\n
Column ‘a’ and ‘c’ have been changed into ‘3’ and ‘null’, so when using ‘replace into’, it will delete the duplicate row and insert a new row\u00a0with the default value<\/b>.<\/p>\n
 <\/p>\n
Replace a\u00a0duplicate primary key and a duplicate unique key at the same time:<\/strong><\/p>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 2 |\u00a0 \u00a0 2 |\u00a0 \u00a0 2 |\r\n\r\n| 3 |\u00a0 \u00a0 1 |\u00a0 \u00a0 2 |\r\n\r\n+---+------+------+<\/pre>\n
mysql> replace into t1(a,b,c) values (2,1,9);\r\n\r\nQuery OK,\u00a03 rows affected\u00a0(0.10 sec)<\/pre>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 2 |\u00a0 \u00a0 1 |\u00a0 \u00a0 9 |\r\n\r\n+---+------+------+<\/pre>\n
 <\/p>\n
After ‘replace into …’, it shows ‘3 rows affected\u00a0<\/b>‘, two rows have been deleted and just one row is inserted into t1.<\/p>\n
As\u00a0mentioned before, ‘replace into ..’ will delete the duplicate rows before inserting, so when the ‘replace into t1(a,b,c) values (2,1,9);’ is executing, it checks the primary key first, it’s duplicated, so the (2,2,2) is deleted, then the column ‘b’ is also duplicated, so the (3,1,2) is deleted, after that, no duplicate key exists, then insert a new row (2,1,9).<\/p>\n
<\/h3>\n
2) Insert into … on duplicate key update …<\/h3>\n
Using the same table t1 for testing:<\/p>\n
Insert a duplicate primary key row:<\/strong><\/p>\n
mysql> select * from t1;\u00a0\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 1 |\u00a0 \u00a0 1 |\u00a0 \u00a0 2 |\r\n\r\n| 2 |\u00a0 \u00a0 2 | NULL |\r\n\r\n+---+------+------+<\/pre>\n
mysql> insert into t1(a,b,c) values (2,3,4) on duplicate key update c=4;\r\n\r\nQuery OK, 2 rows affected (0.02 sec)<\/pre>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 1 |\u00a0 \u00a0 1 |\u00a0 \u00a0 2 |\r\n\r\n| 2 |\u00a0 \u00a0 2 |\u00a0 \u00a0 4 |\r\n\r\n+---+------+------+<\/pre>\n
 <\/p>\n
The ‘insert … on duplicate key update…’ just checked the primary key, and after found the primary key ‘a’ had a duplicate value ‘2’, then it updated the column ‘c’ to new value ‘4’, and ignored the column ‘b’ which was also duplicate. So we got the new line (2,2,4) instead of (2,3,4).<\/p>\n
 <\/p>\n
Insert on a duplicate key row:<\/strong><\/p>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 1 |\u00a0 \u00a0 1 |\u00a0 \u00a0 2 |\r\n\r\n| 2 |\u00a0 \u00a0 2 |\u00a0 \u00a0 4 |\r\n\r\n+---+------+------+<\/pre>\n
mysql> insert into t1(b,c) values (1,5) on duplicate key update c=5;\r\n\r\nQuery OK, 2 rows affected (0.20 sec)<\/pre>\n
mysql> select * from t1;\r\n\r\n+---+------+------+\r\n\r\n| a | b\u00a0 \u00a0 | c\u00a0 \u00a0 |\r\n\r\n+---+------+------+\r\n\r\n| 1 |\u00a0 \u00a0 1 |\u00a0 \u00a0 5 |\r\n\r\n| 2 |\u00a0 \u00a0 2 |\u00a0 \u00a0 4 |\r\n\r\n+---+------+------+<\/pre>\n
 <\/p>\n
This is different with ‘replace into ..’, it just updates the value on the duplicate row, with no deletion.<\/p>\n
In a word, before using ‘replace into…’ and ‘insert into … on duplicate key update …’, you must know what they actually do, otherwise you will get unexpected results.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … on duplicate key update …’. In my recent work, i found that there were some traps when using them, and this article is to show what will happen and why. …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":50,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[7],"tags":[1301,1550],"class_list":["post-4466","post","type-post","status-publish","format-standard","","category-mysql","tag-mysql","tag-sql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":2022,"today_views":0},"yoast_head":"\nTips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-31T08:39:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-28T07:34:55+00:00\" \/>\n<meta name=\"author\" content=\"Shuo Wang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shuo Wang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\"},\"author\":{\"name\":\"Shuo Wang\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\"},\"headline\":\"Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL\",\"datePublished\":\"2018-10-31T08:39:38+00:00\",\"dateModified\":\"2018-11-28T07:34:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\"},\"wordCount\":393,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"MySQL\",\"sql\"],\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\",\"name\":\"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-10-31T08:39:38+00:00\",\"dateModified\":\"2018-11-28T07:34:55+00:00\",\"description\":\"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\",\"name\":\"Shuo Wang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"caption\":\"Shuo Wang\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/shuowang\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL - Database Tutorials","description":"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL","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:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL - Database Tutorials","og_description":"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-31T08:39:38+00:00","article_modified_time":"2018-11-28T07:34:55+00:00","author":"Shuo Wang","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shuo Wang","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/"},"author":{"name":"Shuo Wang","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289"},"headline":"Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL","datePublished":"2018-10-31T08:39:38+00:00","dateModified":"2018-11-28T07:34:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/"},"wordCount":393,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["MySQL","sql"],"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/","name":"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-10-31T08:39:38+00:00","dateModified":"2018-11-28T07:34:55+00:00","description":"Tips when using 'replace into' and 'insert ... on duplicate key update...' in MySQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/31\/tips-when-using-replace-into-and-insert-on-duplicate-key-update-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289","name":"Shuo Wang","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","caption":"Shuo Wang"},"url":"https:\/\/dbtut.com\/index.php\/author\/shuowang\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/4466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=4466"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/4466\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=4466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=4466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=4466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}