{"id":603,"date":"2024-11-23T20:56:32","date_gmt":"2024-11-23T12:56:32","guid":{"rendered":"http:\/\/www.chan.ink\/?p=603"},"modified":"2024-11-24T18:26:45","modified_gmt":"2024-11-24T10:26:45","slug":"%e3%80%90mysql%e3%80%91%e8%bf%9b%e9%98%b6%e8%a1%a5%e5%85%85","status":"publish","type":"post","link":"http:\/\/www.chan.ink\/index.php\/2024\/11\/23\/%e3%80%90mysql%e3%80%91%e8%bf%9b%e9%98%b6%e8%a1%a5%e5%85%85\/","title":{"rendered":"\u3010MySQL\u3011\u901a\u914d\u7b26"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">select * from info,depart  where info.id &gt; 10;   &#8211;\u9002\u5408\u5728\u67e5\u591a\u5f20\u8868\u8fde\u8868\u67e5\u8be2\u65f6\u6307\u5b9a\u65f6\u54ea\u4e2a\u8868\u7684id<br>select * from info where id &gt; 10;       &#8211;\u5355\u8868\u67e5\u8be2\u65f6\u65e0\u9700\u6307\u5b9a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u901a\u914d\u7b26<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">%\u8868\u793an\u4e2a\u5b57\u7b26<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">_\u8868\u793a\u4e00\u4e2a\u5b57\u7b26<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">__\u8868\u793a\u4e24\u4e2a\u5b57\u7b26     &#8211;\u4e24\u4e2a\u4e0b\u5212\u7ebf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from info where name like \"%\u6c9b%\";\nselect * from info where name like \"%\u6c9b\";\nselect * from info where email like \"%@live.com\";\nselect * from info where name like \"\u6b66%\u9f50\";\nselect * from info where name like \"k%y\";\nselect * from info where email like \"wupeiqi%\";\n\n\nselect * from info where email like \"_@live.com\";\nselect * from info where email like \"_upeiqi@live.com\";\nselect * from info where email like \"__peiqi@live.com\";\nselect * from info where email like \"__peiqi_live.co_\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6620\u5c04\uff08\u5c31\u662f\u6307\u5b9a\u5217\u7684\u610f\u601d\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">desc   \u5012\u5e8f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">asc     \u987a\u5e8f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><app-translate-content _nghost-ng-c341168634=\"\" class=\"eusoft-translate-container-span-en ng-star-inserted\"><span _ngcontent-ng-c341168634=\"\" class=\"eusoft-eudic-chrome-extension-translate-content\"><\/span><\/app-translate-content><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL\u6267\u884c\u987a\u5e8f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">where<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">group by<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">having<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">order by<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">limit<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">select age,count(id) from info where id &gt; 2 group by age having count(id) &gt; 1 order by age desc limit 1;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>select * from info,depart where info.id &gt; 10; &#038;#8211 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-603","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/comments?post=603"}],"version-history":[{"count":5,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/603\/revisions"}],"predecessor-version":[{"id":619,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/posts\/603\/revisions\/619"}],"wp:attachment":[{"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/media?parent=603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/categories?post=603"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.chan.ink\/index.php\/wp-json\/wp\/v2\/tags?post=603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}