{"id":705,"date":"2015-05-29T11:21:50","date_gmt":"2015-05-29T03:21:50","guid":{"rendered":"https:\/\/ai.zhousir.top\/?p=705"},"modified":"2026-08-18T12:09:34","modified_gmt":"2026-08-18T04:09:34","slug":"sql-select-%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/ai.zhousir.top\/?p=705","title":{"rendered":"SQL\u8bed\u53e5\u57fa\u7840"},"content":{"rendered":"
\n

SQL<\/strong> \u662f\u6570\u636e\u5e93\u67e5\u8be2\u8bed\u8a00\uff0c\u80fd\u5b8c\u6210\u5bf9\u6570\u636e\u5e93\u7684\u57fa\u672c\u64cd\u4f5c\uff1a\u521b\u5efa\u3001\u5220\u9664\u3001\u4fee\u6539\u5e93\u548c\u8868\uff0c\u4ee5\u53ca\u5bf9\u8868\u505a\u589e\u3001\u5220\u3001\u6539\u3001\u67e5\u3002\u5ef6\u4f38\u9605\u8bfb\uff1aSQL\u8bed\u53e5\u5b66\u4e60<\/a>\u3002<\/p>\n

<\/p>\n

SQL \u5bf9\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff0cSELECT<\/code> \u7b49\u6548\u4e8e select<\/code>\u3002\u67e5\u8be2\u7ed3\u679c\u5b58\u653e\u5728\u7ed3\u679c\u96c6\u4e2d\u3002<\/p>\n

\u4e00\u3001SELECT \u4e0e DISTINCT<\/h2>\n

SELECT \u7528\u4e8e\u4ece\u8868\u4e2d\u9009\u53d6\u6570\u636e\uff1a<\/p>\n

SELECT \u5217\u540d1, \u5217\u540d2 FROM \u8868\u540d\u79f0\nSELECT * FROM \u8868\u540d\u79f0<\/code><\/pre>\n
\u8868\u4e2d\u53ef\u80fd\u6709\u91cd\u590d\u503c\u3002\u5173\u952e\u8bcd DISTINCT \u53ea\u8fd4\u56de\u552f\u4e00\u4e0d\u540c\u7684\u503c\uff1a<\/p>\n
SELECT DISTINCT \u5217\u540d\u79f0 FROM \u8868\u540d\u79f0<\/code><\/pre>\n
\u4e8c\u3001WHERE\u3001AND\u3001OR<\/h2>\n
\u6709\u6761\u4ef6\u5730\u9009\u53d6\u6570\u636e\u65f6\uff0c\u628a WHERE \u52a0\u5230 SELECT \u540e\u9762\u3002WHERE \u91cc\u53ef\u7528\u7684\u8fd0\u7b97\u7b26\uff1a<\/p>\n\n\n\n\n\n\n\n\n
\u64cd\u4f5c\u7b26<\/th>\n\u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n
= \/ <> \/ !=<\/td>\n\u7b49\u4e8e \/ \u4e0d\u7b49\u4e8e\uff08\u90e8\u5206\u7248\u672c\u7528 !=\uff09<\/td>\n<\/tr>\n
> \/ < \/ >= \/ <=<\/td>\n\u5927\u4e8e \/ \u5c0f\u4e8e \/ \u5927\u4e8e\u7b49\u4e8e \/ \u5c0f\u4e8e\u7b49\u4e8e<\/td>\n<\/tr>\n
BETWEEN<\/td>\n\u5728\u67d0\u4e2a\u8303\u56f4\u5185<\/td>\n<\/tr>\n
LIKE<\/td>\n\u6309\u6a21\u5f0f\u641c\u7d22<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
AND \u8981\u6c42\u4e24\u4e2a\u6761\u4ef6\u90fd\u6210\u7acb\u624d\u663e\u793a\u8bb0\u5f55\uff1bOR \u53ea\u8981\u6709\u4e00\u4e2a\u6210\u7acb\u5c31\u663e\u793a\u3002\u53ef\u7528\u62ec\u53f7\u7ec4\u5408\uff1a<\/p>\n
SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'\nSELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter'\nSELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William') AND LastName='Carter'<\/code><\/pre>\n
\u4e09\u3001ORDER BY \u4e0e\u589e\u5220\u6539<\/h2>\n
ORDER BY \u6309\u6307\u5b9a\u5217\u6392\u5e8f\uff0c\u9ed8\u8ba4\u5347\u5e8f\uff1b\u964d\u5e8f\u7528 DESC\uff0c\u5347\u5e8f\u53ef\u7528 ASC\u3002<\/p>\n
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC\n\nINSERT INTO \u8868\u540d\u79f0 VALUES (\u503c1, \u503c2, ...)\nINSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing')\nINSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees')\n\nUPDATE \u8868\u540d\u79f0 SET \u5217\u540d\u79f0 = \u65b0\u503c WHERE \u5217\u540d\u79f0 = \u67d0\u503c\nUPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'\nUPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'\n\nDELETE FROM \u8868\u540d\u79f0 WHERE \u5217\u540d\u79f0 = \u503c\nDELETE FROM Person WHERE LastName = 'Wilson'\nDELETE FROM table_name   -- \u5220\u9664\u6240\u6709\u884c\uff0c\u52a1\u5fc5\u52a0 WHERE \u9650\u5236<\/code><\/pre>\n
\u56db\u3001BETWEEN \u4e0e LIKE<\/h2>\n
BETWEEN \u2026 AND \u9009\u53d6\u4ecb\u4e8e\u4e24\u4e2a\u503c\u4e4b\u95f4\u7684\u6570\u636e\uff0c\u53ef\u4ee5\u662f\u6570\u503c\u3001\u6587\u672c\u6216\u65e5\u671f\u3002NOT BETWEEN \u53d6\u8303\u56f4\u4e4b\u5916\u3002<\/p>\n
SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'\nSELECT * FROM Persons WHERE LastName NOT BETWEEN 'Adams' AND 'Carter'<\/code><\/pre>\n
LIKE \u5728 WHERE \u4e2d\u6309\u6a21\u5f0f\u641c\u7d22\u3002% \u8868\u793a\u4efb\u610f\u591a\u4e2a\u5b57\u7b26\uff1a<\/p>\n
SELECT * FROM Persons WHERE City LIKE 'N%'     -- \u4ee5 N \u5f00\u5934\nSELECT * FROM Persons WHERE City LIKE '%g'     -- \u4ee5 g \u7ed3\u5c3e\nSELECT * FROM Persons WHERE City LIKE '%lon%' -- \u5305\u542b lon\nSELECT * FROM Persons WHERE City NOT LIKE '%lon%'<\/code><\/pre>\n
\n
\u4e00\u53e5\u8bdd\u603b\u7ed3\uff1aSELECT \u53d6\u6570\uff0cWHERE \u8fc7\u6ee4\uff0cORDER BY \u6392\u5e8f\uff0cINSERT\/UPDATE\/DELETE \u6539\u8868\uff1bBETWEEN \u5b9a\u8303\u56f4\uff0cLIKE \u914d\u6a21\u5f0f\u3002<\/strong><\/p>\n<\/blockquote>\n<\/section>\n","protected":false},"excerpt":{"rendered":"
SQL \u662f\u6570\u636e\u5e93\u67e5\u8be2\u8bed\u8a00\uff0c\u80fd\u5b8c\u6210\u5bf9\u6570\u636e\u5e93\u7684\u57fa\u672c\u64cd\u4f5c\uff1a\u521b\u5efa\u3001\u5220\u9664\u3001\u4fee\u6539\u5e93\u548c\u8868\uff0c\u4ee5\u53ca\u5bf9\u8868\u505a\u589e\u3001\u5220\u3001\u6539\u3001\u67e5\u3002\u5ef6\u4f38\u9605\u8bfb […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[61],"tags":[192,62],"_links":{"self":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/705"}],"collection":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=705"}],"version-history":[{"count":3,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/705\/revisions"}],"predecessor-version":[{"id":725,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/705\/revisions\/725"}],"wp:attachment":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}