{"id":1501,"date":"2018-06-04T18:09:22","date_gmt":"2018-06-04T10:09:22","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1501"},"modified":"2018-06-05T18:19:20","modified_gmt":"2018-06-05T10:19:20","slug":"sql%e8%a7%a3%e5%86%b3%e5%88%91%e4%be%a6%e6%8e%a8%e7%90%86%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1501","title":{"rendered":"SQL\u89e3\u51b3\u5211\u4fa6\u63a8\u7406\u95ee\u9898"},"content":{"rendered":"

\u524d\u4e9b\u5929\u770b\u5230\u4e00\u4e2a\u670b\u53cb\u5728\u670b\u53cb\u5708\u91cc\u9762\u8d34\u4e86\u4e2a\u56fe\uff0c\u4e0a\u9762\u662f2018<\/span>\u5e74\u5211\u4fa6\u79d1\u63a8\u7406\u8bd5\u9898\uff0c\u770b\u4e86\u4e00\u4e0b\u9898\u76ee\uff0c\u8fd9\u4e9b\u9898\u76ee\u90fd\u662f\u5f7c\u6b64\u4f9d\u8d56\uff0c\u5f88\u96be\u627e\u5230\u4e00\u4e2a\u9898\u76ee\u4f5c\u4e3a\u5165\u624b\u70b9\u53ef\u4ee5\u8fdb\u4e00\u6b65\u5206\u6790\uff0c\u56e0\u6b64\u53ef\u80fd\u9700\u8981\u7528\u7eb8\u7b14\u914d\u5408\u5927\u91cf\u7684\u5047\u8bbe\u548c\u8bd5\u9519\u624d\u80fd\u7ee7\u7eed\u5b8c\u6210\u3002<\/span><\/p>\n

\u539f\u9898\u5982\u4e0b\uff1a<\/span><\/p>\n

\"\"<\/a>
\n<\/span>\u00a0\u00a0\u00a0 <\/span>\u4e0d\u8fc7\u8fd9\u79cd\u95ee\u9898\u5176\u5b9e\u662fSQL<\/span>\u64c5\u957f\u7684\u9886\u57df\uff0c\u4e8e\u662f\u4e00\u65f6\u624b\u75d2\uff0c\u5199\u4e86\u4e00\u4e2aSQL<\/span>\u8bed\u53e5\uff1a <\/span><\/p>\n

SQL> WITH T AS<\/span><\/p>\n

\u00a0 <\/span>2\u00a0 <\/span>(SELECT ASCII(‘A’) R FROM DUAL<\/span><\/p>\n

\u00a0 <\/span>3\u00a0 <\/span>UNION ALL<\/span><\/p>\n

\u00a0 <\/span>4\u00a0 <\/span>SELECT ASCII(‘B’) FROM DUAL<\/span><\/p>\n

\u00a0 <\/span>5\u00a0 <\/span>UNION ALL<\/span><\/p>\n

\u00a0 <\/span>6\u00a0 <\/span>SELECT ASCII(‘C’) FROM DUAL<\/span><\/p>\n

\u00a0 <\/span>7\u00a0 <\/span>UNION ALL<\/span><\/p>\n

\u00a0 <\/span>8\u00a0 <\/span>SELECT ASCII(‘D’) FROM DUAL), <\/span><\/p>\n

\u00a0 <\/span>9\u00a0 <\/span>RESULT AS<\/span><\/p>\n

\u00a0<\/span>10\u00a0 <\/span>(SELECT T1.R R1, T2.R R2, T3.R R3, T4.R R4, T5.R R5, T6.R R6, T7.R R7, T8.R R8, T9.R R9, T10.R R10, <\/span><\/p>\n

\u00a0<\/span>11\u00a0\u00a0\u00a0\u00a0 <\/span>DECODE(T1.R, ASCII(‘A’), 1, 0) + DECODE(T2.R, ASCII(‘A’), 1, 0) + DECODE(T3.R, ASCII(‘A’), 1, 0) + DECODE(T4.R, ASCII(‘A’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0+ DECODE(T5.R, ASCII(‘A’), 1, 0) + DECODE(T6.R, ASCII(‘A’), 1, 0) + DECODE(T7.R, ASCII(‘A’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>13\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T8.R, ASCII(‘A’), 1, 0) + DECODE(T9.R, ASCII(‘A’), 1, 0) + DECODE(T10.R, ASCII(‘A’), 1, 0) A, <\/span><\/p>\n

\u00a0<\/span>14\u00a0\u00a0\u00a0\u00a0 <\/span>DECODE(T1.R, ASCII(‘B’), 1, 0) + DECODE(T2.R, ASCII(‘B’), 1, 0) + DECODE(T3.R, ASCII(‘B’), 1, 0) + DECODE(T4.R, ASCII(‘B’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T5.R, ASCII(‘B’), 1, 0) + DECODE(T6.R, ASCII(‘B’), 1, 0) + DECODE(T7.R, ASCII(‘B’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T8.R, ASCII(‘B’), 1, 0) + DECODE(T9.R, ASCII(‘B’), 1, 0) + DECODE(T10.R, ASCII(‘B’), 1, 0) B, <\/span><\/p>\n

\u00a0<\/span>17\u00a0\u00a0\u00a0\u00a0 <\/span>DECODE(T1.R, ‘C’, 1, 0) + DECODE(T2.R, ASCII(‘C’), 1, 0) + DECODE(T3.R, ASCII(‘C’), 1, 0) + DECODE(T4.R, ASCII(‘C’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>18\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T5.R, ASCII(‘C’), 1, 0) + DECODE(T6.R, ASCII(‘C’), 1, 0) + DECODE(T7.R, ASCII(‘C’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>19\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T8.R, ASCII(‘C’), 1, 0) + DECODE(T9.R, ASCII(‘C’), 1, 0) + DECODE(T10.R, ASCII(‘C’), 1, 0) C, <\/span><\/p>\n

\u00a0<\/span>20\u00a0\u00a0\u00a0\u00a0 <\/span>DECODE(T1.R, ASCII(‘D’), 1, 0) + DECODE(T2.R, ASCII(‘D’), 1, 0) + DECODE(T3.R, ASCII(‘D’), 1, 0) + DECODE(T4.R, ASCII(‘D’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>21\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T5.R, ASCII(‘D’), 1, 0) + DECODE(T6.R, ASCII(‘D’), 1, 0) + DECODE(T7.R, ASCII(‘D’), 1, 0) <\/span><\/p>\n

\u00a0<\/span>22\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>+ DECODE(T8.R, ASCII(‘D’), 1, 0) + DECODE(T9.R, ASCII(‘D’), 1, 0) + DECODE(T10.R, ASCII(‘D’), 1, 0) D<\/span><\/p>\n

\u00a0<\/span>23\u00a0 <\/span>FROM T T1, T T2, T T3, T T4, T T5, T T6, T T7, T T8, T T9, T T10<\/span><\/p>\n

\u00a0<\/span>24\u00a0 <\/span>WHERE DECODE(CHR(T2.R), ‘A’, ‘C’, ‘B’, ‘D’, ‘C’, ‘A’, ‘B’) = CHR(T5.R)<\/span><\/p>\n

\u00a0<\/span>25\u00a0 <\/span>AND (CASE CHR(T3.R) WHEN ‘A’ THEN LEAST(T2.R, T4.R, T6.R) – GREATEST(T2.R, T4.R, T6.R)<\/span><\/p>\n

\u00a0<\/span>26\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN LEAST(T2.R, T3.R, T4.R) – GREATEST(T2.R, T3.R, T4.R) <\/span><\/p>\n

\u00a0<\/span>27\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN LEAST(T3.R, T4.R, T6.R) – GREATEST(T3.R, T4.R, T6.R)<\/span><\/p>\n

\u00a0<\/span>28\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE LEAST(T2.R, T3.R, T6.R) – GREATEST(T2.R, T3.R, T6.R) END) = 0<\/span><\/p>\n

\u00a0<\/span>29\u00a0 <\/span>AND (CASE CHR(T3.R) WHEN ‘A’ THEN T2.R – T3.R<\/span><\/p>\n

\u00a0<\/span>30\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN T2.R – T6.R <\/span><\/p>\n

\u00a0<\/span>31\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN T3.R – T2.R<\/span><\/p>\n

\u00a0<\/span>32\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE T2.R – T4.R END) != 0<\/span><\/p>\n

\u00a0<\/span>33\u00a0 <\/span>AND (CASE CHR(T4.R) WHEN ‘A’ THEN T1.R – T5.R<\/span><\/p>\n

\u00a0<\/span>34\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN T2.R – T7.R<\/span><\/p>\n

\u00a0<\/span>35\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN T1.R – T9.R<\/span><\/p>\n

\u00a0<\/span>36\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE T6.R – T10.R END) = 0<\/span><\/p>\n

\u00a0<\/span>37\u00a0 <\/span>AND (CASE CHR(T5.R) WHEN ‘A’ THEN T8.R – ASCII(‘A’)<\/span><\/p>\n

\u00a0<\/span>38\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN T4.R – ASCII(‘B’)<\/span><\/p>\n

\u00a0<\/span>39\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN T9.R – ASCII(‘C’)<\/span><\/p>\n

\u00a0<\/span>40\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE T10.R – ASCII(‘D’) END) = 0<\/span><\/p>\n

\u00a0<\/span>41\u00a0 <\/span>AND (CASE CHR(T6.R) WHEN ‘A’ THEN LEAST(T2.R, T4.R, T8.R) – GREATEST(T2.R, T4.R, T8.R)<\/span><\/p>\n

\u00a0<\/span>42\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN LEAST(T1.R, T6.R, T8.R) – GREATEST(T1.R, T6.R, T8.R)<\/span><\/p>\n

\u00a0<\/span>43\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN LEAST(T3.R, T10.R, T8.R) – GREATEST(T3.R, T10.R, T8.R)<\/span><\/p>\n

\u00a0<\/span>44\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE LEAST(T5.R, T9.R, T8.R) – GREATEST(T5.R, T9.R, T8.R) END) = 0<\/span><\/p>\n

\u00a0<\/span>45\u00a0 <\/span>AND (CASE CHR(T8.R) WHEN ‘A’ THEN ABS(T7.R – T1.R)<\/span><\/p>\n

\u00a0<\/span>46\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN ABS(T5.R – T1.R) <\/span><\/p>\n

\u00a0<\/span>47\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN ABS(T2.R – T1.R) <\/span><\/p>\n

\u00a0<\/span>48\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE ABS(T10.R – T1.R) END) != 1<\/span><\/p>\n

\u00a0<\/span>49\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘A’ THEN T1.R – T6.R + T5.R – T6.R ELSE 1 END != 0<\/span><\/p>\n

\u00a0<\/span>50\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘A’ THEN (T1.R – T6.R) * (T5.R – T6.R) ELSE 0 END = 0<\/span><\/p>\n

\u00a0<\/span>51\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘B’ THEN T1.R – T6.R + T5.R – T10.R ELSE 1 END != 0<\/span><\/p>\n

\u00a0<\/span>52\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘B’ THEN (T1.R – T6.R) * (T5.R – T10.R) ELSE 0 END = 0<\/span><\/p>\n

\u00a0<\/span>53\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘C’ THEN T1.R – T6.R + T5.R – T2.R ELSE 1 END != 0<\/span><\/p>\n

\u00a0<\/span>54\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘C’ THEN (T1.R – T6.R) * (T5.R – T2.R) ELSE 0 END = 0<\/span><\/p>\n

\u00a0<\/span>55\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘D’ THEN T1.R – T6.R + T5.R – T9.R ELSE 1 END != 0<\/span><\/p>\n

\u00a0<\/span>56\u00a0 <\/span>AND CASE CHR(T9.R) WHEN ‘D’ THEN (T1.R – T6.R) * (T5.R – T9.R) ELSE 0 END = 0)<\/span><\/p>\n

\u00a0<\/span>57\u00a0 <\/span>SELECT CHR(R1) R1, CHR(R2) R2, CHR(R3) R3, CHR(R4) R4, CHR(R5) R5, <\/span><\/p>\n

\u00a0<\/span>58\u00a0\u00a0\u00a0\u00a0 <\/span>CHR(R6) R6, CHR(R7) R7, CHR(R8) R8, CHR(R9) R9, CHR(R10) R10<\/span><\/p>\n

\u00a0<\/span>59\u00a0 <\/span>FROM RESULT<\/span><\/p>\n

\u00a0<\/span>60\u00a0 <\/span>WHERE (CASE CHR(R7) WHEN ‘A’ THEN C<\/span><\/p>\n

\u00a0<\/span>61\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN B<\/span><\/p>\n

\u00a0<\/span>62\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN A<\/span><\/p>\n

\u00a0<\/span>63\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE D END) = LEAST(A, B, C, D)<\/span><\/p>\n

\u00a0<\/span>64\u00a0 <\/span>AND (CASE CHR(R10) WHEN ‘A’ THEN 3<\/span><\/p>\n

\u00a0<\/span>65\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘B’ THEN 2<\/span><\/p>\n

\u00a0<\/span>66\u00a0\u00a0\u00a0\u00a0 <\/span>WHEN ‘C’ THEN 4<\/span><\/p>\n

\u00a0<\/span>67\u00a0\u00a0\u00a0\u00a0 <\/span>ELSE 1 END) = (GREATEST(A, B, C, D) – LEAST(A, B, C, D));<\/span><\/p>\n

\u00a0<\/span><\/p>\n

R1\u00a0\u00a0 \u00a0\u00a0\u00a0R2\u00a0 \u00a0\u00a0\u00a0\u00a0R3\u00a0\u00a0 \u00a0\u00a0\u00a0R4\u00a0\u00a0 \u00a0\u00a0\u00a0R5\u00a0 \u00a0\u00a0\u00a0\u00a0R6\u00a0\u00a0 \u00a0\u00a0\u00a0R7\u00a0 \u00a0\u00a0\u00a0\u00a0R8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0R9\u00a0 \u00a0\u00a0\u00a0\u00a0R10<\/span><\/p>\n

——- ——- ——- ——- ——- ——- ——- ——- ——- ——-<\/span><\/p>\n

B\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0C\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0A\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0C\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0A\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0C\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0D\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0A\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0B\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0A<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u4e3b\u8981\u662f\u901a\u8fc7WITH<\/span>\u6784\u9020A<\/span>\u3001B<\/span>\u3001C<\/span>\u3001D<\/span>\u56db\u4e2a\u9009\u9879\uff0c\u7136\u540e\u628a\u5341\u9053\u9898\u7684\u6240\u6709\u9009\u9879\u53ef\u80fd\u6027\u7a77\u4e3e\u751f\u6210\uff0c\u7136\u540e\u6309\u7167\u9898\u610f\u901a\u8fc7WHERE<\/span>\u8bed\u53e5\u6765\u8fdb\u884c\u6761\u4ef6\u9650\u5236\uff0c\u9664\u4e86\u7b2c\u4e09\u9898\u548c\u7b2c\u4e5d\u9898\u90fd\u662f\u4e00\u9053\u9898\u5bf9\u5e94\u4e00\u4e2aWHERE <\/span>\u8bed\u53e5\uff0c\u53e6\u5916\u7b2c\u4e03\u9898\u548c\u7b2c\u5341\u9898\u65e0\u6cd5\u5728\u7b2c\u4e00\u5c42\u67e5\u8be2\u4e2d\u83b7\u53d6\uff0c\u9700\u8981\u5728\u7b2c\u4e8c\u5c42\u4e2d\u8fc7\u6ee4\u3002<\/span><\/p>\n

\u867d\u7136\u7528\u4e86\u4e00\u70b9\u6280\u5de7\uff0c\u4f46\u662f\u603b\u7684\u6765\u8bf4\u6ca1\u5565\u6280\u672f\u542b\u91cf\uff0c\u8fd9\u91cc\u5c31\u4e0d\u9010\u4e00\u89e3\u91ca\u4e86\u3002<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u524d\u4e9b\u5929\u770b\u5230\u4e00\u4e2a\u670b\u53cb\u5728\u670b\u53cb\u5708\u91cc\u9762\u8d34\u4e86\u4e2a\u56fe\uff0c\u4e0a\u9762\u662f2018\u5e74\u5211\u4fa6\u79d1\u63a8\u7406\u8bd5\u9898\uff0c\u770b\u4e86\u4e00\u4e0b\u9898\u76ee\uff0c\u8fd9\u4e9b\u9898\u76ee\u90fd\u662f\u5f7c\u6b64\u4f9d\u8d56\uff0c\u5f88\u96be\u627e\u5230\u4e00\u4e2a\u9898\u76ee\u4f5c\u4e3a\u5165\u624b\u70b9\u53ef\u4ee5\u8fdb\u4e00\u6b65\u5206\u6790\uff0c\u56e0\u6b64\u53ef\u80fd\u9700\u8981\u7528\u7eb8\u7b14\u914d\u5408\u5927\u91cf\u7684\u5047\u8bbe\u548c\u8bd5\u9519\u624d\u80fd\u7ee7\u7eed\u5b8c\u6210\u3002 \u539f\u9898\u5982\u4e0b\uff1a \u00a0\u00a0\u00a0 \u4e0d\u8fc7\u8fd9\u79cd\u95ee\u9898\u5176\u5b9e\u662fSQL\u64c5\u957f\u7684\u9886\u57df\uff0c\u4e8e\u662f\u4e00\u65f6\u624b\u75d2\uff0c\u5199\u4e86\u4e00\u4e2aSQL\u8bed\u53e5\uff1a SQL> WITH T AS \u00a0 2\u00a0 (SELECT ASCII(‘A’) R FROM DUAL \u00a0 3\u00a0 UNION ALL \u00a0 4\u00a0 SELECT ASCII(‘B’) FROM DUAL \u00a0 5\u00a0 UNION ALL \u00a0 6\u00a0 SELECT ASCII(‘C’) FROM DUAL \u00a0 7\u00a0 UNION ALL \u00a0 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[593,1292,1293],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-od","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1501"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1501"}],"version-history":[{"count":5,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1501\/revisions"}],"predecessor-version":[{"id":1507,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1501\/revisions\/1507"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}