{"id":284,"date":"2022-06-10T11:37:09","date_gmt":"2022-06-10T03:37:09","guid":{"rendered":"https:\/\/frogvps.com\/?p=284"},"modified":"2022-06-10T11:37:30","modified_gmt":"2022-06-10T03:37:30","slug":"sql%e8%af%ad%e5%8f%a5%e7%9a%84%e5%88%86%e7%b1%bb%e5%92%8c%e6%9e%84%e6%88%90","status":"publish","type":"post","link":"https:\/\/frogvps.com\/?p=284","title":{"rendered":"SQL\u8bed\u53e5\u7684\u5206\u7c7b\u548c\u6784\u6210"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">SQL\u8bed\u53e5\u5206\u7c7b<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>DDL: Data Defination Language \u6570\u636e\u5b9a\u4e49\u8bed\u8a00\uff1aCREATE\uff0cDROP\uff0cALTER<\/li><li>DML: Data Manipulation Language \u6570\u636e\u64cd\u7eb5\u8bed\u8a00\uff1aINSERT\uff0cDELETE\uff0cUPDATE<\/li><li>DQL\uff1aData Query Language \u6570\u636e\u67e5\u8be2\u8bed\u8a00\uff1aSELECT<\/li><li>DCL\uff1aData Control Language \u6570\u636e\u63a7\u5236\u8bed\u8a00\uff1aGRANT\uff0cREVOKE<\/li><li>TCL\uff1aTransaction Control Language \u4e8b\u52a1\u63a7\u5236\u8bed\u8a00\uff1aCOMMIT\uff0cROLLBACK\uff0cSAVEPOINT<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">SQL\u8bed\u53e5\u6784\u6210<\/h2>\n\n\n\n<p>\u5173\u5065\u5b57Keyword\u7ec4\u6210\u5b50\u53e5clause\uff0c\u591a\u6761clause\u7ec4\u6210\u8bed\u53e5\u3002<\/p>\n\n\n\n<p>\u6bd4\u5982\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * #SELECT\u5b50\u53e5\nFROM products #FROM\u5b50\u53e5\nWHERE price&gt;888 #WHERE\u5b50\u53e5<\/code><\/pre>\n\n\n\n<p>\u4ee5\u4e0aSQL\u8bed\u53e5\u7531\u4e09\u4e2a\u5b50\u53e5\u6784\u6210\uff0cSELECT,FROM\u548cWHERE\u662f\u5173\u952e\u5b57\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u8981\u67e5\u770bSQL\u5e2e\u52a9\uff0c\u76f4\u63a5\u6572HELP \u5173\u952e\u5b57\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; help select<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL\u8bed\u53e5\u5206\u7c7b DDL: Data Defination Language \u6570\u636e\u5b9a\u4e49\u8bed\u8a00\uff1aCREATE\uff0cDROP\uff0cALTER DML: Data Manipulation Language \u6570\u636e\u64cd\u7eb5\u8bed\u8a00\uff1aINSERT\uff0cDELETE\uff0cUPDA&#8230;<\/p>\n","protected":false},"author":1,"featured_media":283,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[36],"topic":[],"class_list":["post-284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-35","tag-mysql"],"_links":{"self":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=284"}],"version-history":[{"count":2,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/284\/revisions"}],"predecessor-version":[{"id":286,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/284\/revisions\/286"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/media\/283"}],"wp:attachment":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=284"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}