{"id":99,"date":"2023-05-29T16:46:19","date_gmt":"2023-05-29T08:46:19","guid":{"rendered":"https:\/\/jiachen.de.cool\/blog\/?p=99"},"modified":"2023-05-29T21:09:01","modified_gmt":"2023-05-29T13:09:01","slug":"%e5%b8%a6%e5%85%b3%e9%94%ae%e5%ad%97%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"https:\/\/jiachen.de.cool\/blog\/2023\/05\/29\/%e5%b8%a6%e5%85%b3%e9%94%ae%e5%ad%97%e6%9f%a5%e8%af%a2\/","title":{"rendered":"\u5e26\u5173\u952e\u5b57\u67e5\u8be2"},"content":{"rendered":"\n
    \n
  1. \u5e26\u5173\u952e\u5b57WHERE\u7684\u67e5\u8be2\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>=’\u67d0\u67d0’;<\/li>\n\n\n\n
  2. \u5e26\u5173\u952e\u5b57IN\u7684\u67e5\u8be2\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>in(‘\u67d0\u67d0’,’\u67d0\u67d01′);<\/li>\n\n\n\n
  3. \u5e26\u5173\u952e\u5b57BETWEEN AND\u7684\u8303\u56f4\u67e5\u8be2\uff08\u95ed\u533a\u95f4\uff09\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>between’\u67d0\u67d0’and’\u67d0\u67d02\u2018;<\/li>\n\n\n\n
  4. \u5e26\u5173\u952e\u5b57LIKE\u7684\u5b57\u7b26\u5339\u914d\u67e5\u8be2\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>like’\u67d0%’;<\/li>\n\n\n\n
  5. \u5e26\u5173\u952e\u5b57IS NULL\u7a7a\u503c\u67e5\u8be2\u6216IS NOT NULL\u975e\u7a7a\u503c\u67e5\u8be2\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>IS NULL;<\/li>\n\n\n\n
  6. \u5e26\u5173\u952e\u5b57AND\u7684\u591a\u6761\u4ef6\u67e5\u8be2\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>=’\u67d0\u67d0’ and <\u5b57\u6bb5\u540d1>=’\u67d0\u67d01′;<\/li>\n\n\n\n
  7. \u5e26\u5173\u952e\u5b57OR\u7684\u591a\u6761\u4ef6\u67e5\u8be2\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>where<\u5b57\u6bb5\u540d>=’\u67d0\u67d0’ or <\u5b57\u6bb5\u540d1>=’\u67d0\u67d01′;<\/li>\n\n\n\n
  8. \u7528\u5173\u952e\u5b57DISTINCT\u53bb\u9664\u7ed3\u679c\u96c6\u91cd\u590d\u884c\uff0c\u8bed\u6cd5select distinct<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>;<\/li>\n\n\n\n
  9. \u7528\u5173\u952e\u5b57ORDER BY\u5bf9\u67e5\u8be2\u7ed3\u679c\u6392\u5e8f\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>order by<\u5b57\u6bb5\u540d>asc\u6216desc;<\/li>\n\n\n\n
  10. \u7528\u5173\u952e\u5b57LIMIT\u9650\u5236\u67e5\u8be2\u7ed3\u679c\u7684\u6570\u91cf\uff0c\u8bed\u6cd5select<\u5b57\u6bb5\u540d>from<\u8868\u6216\u89c6\u56fe\u540d>limit 1;<\/li>\n<\/ol>\n\n\n\n
    mysql> select * from houses;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.01 sec)\n\nmysql> select * from houses where purchasing_year='1998';\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year in ('1997','1998','1999');\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year between '1996' and '1997';\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year like '199%';\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year like '1997';\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year like \"1%\";\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year like '%19';\nEmpty set (0.00 sec)\n\nmysql> select * from houses where purchasing_year like '%97';\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses where purchasing_year is null;\nEmpty set (0.00 sec)\n\nmysql> select * from houses where purchasing_year is not null;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql> select * from houses where name='\u7532' and purchasing_year='1997';\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\n\nmysql> select * from houses where name='\u4e59' or (house_location='\u5929\u6cb3' and purcha\nsing_year='1997');\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select name from houses;\n+------+\n| name |\n+------+\n| \u7532   |\n| \u7532   |\n+------+\n2 rows in set (0.00 sec)\n\nmysql> select distinct name from houses;\n+------+\n| name |\n+------+\n| \u7532   |\n+------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses order by purchasing_year asc;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql> select * from houses order by purchasing_year desc;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1998            |\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql> select * from houses limit 1;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses limit 1,1;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n1 row in set (0.00 sec)\n\nmysql> select * from houses limit 0,2;\n+------+----------------+-----------------+\n| name | house_location | purchasing_year |\n+------+----------------+-----------------+\n| \u7532   | \u5929\u6cb3           | 1997            |\n| \u7532   | \u5929\u6cb3           | 1998            |\n+------+----------------+-----------------+\n2 rows in set (0.00 sec)\n\nmysql>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[16,9],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-16","tag-9"],"_links":{"self":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/comments?post=99"}],"version-history":[{"count":4,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":103,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/posts\/99\/revisions\/103"}],"wp:attachment":[{"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/media?parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/categories?post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jiachen.de.cool\/blog\/wp-json\/wp\/v2\/tags?post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}