\n| \u5220\u9664\u5b57\u6bb5<\/td>\n | DROP<\/td>\n | \u5220\u9664\u5b57\u6bb5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n4.4 \u53cd\u5f15\u53f7\u7684\u4f7f\u7528<\/h4>\n\u2b50 \u8001\u5e08\u5f3a\u8c03：\u8868\u540d\u6216\u5b57\u6bb5\u540d\u82e5\u4e0eSQL\u5173\u952e\u5b57\u91cd\u540d，\u76f4\u63a5\u5199\u4f1a\u62a5\u9519\u3002\u7528\u952e\u76d8\u5de6\u4e0a\u89d2\u7684**\u53cd\u5f15\u53f7（`）**\u505a\u8f6c\u4e49，\u649e\u540d\u4e5f\u80fd\u6b63\u5e38\u6267\u884c\u3002<\/p>\n — \u5982\u679c\u8868\u540d\u53ebselect，\u5fc5\u987b\u52a0\u53cd\u5f15\u53f7
\nSELECT * FROM `select`;<\/p>\n \u7b2c\u4e94\u90e8\u5206：DML \u2014 \u6570\u636e\u64cd\u4f5c\u8bed\u8a00<\/h3>\n5.1 \u63d2\u5165\u6570\u636e（INSERT）<\/h4>\n— \u57fa\u672c\u63d2\u5165（id\u81ea\u52a8\u9012\u589e）
\nINSERT INTO student(name, age, sex) VALUES ('\u68a8\u82b1', 25, '\u5973');<\/p>\n — \u63d2\u5165\u591a\u6761
\nINSERT INTO student(name, age) VALUES ('\u5f20\u4e09', 20), ('\u674e\u56db', 21);<\/p>\n 5.2 \u4fee\u6539\u6570\u636e（UPDATE）<\/h4>\n— \u26a0\ufe0f \u5fc5\u987b\u52a0WHERE\u6761\u4ef6
\nUPDATE student SET name='lili12', age=30 WHERE id=4;<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：UPDATE\u5fc5\u987b\u52a0WHERE\u6761\u4ef6，\u5426\u5219\u6574\u5f20\u8868\u6240\u6709\u8bb0\u5f55\u90fd\u4f1a\u88ab\u4fee\u6539！<\/p>\n 5.3 \u5220\u9664\u6570\u636e（DELETE）<\/h4>\n— \u26a0\ufe0f \u5fc5\u987b\u52a0WHERE\u6761\u4ef6
\nDELETE FROM student WHERE id=7;<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：DELETE\u5fc5\u987b\u52a0WHERE\u6761\u4ef6，\u5426\u5219\u6574\u5f20\u8868\u6570\u636e\u5168\u90e8\u5220\u9664！<\/p>\n \u7b2c\u516d\u90e8\u5206：DQL \u2014 \u6570\u636e\u67e5\u8be2\u8bed\u8a00（\u6838\u5fc3）<\/h3>\n6.1 \u57fa\u7840\u67e5\u8be2<\/h4>\n— \u67e5\u8be2\u5168\u90e8\u5b57\u6bb5（*）
\nSELECT * FROM student;<\/p>\n — \u67e5\u8be2\u6307\u5b9a\u5b57\u6bb5（\u591a\u5b57\u6bb5\u7528\u9017\u53f7\u9694\u5f00）
\nSELECT id, name, age, sex FROM student;<\/p>\n — \u53bb\u91cd\u67e5\u8be2
\nSELECT DISTINCT age FROM student;<\/p>\n — \u522b\u540d：AS\u53ef\u7701\u7565
\nSELECT age AS \u5e74\u9f84 FROM student;
\nSELECT age \u5e74\u9f84 FROM student; — \u7701\u7565AS<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：\u67e5\u8be2\u662f\u884c\u7ea7\u904d\u5386，\u6bcf\u884c\u53d6\u5b57\u6bb5\u503c\u3002*\u4ee3\u8868\u5168\u5b57\u6bb5，\u591a\u4e2a\u5b57\u6bb5\u7528\u9017\u53f7\u800c\u975e\u7a7a\u683c\u5206\u9694\u3002AS\u53ef\u7701\u7565，\u7528\u7a7a\u683c\u9694\u5f00\u5373\u53ef\u3002<\/p>\n 6.2 WHERE\u6761\u4ef6\u7b5b\u9009<\/h4>\n\u6bd4\u8f83\u8fd0\u7b97\u7b26：<\/p>\n — \u5927\u4e8e \u5c0f\u4e8e \u7b49\u4e8e
\nSELECT * FROM student WHERE age > 20;
\nSELECT * FROM student WHERE age >= 18;
\nSELECT * FROM student WHERE age = 24;<\/p>\n — \u4e0d\u7b49\u4e8e（\u4e24\u79cd\u5199\u6cd5）
\nSELECT * FROM student WHERE age != 24;
\nSELECT * FROM student WHERE age <> 24; — \u7b49\u4ef7<\/p>\n IN \u4e0e BETWEEN：<\/p>\n — IN：\u503c\u5728\u6307\u5b9a\u96c6\u5408\u4e2d
\nSELECT * FROM student WHERE age IN (18, 31, 28);<\/p>\n — BETWEEN AND：\u95ed\u533a\u95f4（\u542b\u4e24\u7aef）
\nSELECT * FROM student WHERE age BETWEEN 18 AND 28;<\/p>\n — \u5f00\u533a\u95f4（\u4e0d\u542b18\u548c28）
\nSELECT * FROM student WHERE age > 18 AND age < 28;<\/p>\n \u903b\u8f91\u8fd0\u7b97\u7b26：<\/p>\n — AND：\u5fc5\u987b\u540c\u65f6\u6ee1\u8db3
\nSELECT * FROM student WHERE age > 18 AND age <= 28 AND name = '\u674e\u56db';<\/p>\n — OR：\u6ee1\u8db3\u4efb\u4e00\u5373\u53ef
\nSELECT * FROM student WHERE age > 30 OR name = '\u674e\u56db';<\/p>\n — NOT IN：\u4e0d\u5728\u96c6\u5408\u4e2d
\nSELECT * FROM student WHERE age NOT IN (18, 31, 28);<\/p>\n — IS NULL \/ IS NOT NULL：\u5224\u7a7a
\nSELECT * FROM student WHERE age IS NOT NULL;<\/p>\n \u6a21\u7cca\u67e5\u627e（LIKE）：<\/p>\n — _：\u6070\u597d\u4e00\u4f4d\u5b57\u7b26
\nSELECT * FROM student WHERE name LIKE '_a_'; — \u540d\u5b57\u4e3a3\u4f4d，\u4e2d\u95f4\u662fa<\/p>\n — %：\u4efb\u610f\u4f4d\u5b57\u7b26（\u542b0\u4f4d）
\nSELECT * FROM student WHERE name LIKE '%a%'; — \u5305\u542ba\u5373\u53ef
\nSELECT * FROM student WHERE name LIKE 'a%'; — \u4ee5a\u5f00\u5934
\nSELECT * FROM student WHERE name LIKE '%a'; — \u4ee5a\u7ed3\u5c3e<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：LIKE\u4e0d\u52a0\u5360\u4f4d\u7b26\u65f6\u548c\u7b49\u53f7\u6ca1\u533a\u522b\u3002%\u53ef\u5339\u914d\u4efb\u610f\u957f\u5ea6，_\u53ea\u5360\u4e00\u4f4d\u4e0d\u80fd\u7a7a\u3002<\/p>\n 6.3 ORDER BY \u2014 \u6392\u5e8f<\/h4>\n— \u5347\u5e8f（ASC\u53ef\u7701\u7565，\u9ed8\u8ba4）
\nSELECT * FROM student ORDER BY age ASC;
\nSELECT * FROM student ORDER BY age; — \u9ed8\u8ba4\u5347\u5e8f<\/p>\n — \u964d\u5e8f
\nSELECT * FROM student ORDER BY age DESC;<\/p>\n — \u6309\u65e5\u671f\u5012\u5e8f（\u6700\u65b0\u5728\u524d）
\nSELECT * FROM student ORDER BY birth DESC;<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：ASC\u8868\u793a\u5347\u5e8f，\u53ef\u7701\u7565；DESC\u8868\u793a\u964d\u5e8f，\u4e0d\u80fd\u7701\u3002\u6587\u672c\u5b57\u6bb5\u6392\u5e8f\u53d7\u5b57\u7b26\u7f16\u7801\u5f71\u54cd\u3002<\/p>\n 6.4 LIMIT \u2014 \u5206\u9875\u67e5\u8be2<\/h4>\n— \u8bed\u6cd51：LIMIT \u8d77\u59cb\u7d22\u5f15, \u67e5\u8be2\u6761\u6570
\nSELECT * FROM student LIMIT 0, 2; — \u7b2c1\u9875（\u7d22\u5f15\u4ece0\u5f00\u59cb）
\nSELECT * FROM student LIMIT 2, 2; — \u7b2c2\u9875
\nSELECT * FROM student LIMIT 4, 2; — \u7b2c3\u9875<\/p>\n — \u8bed\u6cd52：LIMIT \u6761\u6570 OFFSET \u8d77\u59cb\u7d22\u5f15
\nSELECT * FROM student LIMIT 2 OFFSET 0; — \u7b49\u4ef7\u4e8e LIMIT 0,2<\/p>\n \u5206\u9875\u516c\u5f0f：<\/p>\n — pageSize = \u6bcf\u9875\u6761\u6570 page = \u5f53\u524d\u9875\u7801
\nSELECT * FROM student LIMIT (page – 1) * pageSize, pageSize;<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：\u7d22\u5f15\u548cid\u6ca1\u5173\u7cfb，\u662f\u5bf9WHERE\u7b5b\u9009\u540e\u7684\u7ed3\u679c\u4ece0\u5f00\u59cb\u7f16\u53f7\u3002WHERE\u3001ORDER BY\u3001LIMIT\u540c\u65f6\u7528\u65f6，\u987a\u5e8f\u56fa\u5b9a：WHERE \u2192 ORDER BY \u2192 LIMIT，LIMIT\u6c38\u8fdc\u653e\u6700\u540e\u3002<\/p>\n 6.5 \u805a\u5408\u51fd\u6570<\/h4>\n\u2b50 \u8001\u5e08\u5f3a\u8c03：\u805a\u5408\u51fd\u6570\u662f"\u4e00\u5806\u6570\u636e\u51fa\u4e00\u4e2a\u7ed3\u679c"\u2014\u2014\u628a\u591a\u884c\u6570\u636e\u805a\u5408\u6210\u5355\u4e2a\u503c\u3002<\/p>\n \n\u51fd\u6570\u8bf4\u660e<\/tr>\n \n\n| MAX()<\/td>\n | \u6c42\u6700\u5927\u503c<\/td>\n<\/tr>\n | \n| MIN()<\/td>\n | \u6c42\u6700\u5c0f\u503c<\/td>\n<\/tr>\n | \n| AVG()<\/td>\n | \u6c42\u5e73\u5747\u503c<\/td>\n<\/tr>\n | \n| SUM()<\/td>\n | \u6c42\u548c<\/td>\n<\/tr>\n | \n| COUNT()<\/td>\n | \u7edf\u8ba1\u6570\u91cf（\u4e0d\u7edf\u8ba1\u4e3aNULL\u7684\u8bb0\u5f55）<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n — \u666e\u901a\u67e5\u8be2：\u8fd4\u56de\u6240\u6709\u5e74\u9f84
\nSELECT age FROM student;<\/p>\n — \u805a\u5408\u67e5\u8be2：\u8fd4\u56de\u4e00\u4e2a\u503c
\nSELECT MAX(age) FROM student;
\nSELECT MIN(age) FROM student;
\nSELECT AVG(age) FROM student;
\nSELECT SUM(age) FROM student;<\/p>\n — COUNT\u533a\u522b
\nSELECT COUNT(*) FROM student; — \u7edf\u8ba1\u6240\u6709\u884c\u6570
\nSELECT COUNT(age) FROM student; — \u4e0d\u7edf\u8ba1age\u4e3a\u7a7a\u7684\u8bb0\u5f55<\/p>\n 6.6 GROUP BY \u2014 \u5206\u7ec4<\/h4>\n— \u6309\u73ed\u7ea7\u5206\u7ec4，\u6c42\u6bcf\u73ed\u6700\u5927\u5e74\u9f84
\nSELECT MAX(age), cid FROM student GROUP BY cid;<\/p>\n — \u5206\u7ec4\u524d\u7b5b\u9009（WHERE）
\nSELECT MAX(age), cid FROM student WHERE sex = '\u7537' GROUP BY cid;<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：GROUP BY\u662f"\u5148\u5206\u5806\u3001\u540e\u7edf\u8ba1"\u3002\u5206\u7ec4\u524d\u7528WHERE\u8fc7\u6ee4\u539f\u8868\u6570\u636e，\u5206\u7ec4\u540e\u7528HAVING\u8fc7\u6ee4\u5206\u7ec4\u540e\u7684\u7ed3\u679c\u3002<\/p>\n 6.7 HAVING \u2014 \u5206\u7ec4\u540e\u7b5b\u9009<\/h4>\n— \u5206\u7ec4\u540e\u53ea\u7559\u73ed\u7ea7id=2\u7684\u6570\u636e
\nSELECT MAX(age), cid FROM student WHERE sex = '\u7537' GROUP BY cid HAVING cid = 2;<\/p>\n WHERE vs HAVING：<\/p>\n \n\u5bf9\u6bd4WHEREHAVING<\/tr>\n \n\n| \u6267\u884c\u65f6\u673a<\/td>\n | \u5206\u7ec4\u524d<\/td>\n | \u5206\u7ec4\u540e<\/td>\n<\/tr>\n | \n| \u4f5c\u7528\u5bf9\u8c61<\/td>\n | \u539f\u8868\u8bb0\u5f55<\/td>\n | \u5206\u7ec4\u540e\u7684\u7ed3\u679c<\/td>\n<\/tr>\n | \n| \u80fd\u5426\u7528\u805a\u5408\u51fd\u6570<\/td>\n | \u274c \u4e0d\u80fd<\/td>\n | \u2705 \u80fd<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n6.8 \u5b8c\u6574\u67e5\u8be2\u987a\u5e8f<\/h4>\nSELECT \u5b57\u6bb5
\nFROM \u8868\u540d
\nWHERE \u6761\u4ef6 — 1. \u8fc7\u6ee4\u884c
\nGROUP BY \u5206\u7ec4\u5b57\u6bb5 — 2. \u5206\u7ec4
\nHAVING \u6761\u4ef6 — 3. \u8fc7\u6ee4\u5206\u7ec4
\nORDER BY \u6392\u5e8f\u5b57\u6bb5 — 4. \u6392\u5e8f
\nLIMIT \u8d77\u59cb, \u6570\u91cf; — 5. \u5206\u9875<\/p>\n \u2b50 \u8001\u5e08\u5f3a\u8c03：\u6267\u884c\u987a\u5e8f\u4e3a WHERE \u2192 GROUP BY \u2192 HAVING \u2192 ORDER BY \u2192 LIMIT，\u5404\u5b50\u53e5\u987a\u5e8f\u4e0d\u80fd\u4e71\u3002<\/p>\n \u9644\u5f55\u4e00：\u5b8c\u6574SQL\u793a\u4f8b（ok.sql）<\/h3>\n— \u67e5\u627e
\nSELECT id,name,age,sex FROM student;
\nSELECT * FROM student;<\/p>\n — \u6dfb\u52a0
\nINSERT INTO student(name,age,sex) VALUES('\u68a8\u82b1',25,'\u5973');<\/p>\n — \u4fee\u6539
\nUPDATE student SET name='lili12', age=30 WHERE id=4;<\/p>\n — \u5220\u9664
\nDELETE FROM student WHERE id=7;<\/p>\n — \u67e5\u6570\u91cf
\nSELECT COUNT(*) FROM student;<\/p>\n — \u57fa\u7840\u67e5\u8be2
\nSELECT * FROM student WHERE name='\u68a8\u82b1' AND sex='\u7537';<\/p>\n — \u53bb\u91cd
\nSELECT DISTINCT age FROM student;<\/p>\n — \u522b\u540d
\nSELECT age FROM student s1;<\/p>\n — \u6bd4\u8f83\u8fd0\u7b97\u7b26
\nSELECT * FROM student WHERE age <> 24;<\/p>\n — IN \/ BETWEEN
\nSELECT * FROM student WHERE age IN(18,31,28);
\nSELECT * FROM student WHERE age BETWEEN 18 AND 28;<\/p>\n — \u903b\u8f91\u8fd0\u7b97\u7b26
\nSELECT * FROM student WHERE age>18 AND age<=28 AND name='\u674e\u56db';
\nSELECT * FROM student WHERE age>30 OR name='\u674e\u56db';<\/p>\n — NOT IN \/ IS NOT NULL
\nSELECT * FROM student WHERE age NOT IN(18,31,28);
\nSELECT * FROM student WHERE age IS NOT NULL;<\/p>\n — \u6a21\u7cca\u67e5\u627e
\nSELECT * FROM student WHERE name LIKE '%a%';<\/p>\n — \u5206\u9875\u67e5\u8be2
\nSELECT * FROM student LIMIT 0,2;<\/p>\n — \u6392\u5e8f
\nSELECT * FROM student ORDER BY birth DESC;<\/p>\n — \u7ec4\u5408\u67e5\u8be2
\nSELECT * FROM student WHERE sex='\u7537' ORDER BY birth DESC LIMIT 0,2;<\/p>\n — \u805a\u5408\u51fd\u6570
\nSELECT MAX(age) FROM student;
\nSELECT COUNT(*) FROM student;
\nSELECT COUNT(age) FROM student;<\/p>\n — \u5206\u7ec4
\nSELECT MAX(age), cid FROM student GROUP BY cid;<\/p>\n — WHERE + GROUP BY + HAVING + LIMIT
\nSELECT MAX(age), cid FROM student WHERE sex='\u7537' GROUP BY cid HAVING cid=2 LIMIT 0,1;<\/p>\n","protected":false},"excerpt":{"rendered":" \u7b2c\u4e00\u90e8\u5206：\u6570\u636e\u5e93\u57fa\u78401.1 \u4ec0\u4e48\u662f\u6570\u636e\u5e93\u2b50 \u8001\u5e08\u5f3a\u8c03：\u6570\u636e\u5e93\u662f\u957f\u671f\u5b58\u50a8\u5728\u8ba1\u7b97\u673a\u5185\u7684\u3001\u6709\u7ec4\u7ec7\u7684\u3001\u53ef\u5171\u4eab\u7684\u6570\u636e\u96c6\u5408，\u672c\u8d28\u4e0a\u662f\u4e00\u4e2a\u6587\u4ef6\u7cfb\u7edf\u3002\u548cExcel\u4e0d\u540c，Excel\u968f\u4fbf\u585e\u6570\u636e\u6ca1\u683c\u5f0f\u7ea6\u675f，\u800c\u6570\u636e\u5e93\u5fc5\u987b\u6309\u63d0\u524d\u8bbe\u597d\u7684\u7279\u5b9a\u683c\u5f0f\u5b58\u6570\u636e\u3002\u6570\u636e\u5e93 vs Excel：\u5bf9\u6bd4Excel\u6570\u636e\u5e93\u6570\u636e\u7ea6\u675f\u65e0\u683c\u5f0f\u9650\u5236\u5fc5\u987b\u7b26\u5408\u9884\u8bbe\u8868\u7ed3\u6784\u6570\u636e\u91cf\u9002\u5408\u5c0f\u6570\u636e\u652f\u6301\u6d77\u91cf\u6570\u636e\u5e76\u53d1\u8bbf\u95ee\u5f31\u5f3a\u6570\u636e\u89c4\u8303\u4e0d\u4e25\u683c\u4e25\u683c1.2 \u6570\u636e\u5e93\u5206\u7c7b\u7c7b\u578b\u8bf4\u660e\u4ee3\u8868\u4ea7<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[768],"topic":[],"class_list":["post-100516","post","type-post","status-publish","format-standard","hentry","category-server","tag-sql"],"yoast_head":"\n MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/100516.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u7b2c\u4e00\u90e8\u5206：\u6570\u636e\u5e93\u57fa\u78401.1 \u4ec0\u4e48\u662f\u6570\u636e\u5e93\u2b50 \u8001\u5e08\u5f3a\u8c03：\u6570\u636e\u5e93\u662f\u957f\u671f\u5b58\u50a8\u5728\u8ba1\u7b97\u673a\u5185\u7684\u3001\u6709\u7ec4\u7ec7\u7684\u3001\u53ef\u5171\u4eab\u7684\u6570\u636e\u96c6\u5408，\u672c\u8d28\u4e0a\u662f\u4e00\u4e2a\u6587\u4ef6\u7cfb\u7edf\u3002\u548cExcel\u4e0d\u540c，Excel\u968f\u4fbf\u585e\u6570\u636e\u6ca1\u683c\u5f0f\u7ea6\u675f，\u800c\u6570\u636e\u5e93\u5fc5\u987b\u6309\u63d0\u524d\u8bbe\u597d\u7684\u7279\u5b9a\u683c\u5f0f\u5b58\u6570\u636e\u3002\u6570\u636e\u5e93 vs Excel：\u5bf9\u6bd4Excel\u6570\u636e\u5e93\u6570\u636e\u7ea6\u675f\u65e0\u683c\u5f0f\u9650\u5236\u5fc5\u987b\u7b26\u5408\u9884\u8bbe\u8868\u7ed3\u6784\u6570\u636e\u91cf\u9002\u5408\u5c0f\u6570\u636e\u652f\u6301\u6d77\u91cf\u6570\u636e\u5e76\u53d1\u8bbf\u95ee\u5f31\u5f3a\u6570\u636e\u89c4\u8303\u4e0d\u4e25\u683c\u4e25\u683c1.2 \u6570\u636e\u5e93\u5206\u7c7b\u7c7b\u578b\u8bf4\u660e\u4ee3\u8868\u4ea7\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/100516.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-04T11:04:52+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/100516.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/100516.html\",\"name\":\"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-09-04T11:04:52+00:00\",\"dateModified\":\"2026-09-04T11:04:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/100516.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/100516.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/100516.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/100516.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u7b2c\u4e00\u90e8\u5206：\u6570\u636e\u5e93\u57fa\u78401.1 \u4ec0\u4e48\u662f\u6570\u636e\u5e93\u2b50 \u8001\u5e08\u5f3a\u8c03：\u6570\u636e\u5e93\u662f\u957f\u671f\u5b58\u50a8\u5728\u8ba1\u7b97\u673a\u5185\u7684\u3001\u6709\u7ec4\u7ec7\u7684\u3001\u53ef\u5171\u4eab\u7684\u6570\u636e\u96c6\u5408，\u672c\u8d28\u4e0a\u662f\u4e00\u4e2a\u6587\u4ef6\u7cfb\u7edf\u3002\u548cExcel\u4e0d\u540c，Excel\u968f\u4fbf\u585e\u6570\u636e\u6ca1\u683c\u5f0f\u7ea6\u675f，\u800c\u6570\u636e\u5e93\u5fc5\u987b\u6309\u63d0\u524d\u8bbe\u597d\u7684\u7279\u5b9a\u683c\u5f0f\u5b58\u6570\u636e\u3002\u6570\u636e\u5e93 vs Excel：\u5bf9\u6bd4Excel\u6570\u636e\u5e93\u6570\u636e\u7ea6\u675f\u65e0\u683c\u5f0f\u9650\u5236\u5fc5\u987b\u7b26\u5408\u9884\u8bbe\u8868\u7ed3\u6784\u6570\u636e\u91cf\u9002\u5408\u5c0f\u6570\u636e\u652f\u6301\u6d77\u91cf\u6570\u636e\u5e76\u53d1\u8bbf\u95ee\u5f31\u5f3a\u6570\u636e\u89c4\u8303\u4e0d\u4e25\u683c\u4e25\u683c1.2 \u6570\u636e\u5e93\u5206\u7c7b\u7c7b\u578b\u8bf4\u660e\u4ee3\u8868\u4ea7","og_url":"https:\/\/www.wsisp.com\/helps\/100516.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-09-04T11:04:52+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/100516.html","url":"https:\/\/www.wsisp.com\/helps\/100516.html","name":"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-09-04T11:04:52+00:00","dateModified":"2026-09-04T11:04:52+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/100516.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/100516.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/100516.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL\u6570\u636e\u5e93\u4e0eSQL\u8bed\u8a00\uff1a\u4ece\u6570\u636e\u7c7b\u578b\u5230DQL\u67e5\u8be2\u6838\u5fc3"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/100516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=100516"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/100516\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=100516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=100516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=100516"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=100516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | | |