{"id":7368,"date":"2023-11-29T15:58:05","date_gmt":"2023-11-29T07:58:05","guid":{"rendered":"http:\/\/www.liugon.com\/blog\/?p=7368"},"modified":"2023-11-30T16:40:56","modified_gmt":"2023-11-30T08:40:56","slug":"%e7%bb%a7%e7%bb%ad%e8%b0%88-select-%e8%af%ad%e5%8f%a5-%e3%80%90%e4%b8%8b%e3%80%91","status":"publish","type":"post","link":"http:\/\/www.liugon.com\/blog\/7368.html","title":{"rendered":"\u7ee7\u7eed\u8c08 select \u8bed\u53e5 \u3010\u4e0b\u3011"},"content":{"rendered":"

\u524d\u8a00<\/h3>\n

\u5d3d\u5d3d\u665a\u4e0a\u6253\u7535\u8bdd\u8bf4\uff1a\u5f20A,\u674eB\u540c\u5b66\u56e0\u4e3a\u5979\u548c\u738bC\u73a9\u5c31\u4e0d\u65ad\u5185\u6db5\u5979\uff0c\u5f00\u59cb\u5979\u8fd8\u5f00\u73a9\u7b11\u548c\u5979\u4eec\u5bf9\u5e94\uff0c\u540e\u6765\u4ed6\u4eec\u5c31\u4e0d\u65ad\u52a0\u7801\uff0c\u6211\u5d3d\u5c31\u4e0d\u548c\u4ed6\u4eec\u73a9\u4e86\uff0c\u5979\u8fd8\u8fd8\u8981\u4e92\u9001\u7684\u4e1c\u897f\u8981\u56de\u53bb\u4e86\u3002\u5d3d\u5e76\u5bf9\u6211\u8bf4\uff1a\u89c9\u7684\u8fd9\u662f\u574f\u4e8b\u4e5f\u662f\u597d\u4e8b\uff0c\u574f\u4e8b\u662f\u5931\u53bb\u4e86\u4e24\u4e2a\u670b\u53cb\uff0c\u597d\u4e8b\u662f\u4e0d\u7528\u518d\u548c\u8fd9\u6837\u7684\u4eba\u6df1\u4ea4\u4f5c\u670b\u53cb\u4e86\uff08\u7b97\u662f\u8ba4\u6e05\u5979\u4eec\u7684\u610f\u601d\uff09\u3002
\n\u6211\u5f88\u5f00\u5fc3\u5979\u80fd\u6709\u8fd9\u4e2a\u7684\u8ba4\u77e5\uff0c\u5728\u5f20A\u548c\u674eB\u7684\u540c\u5b66\u773c\u91cc\uff0c\u548c\u4ed6\u4eec\u73a9\u7684\u5c31\u4e0d\u8bb8\u518d\u548c\u522b\u7684\u540c\u5b66\u73a9\uff0c\u6211\u5d3d\u4f5c\u51fa\u4e86\u660e\u667a\u7684\u9009\u62e9\uff0c\u6ca1\u6709\u88ab\u4ed6\u4eec\u5708\u6b7b\u3002\u6211\u77e5\u9053\u8fd9\u4e2d\u521d\u4e2d\u5b66\u751f\u5708\u662f\u5e38\u6709\u7684\u4e8b\uff0c\u4f46\u6562\u8df3\u51fa\u6765\u5e76\u6709\u81ea\u5df1\u7684\u5224\u65ad\u6211\u611f\u89c9\u6bd4\u5979\u8003\u6ee1\u5206\u6211\u8fd8\u5f00\u5fc3\u3002<\/p>\n

Order by\u56de\u987e<\/h3>\n

\u6ca1\u770b\u8fc7\u4e0a\u7684\uff0c\u53ef\u4ee5\u5148\u770b\u300a40\u5c81\u987f\u609f\u7684select * order by\u8bed\u53e5<\/a>\u300b \u8fd9\u6761SQL\u547d\u4ee4\u5f71\u54cd\u4e86\u6211\u4e00\u751f\uff0c40\u5c81\u4e4b\u524d\u9760order by \u6d3b\u7740\uff0c\u53ef\u4ee5\u7b80\u5355\u5f52\u7eb3\u4e3a\u6309\u4ed6\u4eba\u613f\u610f\u6d3b\u7740\uff0c\u6bd4\u5982\uff1a
\n\u8003\u4e2a\u597d\u6210\u7ee9\u53d6\u5f97\u597d\u6392\u540d\u9700\u8981order by
\n\u8003\u4e2a\u597d\u5b66\u6821\u9700\u8981order by
\n\u6c76\u5ddd\u6350\u6b3e\uff0c\u7a77B\u7684\u6211\u4e5f\u4e0d\u8f9c\u8d1f\u56fd\u4eba\u81ea\u8c6a\uff0c\u6350\u5c31\u5bf9\u4e86\uff1b
\nGj\u5ba3\u4f20\u4e2d\u7f8e\u662f\u592b\u59bb\uff0c\u6551\u7f8e\u56fd\u5c31\u662f\u6551\u81ea\u5df1\uff0c\u5bcc\u5f3a\uff0c\u6c11\u4e3b\uff0c\u81ea\u7531\u558a\u8d77\u6765\uff1b
\n\u66f4\u522b\u8bf4\u7f51\u7edc\u8fd0\u8425\u4e2d\u7684ober by \u66f4\u662f\u6211\u5728\u804c\u573a\u4e0a\u7acb\u8db3\u7684\u6838\u5fc3\uff0c\u6709\u4e86\u8fd9\u4e2a\u6838\u5fc3\u903b\u8f91\uff0c\u65e0\u8bba\u662fSEO\u3001\u963f\u91cc\u5df4\u5df4\u3001\u8fd8\u662f\u77ed\u89c6\u9891\u8425\u9500\uff0c\u90fd\u80fd\u8ba9\u6211\u5feb\u901f\u6293\u4f4f\u8fd0\u8425\u6838\u5fc3\uff1b<\/p>\n

…..\u592a\u591a\u592a\u591a….<\/p>\n

\u540e\u6765\uff0c\u8d8a\u5f80\u540e\u8d8a\u611f\u89c9\u4e0d\u5bf9\uff0c\u6211\u603b\u662f\u5728\u522b\u4eba\u7ed9\u753b\u5b9a\u7684\u8303\u56f4\u5185Order by,\u5c31\u50cf\u4e0a\u8fb9\u7684\u5f20A,\u674eB\u540c\u5b66\u4e00\u6837\uff0c\u6211\u4e00\u76f4\u6ca1\u6709\u8df3\u51fa\u8fd9\u4e2a\u5708\u5b50\uff0c\u5728\u201c\u5979\u4eec\u201d\u7ed9\u5b9a\u7684\u8fd9\u4e2a\u5708\u5b50\u91cc\u62fc\u547d\u5377\uff0c\u62fc\u547dorder by \u7ed3\u679c\u5c31\u662f\u518d\u5377\u4e5f\u5377\u4e0d\u51fa\u6765\u6735\u82b1\u513f\u6765<\/p>\n

\u8fdb\u9636Select<\/h3>\n

order by\u8bed\u6cd5\u7684\u4e3b\u8bed\u662f\uff1aselcec \u518d\u56de\u987e\u4e00\u4e0b\u8fd9\u6761SQL\u547d\u4ee4<\/p>\n

select * from tableName where * order by a1,a2..<\/div>\n

\u65e0\u8bba\u518d\u4f1aorder by \u524d\u8fb9\u7684\u5b57\u6bb5\u662f\u81ea\u5df1\u9009\u7684\u8fd8\u662f\u4ed6\u4eba\u7ed9\u9650\u5b9a\u4e86\uff1f
\n\u4f60\u7684\u732e\u8840\u662f\u732e\u7ed9\u9700\u8981\u7684\u4eba\u4e86\uff0c\u8fd8\u662f\u88ab\u67d0\u4e9b\u4eba\u5f53\u4f5c\u5229\u76ca\u7ed9\u5356\u4e86\uff1b
\n\u4f60\u5bf9\u6c76\u5ddd\u7684\u6350\u6b3e\u662f\u5230\u4e86\u9700\u8981\u4eba\u7684\u624b\u91cc\uff0c\u8fd8\u662f\u88ab\u67d0\u4e9b\u4eba\u88ab\u8fc7\u6ee4select\u5230\u90edmm\u5c41\u80a1\u91cc\u4e86\uff1f
\n\u65e2\u7136\u4e2d\u7f8e\u662f\u592b\u59bb\uff0c\u5435\u67b6\u4e5f\u6b63\u5e38\uff0c\u6211\u4e5f\u7406\u89e3\uff0c\u4f46\u4f60\u53ea\u8ba9\u6211\u542c\u4f60\u8bf4\uff0c\u800c\u4e0d\u662f\u770b\u5bf9\u65b9\u8bf4\u4e86\u4ec0\u4e48\u3001\u505a\u4e86\u4ec0\u4e48\uff0c\u8fd8\u8981\u6211\u4e49\u65e0\u53cd\u987e\u7684\u652f\u6301\uff1f
\n\u5b66\u6821\u91cc\u8003\u51fa\u6765\u7684\u597d\u6210\u7ee9\u6709\u6ca1\u6709\u88ab\u4e00\u7eb8\u6587\u4ef6\u8bf4\u662f\u7559\u7ed9\u6d77\u5916\u7559\u5b66\u751f\uff1f\u4f60order by\u4e86\u5e74\u7ea7\u7b2c\u4e00\u540d\u53c8\u6709\u4f55\u610f\u4e49\uff1f<\/p>\n

select\u7684\u8fb9\u754c<\/H3>
\n\u8fd9\u4e2a\u9009\u62e9\u7684\u8fb9\u754c\u4e0d\u8981\u4ea4\u7ed9\u4ed6\u4eec\u6307\u6325\u4e0e\u5f15\u5bfc\uff0c\u5c31\u50cf\u4e0a\u6b21\u6211\u5d3d\u4ed6\u4eec\u5b66\u6821\u4e49\u6350\uff0c\u662f\u6350\u5230\u67d0\u5e73\u53f0\uff0c\u6211\u4e00\u5206\u6ca1\u6709\u6350\uff0c\u6211\u5d3d\u4ed6\u4eec\u73ed\u6bd4\u8f83\u843d\u540e\uff0c\u8fd8\u95ee\u6211\u600e\u4e481\u5206\u4e0d\u6350\uff1f\u6211\u8bf4\uff1a<\/p>\n

\u4f60\u4eec\u73ed\u6709\u56f0\u96be\u7684\u540c\u5b66\uff0c\u6211\u76f4\u63a5\u60f3\u6cd5\u533f\u540d\u7ed9\u94b1\u7ed9\u4ed6\uff0c\u8fd9\u662f\u5e2e\u52a9\u7684\u672c\u610f\u3002\u6350\u7684\u5e73\u53f0\u7ed9\u7684\u4e0d\u77e5\u9053\u7ed9\u4e86\u8c01\uff0c\u4ed6\u4eec\u66f4\u5927\u6982\u7387\u6bd4\u6211\u4eec\u6709\u94b1\u591a\u4e86\uff0c\u8fd9\u5c31\u662f\u6211\u7684Select \u6211\u4e0d\u5728\u4e4e\u4f60\u4eec\u73ed\u8fd9\u65b9\u9762\u6709\u6ca1\u6709\u5f97\u7b2c1\uff0c\u8fd8\u662f\u6700\u540e\uff0c\u4e5f\u4e0d\u5728\u4e4e\u4ed6\u4eec\u8bf4\u6211\u4ec0\u4e48\u3002<\/p><\/blockquote>\n

\u8fd9\u5c31\u662f\u6211\u7684\u7b54\u6848\uff0c\u5c31\u50cf00\u540e\u9009\u62e9\u4e0d\u5a5a\u4e0d\u751f\u513f\uff0c\u8fd9\u4e5f\u662f\u4ed6\u4eec\u7684Select\uff0c\u8c01\u8bf4\u5fc5\u987b\u8981\u7ed3\u5a5a\uff0c\u5fc5\u987b\u8981\u4e70\u623f\u5462\uff1f\u5c24\u5176\u662f\u5728\u4eba\u4e3a\u7684\u9ad8\u623f\u4ef7\u64cd\u63a7\uff0c\u4e0d\u53c2\u4e0e\u8fd9\u4e2a\u6e38\u620f\u4e5f\u662f\u4e00\u4e2aSelect!\u4e00\u4e2a\u826f\u597d\u7684\u4eba\u751f\u4e00\u5b9a\u662f\u9009\u62e9\u8d8a\u6765\u8d8a\u5bbd\uff0c\u8d8a\u6765\u8d8a\u597d\uff0c\u8d8a\u6765\u8d8a\u6c11 \u4e3b\uff0c\u8d8a\u6765\u8d8a\u5bcc\u6709\u3002\u800c\u4e0d\u662f\u8fdb\u4e86\u4ed6\u4eba\u8bbe\u8ba1\u7684\u4e00\u4e2a\u5957\u5b50\uff0c\u51e0\u8f88\u5b50\u51fa\u4e0d\u6765\u3002<\/p>\n

\u6240\u4ee5\uff0c\u6211\u5bf9\u6211\u5d3d\u7684\u9009\u62e9\u8fd8\u662f\u6ee1\u6b23\u6170\u7684~<\/p>\n","protected":false},"excerpt":{"rendered":"

\u8fd9\u4e2a\u9009\u62e9\u7684\u8fb9\u754c\u4e0d\u8981\u4ea4\u7ed9\u4ed6\u4eec\u6307\u6325\u4e0e\u5f15\u5bfc\uff0c\u5c31\u50cf\u4e0a\u6b21\u6211\u5d3d\u4ed6\u4eec\u5b66\u6821\u4e49\u6350\uff0c\u662f\u6350\u5230\u67d0\u5e73\u53f0\uff0c\u6211\u4e00\u5206\u6ca1\u6709\u6350\uff0c\u6211\u5d3d\u4ed6\u4eec\u73ed\u6bd4\u8f83\u843d\u540e\uff0c\u8fd8\u95ee\u6211\u600e\u4e48\u4e0d\u6350\uff0c\u6211\u8bf4\uff1a\u4f60\u4eec\u73ed\u6709\u56f0\u96be\u7684\u540c\u5b66\uff0c\u6211\u76f4\u63a5\u60f3\u6cd5\u533f\u540d\u7ed9\u94b1\u7ed9\u5979\uff0c\u8fd9\u662f\u5e2e\u52a9\u3002\u6350\u7684\u5e73\u53f0\u7ed9\u7684\u4e0d\u77e5\u9053\u7ed9\u4e86\u8c01\uff0c\u4ed6\u4eec\u66f4\u5927\u53ef\u80fd\u6bd4\u6211\u4eec\u6709\u94b1\u591a\u4e86\uff0c\u8fd9\u662f\u6211\u7684Select <\/p>\n","protected":false},"author":1,"featured_media":7144,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[63],"_links":{"self":[{"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/posts\/7368"}],"collection":[{"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/comments?post=7368"}],"version-history":[{"count":8,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/posts\/7368\/revisions"}],"predecessor-version":[{"id":7376,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/posts\/7368\/revisions\/7376"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/media\/7144"}],"wp:attachment":[{"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/media?parent=7368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/categories?post=7368"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.liugon.com\/blog\/wp-json\/wp\/v2\/tags?post=7368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}