{"id":123,"date":"2013-04-05T14:54:47","date_gmt":"2013-04-05T14:54:47","guid":{"rendered":"http:\/\/ecodebook.wordpress.com\/2013\/04\/05\/mysql-duplicate-id-into-other-column-in-the-same-table-in-mysql\/"},"modified":"2013-04-05T14:54:47","modified_gmt":"2013-04-05T14:54:47","slug":"mysql-duplicate-id-into-other-column-in-the-same-table-in-mysql","status":"publish","type":"post","link":"https:\/\/blog.mycarts.shop\/?p=123","title":{"rendered":"MySQL: Duplicate id into other column in the same table in MySQL"},"content":{"rendered":"<h3>Duplicate id into other column in MySQL.<\/h3>\n<p>[code language=&#8221;sql&#8221;]<br \/>\nUPDATE contest_cat SET pid = id<br \/>\n[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duplicate id into other column in MySQL. [code language=&#8221;sql&#8221;] UPDATE contest_cat SET pid = id [\/code]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[17],"class_list":["post-123","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=123"}],"version-history":[{"count":0,"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=\/wp\/v2\/posts\/123\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mycarts.shop\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}