{"id":451,"date":"2018-09-04T14:59:47","date_gmt":"2018-09-04T13:59:47","guid":{"rendered":"http:\/\/blog.chen-hongyi.com\/?p=451"},"modified":"2018-09-04T14:59:47","modified_gmt":"2018-09-04T13:59:47","slug":"uuid-%e4%bd%8e%e4%bd%8d%e9%ab%98%e4%bd%8d%e4%bf%ae%e5%a4%8dsql","status":"publish","type":"post","link":"https:\/\/chen-hongyi.com\/?p=451","title":{"rendered":"uuid \u4f4e\u4f4d\u9ad8\u4f4d\u4fee\u590dSQL"},"content":{"rendered":"

\u6211\u66fe\u7ecf\u5199\u8fc7\u4e00\u7bc7\u5173\u4e8ephp \u4e8c\u8fdb\u5236\u6253\u5305\u7684\u53c2\u6570h\u548cH\u641e\u9519\u9020\u6210\u7684\u6570\u636e\u5f55\u5165\u9519\u8bef\u3002 \u5bf9\u4e8e\u5df2\u7ecf\u5f55\u5165\u7684\u6570\u636e\uff0c\u5982\u4f55\u4fee\u590d\u5462\u3002 \u6709\u4e2a\u9ad8\u624b\u540c\u4e8b\u5199\u4e86\u4ee5\u4e0b\u7684sql.<\/p>\n

<\/p>\n

UPDATE table_name SET user_uuid_fixed = UNHEX(
\n CONCAT(
\n MID(HEX(user_uuid), 2, 1),
\n MID(HEX(user_uuid), 1, 1),<\/p>\n

MID(HEX(user_uuid), 4, 1),
\n MID(HEX(user_uuid), 3, 1),<\/p>\n

MID(HEX(user_uuid), 6, 1),
\n MID(HEX(user_uuid), 5, 1),<\/p>\n

MID(HEX(user_uuid), 8, 1),
\n MID(HEX(user_uuid), 7, 1),<\/p>\n

MID(HEX(user_uuid), 10, 1),
\n MID(HEX(user_uuid), 9, 1),<\/p>\n

MID(HEX(user_uuid), 12, 1),
\n MID(HEX(user_uuid), 11, 1),<\/p>\n

MID(HEX(user_uuid), 14, 1),
\n MID(HEX(user_uuid), 13, 1),<\/p>\n

MID(HEX(user_uuid), 16, 1),
\n MID(HEX(user_uuid), 15, 1),<\/p>\n

MID(HEX(user_uuid), 18, 1),
\n MID(HEX(user_uuid), 17, 1),<\/p>\n

MID(HEX(user_uuid), 20, 1),
\n MID(HEX(user_uuid), 19, 1),<\/p>\n

MID(HEX(user_uuid), 22, 1),
\n MID(HEX(user_uuid), 21, 1),<\/p>\n

MID(HEX(user_uuid), 24, 1),
\n MID(HEX(user_uuid), 23, 1),<\/p>\n

MID(HEX(user_uuid), 26, 1),
\n MID(HEX(user_uuid), 25, 1),<\/p>\n

MID(HEX(user_uuid), 28, 1),
\n MID(HEX(user_uuid), 27, 1),<\/p>\n

MID(HEX(user_uuid), 30, 1),
\n MID(HEX(user_uuid), 29, 1),<\/p>\n

MID(HEX(user_uuid), 32, 1),
\n MID(HEX(user_uuid), 31, 1)
\n )
\n);<\/p>\n

UPDATE table_name SET journey_fixed = UNHEX(
\n CONCAT(
\n MID(HEX(journey), 2, 1),
\n MID(HEX(journey), 1, 1),<\/p>\n

MID(HEX(journey), 4, 1),
\n MID(HEX(journey), 3, 1),<\/p>\n

MID(HEX(journey), 6, 1),
\n MID(HEX(journey), 5, 1),<\/p>\n

MID(HEX(journey), 8, 1),
\n MID(HEX(journey), 7, 1),<\/p>\n

MID(HEX(journey), 10, 1),
\n MID(HEX(journey), 9, 1),<\/p>\n

MID(HEX(journey), 12, 1),
\n MID(HEX(journey), 11, 1),<\/p>\n

MID(HEX(journey), 14, 1),
\n MID(HEX(journey), 13, 1),<\/p>\n

MID(HEX(journey), 16, 1),
\n MID(HEX(journey), 15, 1),<\/p>\n

MID(HEX(journey), 18, 1),
\n MID(HEX(journey), 17, 1),<\/p>\n

MID(HEX(journey), 20, 1),
\n MID(HEX(journey), 19, 1),<\/p>\n

MID(HEX(journey), 22, 1),
\n MID(HEX(journey), 21, 1),<\/p>\n

MID(HEX(journey), 24, 1),
\n MID(HEX(journey), 23, 1),<\/p>\n

MID(HEX(journey), 26, 1),
\n MID(HEX(journey), 25, 1),<\/p>\n

MID(HEX(journey), 28, 1),
\n MID(HEX(journey), 27, 1),<\/p>\n

MID(HEX(journey), 30, 1),
\n MID(HEX(journey), 29, 1),<\/p>\n

MID(HEX(journey), 32, 1),
\n MID(HEX(journey), 31, 1)
\n )
\n);<\/p>\n

<\/code><\/p>\n

\u4f69\u670d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6211\u66fe\u7ecf\u5199\u8fc7\u4e00\u7bc7\u5173\u4e8ephp \u4e8c\u8fdb\u5236\u6253\u5305\u7684\u53c2\u6570h\u548cH\u641e\u9519\u9020\u6210\u7684\u6570\u636e\u5f55\u5165\u9519\u8bef\u3002 \u5bf9\u4e8e\u5df2 … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-451","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=451"}],"version-history":[{"count":1,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions"}],"predecessor-version":[{"id":452,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions\/452"}],"wp:attachment":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}