{"id":191,"date":"2019-10-31T17:32:02","date_gmt":"2019-10-31T09:32:02","guid":{"rendered":"http:\/\/blog.adeying.com\/?p=191"},"modified":"2019-10-31T17:32:50","modified_gmt":"2019-10-31T09:32:50","slug":"mysql%e5%9f%ba%e7%a1%80","status":"publish","type":"post","link":"https:\/\/adeqing.com\/index.php\/2019\/10\/31\/default\/191\/","title":{"rendered":"MySQL\u57fa\u7840"},"content":{"rendered":"<h3 id=\"\u5f00\u59cb\u4f7f\u7528\">\u5f00\u59cb\u4f7f\u7528<\/h3>\n<p>MySQL \u4e3a\u5173\u7cfb\u578b\u6570\u636e\u5e93(Relational Database Management System)\uff0c\u4e00\u4e2a\u5173\u7cfb\u578b\u6570\u636e\u5e93\u7531\u4e00\u4e2a\u6216\u6570\u4e2a\u8868\u683c\u7ec4\u6210, \u5982\u56fe\u6240\u793a\u7684\u4e00\u4e2a\u8868\u683c\uff1a<\/p>\n<ul>\n<li><code>\u8868\u5934(header)<\/code>: \u6bcf\u4e00\u5217\u7684\u540d\u79f0;<\/li>\n<li><code>\u5217(col)<\/code>: \u5177\u6709\u76f8\u540c\u6570\u636e\u7c7b\u578b\u7684\u6570\u636e\u7684\u96c6\u5408;<\/li>\n<li><code>\u884c(row)<\/code>: \u6bcf\u4e00\u884c\u7528\u6765\u63cf\u8ff0\u67d0\u4e2a\u4eba\/\u7269\u7684\u5177\u4f53\u4fe1\u606f;<\/li>\n<li><code>\u503c(value)<\/code>: \u884c\u7684\u5177\u4f53\u4fe1\u606f, \u6bcf\u4e2a\u503c\u5fc5\u987b\u4e0e\u8be5\u5217\u7684\u6570\u636e\u7c7b\u578b\u76f8\u540c;<\/li>\n<li><code>\u952e(key)<\/code>: \u8868\u4e2d\u7528\u6765\u8bc6\u522b\u67d0\u4e2a\u7279\u5b9a\u7684\u4eba\\\u7269\u7684\u65b9\u6cd5, \u952e\u7684\u503c\u5728\u5f53\u524d\u5217\u4e2d\u5177\u6709\u552f\u4e00\u6027\u3002<br \/>\n<h3 id=\"\u767b\u5f55MySQL\">\u767b\u5f55MySQL<\/h3>\n<\/li>\n<\/ul>\n<figure class=\"highlight shell\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">mysql -h 127.0.0.1 -u \u7528\u6237\u540d -p<\/span>\r\n<span class=\"line\">mysql -D \u6240\u9009\u62e9\u7684\u6570\u636e\u5e93\u540d -h \u4e3b\u673a\u540d -u \u7528\u6237\u540d -p<\/span>\r\n<span class=\"line\"><span class=\"meta\">mysql&gt;<\/span> exit # \u9000\u51fa \u4f7f\u7528 \u201cquit;\u201d \u6216 \u201c\\q;\u201d \u4e00\u6837\u7684\u6548\u679c<\/span>\r\n<span class=\"line\"><span class=\"meta\">mysql&gt;<\/span> status;  # \u663e\u793a\u5f53\u524dmysql\u7684version\u7684\u5404\u79cd\u4fe1\u606f<\/span>\r\n<span class=\"line\"><span class=\"meta\">mysql&gt;<\/span> select version(); # \u663e\u793a\u5f53\u524dmysql\u7684version\u4fe1\u606f<\/span>\r\n<span class=\"line\"><span class=\"meta\">mysql&gt;<\/span> show global variables like 'port'; # \u67e5\u770bMySQL\u7aef\u53e3\u53f7<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u521b\u5efa\u6570\u636e\u5e93\">\u521b\u5efa\u6570\u636e\u5e93<\/h3>\n<p>\u5bf9\u4e8e\u8868\u7684\u64cd\u4f5c\u9700\u8981\u5148\u8fdb\u5165\u5e93<code>use \u5e93\u540d;<\/code><\/p>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u521b\u5efa\u4e00\u4e2a\u540d\u4e3a samp_db \u7684\u6570\u636e\u5e93\uff0c\u6570\u636e\u5e93\u5b57\u7b26\u7f16\u7801\u6307\u5b9a\u4e3a gbk<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">create<\/span> <span class=\"keyword\">database<\/span> samp_db <span class=\"built_in\">character<\/span> <span class=\"keyword\">set<\/span> gbk;<\/span>\r\n<span class=\"line\"><span class=\"keyword\">drop<\/span> <span class=\"keyword\">database<\/span> samp_db; <span class=\"comment\">-- \u5220\u9664 \u5e93\u540d\u4e3asamp_db\u7684\u5e93<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">show<\/span> <span class=\"keyword\">databases<\/span>;        <span class=\"comment\">-- \u663e\u793a\u6570\u636e\u5e93\u5217\u8868\u3002<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">use<\/span> samp_db;     <span class=\"comment\">-- \u9009\u62e9\u521b\u5efa\u7684\u6570\u636e\u5e93samp_db<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">show<\/span> <span class=\"keyword\">tables<\/span>;     <span class=\"comment\">-- \u663e\u793asamp_db\u4e0b\u9762\u6240\u6709\u7684\u8868\u540d\u5b57<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">describe<\/span> \u8868\u540d;    <span class=\"comment\">-- \u663e\u793a\u6570\u636e\u8868\u7684\u7ed3\u6784<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">delete<\/span> <span class=\"keyword\">from<\/span> \u8868\u540d; <span class=\"comment\">-- \u6e05\u7a7a\u8868\u4e2d\u8bb0\u5f55<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u521b\u5efa\u6570\u636e\u5e93\u8868\">\u521b\u5efa\u6570\u636e\u5e93\u8868<\/h3>\n<blockquote><p>\u4f7f\u7528 create table \u8bed\u53e5\u53ef\u5b8c\u6210\u5bf9\u8868\u7684\u521b\u5efa, create table \u7684\u5e38\u89c1\u5f62\u5f0f:<br \/>\n\u8bed\u6cd5\uff1acreate table \u8868\u540d\u79f0(\u5217\u58f0\u660e);<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5982\u679c\u6570\u636e\u5e93\u4e2d\u5b58\u5728user_accounts\u8868\uff0c\u5c31\u628a\u5b83\u4ece\u6570\u636e\u5e93\u4e2ddrop\u6389<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DROP<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"keyword\">IF<\/span> <span class=\"keyword\">EXISTS<\/span> <span class=\"string\">`user_accounts`<\/span>;<\/span>\r\n<span class=\"line\"><span class=\"keyword\">CREATE<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"string\">`user_accounts`<\/span> (<\/span>\r\n<span class=\"line\">  <span class=\"string\">`id`<\/span>             <span class=\"built_in\">int<\/span>(<span class=\"number\">100<\/span>) <span class=\"keyword\">unsigned<\/span> <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> AUTO_INCREMENT primary <span class=\"keyword\">key<\/span>,<\/span>\r\n<span class=\"line\">  <span class=\"string\">`password`<\/span>       <span class=\"built_in\">varchar<\/span>(<span class=\"number\">32<\/span>)       <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"string\">''<\/span> <span class=\"keyword\">COMMENT<\/span> <span class=\"string\">'\u7528\u6237\u5bc6\u7801'<\/span>,<\/span>\r\n<span class=\"line\">  <span class=\"string\">`reset_password`<\/span> <span class=\"built_in\">tinyint<\/span>(<span class=\"number\">32<\/span>)       <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"number\">0<\/span> <span class=\"keyword\">COMMENT<\/span> <span class=\"string\">'\u7528\u6237\u7c7b\u578b\uff1a0\uff0d\u4e0d\u9700\u8981\u91cd\u7f6e\u5bc6\u7801\uff1b1-\u9700\u8981\u91cd\u7f6e\u5bc6\u7801'<\/span>,<\/span>\r\n<span class=\"line\">  <span class=\"string\">`mobile`<\/span>         <span class=\"built_in\">varchar<\/span>(<span class=\"number\">20<\/span>)       <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"string\">''<\/span> <span class=\"keyword\">COMMENT<\/span> <span class=\"string\">'\u624b\u673a'<\/span>,<\/span>\r\n<span class=\"line\">  <span class=\"string\">`create_at`<\/span>      <span class=\"built_in\">timestamp<\/span>(<span class=\"number\">6<\/span>)      <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"keyword\">CURRENT_TIMESTAMP<\/span>(<span class=\"number\">6<\/span>),<\/span>\r\n<span class=\"line\">  <span class=\"string\">`update_at`<\/span>      <span class=\"built_in\">timestamp<\/span>(<span class=\"number\">6<\/span>)      <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"keyword\">CURRENT_TIMESTAMP<\/span>(<span class=\"number\">6<\/span>) <span class=\"keyword\">ON<\/span> <span class=\"keyword\">UPDATE<\/span> <span class=\"keyword\">CURRENT_TIMESTAMP<\/span>(<span class=\"number\">6<\/span>),<\/span>\r\n<span class=\"line\">  <span class=\"comment\">-- \u521b\u5efa\u552f\u4e00\u7d22\u5f15\uff0c\u4e0d\u5141\u8bb8\u91cd\u590d<\/span><\/span>\r\n<span class=\"line\">  <span class=\"keyword\">UNIQUE<\/span> <span class=\"keyword\">INDEX<\/span> idx_user_mobile(<span class=\"string\">`mobile`<\/span>)<\/span>\r\n<span class=\"line\">)<\/span>\r\n<span class=\"line\"><span class=\"keyword\">ENGINE<\/span>=<span class=\"keyword\">InnoDB<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"keyword\">CHARSET<\/span>=utf8<\/span>\r\n<span class=\"line\"><span class=\"keyword\">COMMENT<\/span>=<span class=\"string\">'\u7528\u6237\u8868\u4fe1\u606f'<\/span>;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>\u6570\u636e\u7c7b\u578b\u7684\u5c5e\u6027\u89e3\u91ca<\/p>\n<ul>\n<li><code>NULL<\/code>\uff1a\u6570\u636e\u5217\u53ef\u5305\u542bNULL\u503c\uff1b<\/li>\n<li><code>NOT NULL<\/code>\uff1a\u6570\u636e\u5217\u4e0d\u5141\u8bb8\u5305\u542bNULL\u503c\uff1b<\/li>\n<li><code>DEFAULT<\/code>\uff1a\u9ed8\u8ba4\u503c\uff1b<\/li>\n<li><code>PRIMARY<\/code>\uff1aKEY \u4e3b\u952e\uff1b<\/li>\n<li><code>AUTO_INCREMENT<\/code>\uff1a\u81ea\u52a8\u9012\u589e\uff0c\u9002\u7528\u4e8e\u6574\u6570\u7c7b\u578b\uff1b<\/li>\n<li><code>UNSIGNED<\/code>\uff1a\u662f\u6307\u6570\u503c\u7c7b\u578b\u53ea\u80fd\u4e3a\u6b63\u6570\uff1b<\/li>\n<li><code>CHARACTER SET name<\/code>\uff1a\u6307\u5b9a\u4e00\u4e2a\u5b57\u7b26\u96c6\uff1b<\/li>\n<li><code>COMMENT<\/code>\uff1a\u5bf9\u8868\u6216\u8005\u5b57\u6bb5\u8bf4\u660e\uff1b<\/li>\n<\/ul>\n<h3 id=\"\u589e\u5220\u6539\u67e5\">\u589e\u5220\u6539\u67e5<\/h3>\n<h3 id=\"SELECT\">SELECT<\/h3>\n<blockquote><p>SELECT \u8bed\u53e5\u7528\u4e8e\u4ece\u8868\u4e2d\u9009\u53d6\u6570\u636e\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>SELECT \u5217\u540d\u79f0 FROM \u8868\u540d\u79f0<\/code><br \/>\n\u8bed\u6cd5\uff1a<code>SELECT * FROM \u8868\u540d\u79f0<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u8868station\u53d6\u4e2a\u522b\u540d\u53ebs\uff0c\u8868station\u4e2d\u4e0d\u5305\u542b \u5b57\u6bb5id=13\u6216\u800514 \u7684\uff0c\u5e76\u4e14id\u4e0d\u7b49\u4e8e4\u7684 \u67e5\u8be2\u51fa\u6765\uff0c\u53ea\u663e\u793aid<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> s.id <span class=\"keyword\">from<\/span> station s <span class=\"keyword\">WHERE<\/span> <span class=\"keyword\">id<\/span> <span class=\"keyword\">in<\/span> (<span class=\"number\">13<\/span>,<span class=\"number\">14<\/span>) <span class=\"keyword\">and<\/span> <span class=\"keyword\">id<\/span> <span class=\"keyword\">not<\/span> <span class=\"keyword\">in<\/span> (<span class=\"number\">4<\/span>);<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u4ece\u8868 Persons \u9009\u53d6 LastName \u5217\u7684\u6570\u636e<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> LastName <span class=\"keyword\">FROM<\/span> Persons<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u4ece\u8868 users \u9009\u53d6 id=3 \u7684\u6570\u636e\uff0c\u5e76\u53ea\u62c9\u4e00\u6761\u6570\u636e(\u636e\u8bf4\u80fd\u4f18\u5316\u6027\u80fd)<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> <span class=\"keyword\">users<\/span> <span class=\"keyword\">where<\/span> <span class=\"keyword\">id<\/span>=<span class=\"number\">3<\/span> <span class=\"keyword\">limit<\/span> <span class=\"number\">1<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u7ed3\u679c\u96c6\u4e2d\u4f1a\u81ea\u52a8\u53bb\u91cd\u590d\u6570\u636e<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">DISTINCT<\/span> Company <span class=\"keyword\">FROM<\/span> Orders <\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u8868 Persons \u5b57\u6bb5 Id_P \u7b49\u4e8e Orders \u5b57\u6bb5 Id_P \u7684\u503c\uff0c<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u7ed3\u679c\u96c6\u663e\u793a Persons\u8868\u7684 LastName\u3001FirstName\u5b57\u6bb5\uff0cOrders\u8868\u7684OrderNo\u5b57\u6bb5<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> p.LastName, p.FirstName, o.OrderNo <span class=\"keyword\">FROM<\/span> Persons p, Orders o <span class=\"keyword\">WHERE<\/span> p.Id_P = o.Id_P <\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- gbk \u548c utf8 \u4e2d\u82f1\u6587\u6df7\u5408\u6392\u5e8f\u6700\u7b80\u5355\u7684\u529e\u6cd5 <\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- ci\u662f case insensitive, \u5373 \u201c\u5927\u5c0f\u5199\u4e0d\u654f\u611f\u201d<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> tag, <span class=\"keyword\">COUNT<\/span>(tag) <span class=\"keyword\">from<\/span> news <span class=\"keyword\">GROUP<\/span> <span class=\"keyword\">BY<\/span> tag <span class=\"keyword\">order<\/span> <span class=\"keyword\">by<\/span> <span class=\"keyword\">convert<\/span>(tag <span class=\"keyword\">using<\/span> gbk) <span class=\"keyword\">collate<\/span> gbk_chinese_ci;<\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> tag, <span class=\"keyword\">COUNT<\/span>(tag) <span class=\"keyword\">from<\/span> news <span class=\"keyword\">GROUP<\/span> <span class=\"keyword\">BY<\/span> tag <span class=\"keyword\">order<\/span> <span class=\"keyword\">by<\/span> <span class=\"keyword\">convert<\/span>(tag <span class=\"keyword\">using<\/span> utf8) <span class=\"keyword\">collate<\/span> utf8_unicode_ci;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"UPDATE\">UPDATE<\/h3>\n<blockquote><p>Update \u8bed\u53e5\u7528\u4e8e\u4fee\u6539\u8868\u4e2d\u7684\u6570\u636e\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>UPDATE \u8868\u540d\u79f0 SET \u5217\u540d\u79f0 = \u65b0\u503c WHERE \u5217\u540d\u79f0 = \u67d0\u503c<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- update\u8bed\u53e5\u8bbe\u7f6e\u5b57\u6bb5\u503c\u4e3a\u53e6\u4e00\u4e2a\u7ed3\u679c\u53d6\u51fa\u6765\u7684\u5b57\u6bb5<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">update<\/span> <span class=\"keyword\">user<\/span> <span class=\"keyword\">set<\/span> <span class=\"keyword\">name<\/span> = (<span class=\"keyword\">select<\/span> <span class=\"keyword\">name<\/span> <span class=\"keyword\">from<\/span> user1 <span class=\"keyword\">where<\/span> user1 .id = <span class=\"number\">1<\/span> )<\/span>\r\n<span class=\"line\"><span class=\"keyword\">where<\/span> <span class=\"keyword\">id<\/span> = (<span class=\"keyword\">select<\/span> <span class=\"keyword\">id<\/span> <span class=\"keyword\">from<\/span> user2 <span class=\"keyword\">where<\/span> user2 .name=<span class=\"string\">'\u5c0f\u82cf'<\/span>);<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u66f4\u65b0\u8868 orders \u4e2d id=1 \u7684\u90a3\u4e00\u884c\u6570\u636e\u66f4\u65b0\u5b83\u7684 title \u5b57\u6bb5<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">UPDATE<\/span> <span class=\"string\">`orders`<\/span> <span class=\"keyword\">set<\/span> title=<span class=\"string\">'\u8fd9\u91cc\u662f\u6807\u9898'<\/span> <span class=\"keyword\">WHERE<\/span> <span class=\"keyword\">id<\/span>=<span class=\"number\">1<\/span>;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"INSERT\">INSERT<\/h3>\n<blockquote><p>INSERT INTO \u8bed\u53e5\u7528\u4e8e\u5411\u8868\u683c\u4e2d\u63d2\u5165\u65b0\u7684\u884c\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>INSERT INTO \u8868\u540d\u79f0 VALUES (\u503c1, \u503c2,....)<\/code><br \/>\n\u8bed\u6cd5\uff1a<code>INSERT INTO \u8868\u540d\u79f0 (\u52171, \u52172,...) VALUES (\u503c1, \u503c2,....)<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5411\u8868 Persons \u63d2\u5165\u4e00\u6761\u5b57\u6bb5 LastName = JSLite \u5b57\u6bb5 Address = shanghai<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">INSERT<\/span> <span class=\"keyword\">INTO<\/span> Persons (LastName, Address) <span class=\"keyword\">VALUES<\/span> (<span class=\"string\">'JSLite'<\/span>, <span class=\"string\">'shanghai'<\/span>);<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5411\u8868 meeting \u63d2\u5165 \u5b57\u6bb5 a=1 \u548c\u5b57\u6bb5 b=2<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">INSERT<\/span> <span class=\"keyword\">INTO<\/span> meeting <span class=\"keyword\">SET<\/span> a=<span class=\"number\">1<\/span>,b=<span class=\"number\">2<\/span>;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- <\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- SQL\u5b9e\u73b0\u5c06\u4e00\u4e2a\u8868\u7684\u6570\u636e\u63d2\u5165\u5230\u53e6\u5916\u4e00\u4e2a\u8868\u7684\u4ee3\u7801<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5982\u679c\u53ea\u5e0c\u671b\u5bfc\u5165\u6307\u5b9a\u5b57\u6bb5\uff0c\u53ef\u4ee5\u7528\u8fd9\u79cd\u65b9\u6cd5\uff1a<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- INSERT INTO \u76ee\u6807\u8868 (\u5b57\u6bb51, \u5b57\u6bb52, ...) SELECT \u5b57\u6bb51, \u5b57\u6bb52, ... FROM \u6765\u6e90\u8868;<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">INSERT<\/span> <span class=\"keyword\">INTO<\/span> orders (user_account_id, title) <span class=\"keyword\">SELECT<\/span> m.user_id, m.title <span class=\"keyword\">FROM<\/span> meeting m <span class=\"keyword\">where<\/span> m.id=<span class=\"number\">1<\/span>;<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u5411\u8868 charger \u63d2\u5165\u4e00\u6761\u6570\u636e\uff0c\u5df2\u5b58\u5728\u5c31\u5bf9\u8868 charger \u66f4\u65b0 `type`,`update_at` \u5b57\u6bb5\uff1b<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">INSERT<\/span> <span class=\"keyword\">INTO<\/span> <span class=\"string\">`charger`<\/span> (<span class=\"string\">`id`<\/span>,<span class=\"string\">`type`<\/span>,<span class=\"string\">`create_at`<\/span>,<span class=\"string\">`update_at`<\/span>) <span class=\"keyword\">VALUES<\/span> (<span class=\"number\">3<\/span>,<span class=\"number\">2<\/span>,<span class=\"string\">'2017-05-18 11:06:17'<\/span>,<span class=\"string\">'2017-05-18 11:06:17'<\/span>) <span class=\"keyword\">ON<\/span> <span class=\"keyword\">DUPLICATE<\/span> <span class=\"keyword\">KEY<\/span> <span class=\"keyword\">UPDATE<\/span> <span class=\"string\">`id`<\/span>=<span class=\"keyword\">VALUES<\/span>(<span class=\"string\">`id`<\/span>), <span class=\"string\">`type`<\/span>=<span class=\"keyword\">VALUES<\/span>(<span class=\"string\">`type`<\/span>), <span class=\"string\">`update_at`<\/span>=<span class=\"keyword\">VALUES<\/span>(<span class=\"string\">`update_at`<\/span>);<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"DELETE\">DELETE<\/h3>\n<blockquote><p>DELETE \u8bed\u53e5\u7528\u4e8e\u5220\u9664\u8868\u4e2d\u7684\u884c\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>DELETE FROM \u8868\u540d\u79f0 WHERE \u5217\u540d\u79f0 = \u503c<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5728\u4e0d\u5220\u9664table_name\u8868\u7684\u60c5\u51b5\u4e0b\u5220\u9664\u6240\u6709\u7684\u884c\uff0c\u6e05\u7a7a\u8868\u3002<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DELETE<\/span> <span class=\"keyword\">FROM<\/span> table_name<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u6216\u8005<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DELETE<\/span> * <span class=\"keyword\">FROM<\/span> table_name<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5220\u9664 Person\u8868\u5b57\u6bb5 LastName = 'JSLite' <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DELETE<\/span> <span class=\"keyword\">FROM<\/span> Person <span class=\"keyword\">WHERE<\/span> LastName = <span class=\"string\">'JSLite'<\/span> <\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5220\u9664 \u8868meeting id \u4e3a2\u548c3\u7684\u4e24\u6761\u6570\u636e<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DELETE<\/span> <span class=\"keyword\">from<\/span> meeting <span class=\"keyword\">where<\/span> <span class=\"keyword\">id<\/span> <span class=\"keyword\">in<\/span> (<span class=\"number\">2<\/span>,<span class=\"number\">3<\/span>);<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"WHERE\">WHERE<\/h3>\n<blockquote><p>WHERE \u5b50\u53e5\u7528\u4e8e\u89c4\u5b9a\u9009\u62e9\u7684\u6807\u51c6\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>SELECT \u5217\u540d\u79f0 FROM \u8868\u540d\u79f0 WHERE \u5217 \u8fd0\u7b97\u7b26 \u503c<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u4ece\u8868 Persons \u4e2d\u9009\u51fa Year \u5b57\u6bb5\u5927\u4e8e 1965 \u7684\u6570\u636e<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> Persons <span class=\"keyword\">WHERE<\/span> <span class=\"keyword\">Year<\/span>&gt;<span class=\"number\">1965<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"AND-\u548c-OR\">AND \u548c OR<\/h3>\n<blockquote><p>AND &#8211; \u5982\u679c\u7b2c\u4e00\u4e2a\u6761\u4ef6\u548c\u7b2c\u4e8c\u4e2a\u6761\u4ef6\u90fd\u6210\u7acb\uff1b<br \/>\nOR &#8211; \u5982\u679c\u7b2c\u4e00\u4e2a\u6761\u4ef6\u548c\u7b2c\u4e8c\u4e2a\u6761\u4ef6\u4e2d\u53ea\u8981\u6709\u4e00\u4e2a\u6210\u7acb\uff1b<\/p><\/blockquote>\n<h3 id=\"AND\">AND<\/h3>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5220\u9664 meeting \u8868\u5b57\u6bb5 <\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- id=2 \u5e76\u4e14 user_id=5 \u7684\u6570\u636e  \u548c<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- id=3 \u5e76\u4e14 user_id=6 \u7684\u6570\u636e <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DELETE<\/span> <span class=\"keyword\">from<\/span> meeting <span class=\"keyword\">where<\/span> <span class=\"keyword\">id<\/span> <span class=\"keyword\">in<\/span> (<span class=\"number\">2<\/span>,<span class=\"number\">3<\/span>) <span class=\"keyword\">and<\/span> user_id <span class=\"keyword\">in<\/span> (<span class=\"number\">5<\/span>,<span class=\"number\">6<\/span>);<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u4f7f\u7528 AND \u6765\u663e\u793a\u6240\u6709\u59d3\u4e3a \"Carter\" \u5e76\u4e14\u540d\u4e3a \"Thomas\" \u7684\u4eba\uff1a<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> Persons <span class=\"keyword\">WHERE<\/span> FirstName=<span class=\"string\">'Thomas'<\/span> <span class=\"keyword\">AND<\/span> LastName=<span class=\"string\">'Carter'<\/span>;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"OR\">OR<\/h3>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u4f7f\u7528 OR \u6765\u663e\u793a\u6240\u6709\u59d3\u4e3a \"Carter\" \u6216\u8005\u540d\u4e3a \"Thomas\" \u7684\u4eba\uff1a<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> Persons <span class=\"keyword\">WHERE<\/span> firstname=<span class=\"string\">'Thomas'<\/span> <span class=\"keyword\">OR<\/span> lastname=<span class=\"string\">'Carter'<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"ORDER-BY\">ORDER BY<\/h3>\n<blockquote><p>\u8bed\u53e5\u9ed8\u8ba4\u6309\u7167\u5347\u5e8f\u5bf9\u8bb0\u5f55\u8fdb\u884c\u6392\u5e8f\u3002<br \/>\n<code>ORDER BY<\/code>\u00a0&#8211; \u8bed\u53e5\u7528\u4e8e\u6839\u636e\u6307\u5b9a\u7684\u5217\u5bf9\u7ed3\u679c\u96c6\u8fdb\u884c\u6392\u5e8f\u3002<br \/>\n<code>DESC<\/code>\u00a0&#8211; \u6309\u7167\u964d\u5e8f\u5bf9\u8bb0\u5f55\u8fdb\u884c\u6392\u5e8f\u3002<br \/>\n<code>ASC<\/code>\u00a0&#8211; \u6309\u7167\u987a\u5e8f\u5bf9\u8bb0\u5f55\u8fdb\u884c\u6392\u5e8f\u3002<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- Company\u5728\u8868Orders\u4e2d\u4e3a\u5b57\u6bcd\uff0c\u5219\u4f1a\u4ee5\u5b57\u6bcd\u987a\u5e8f\u663e\u793a\u516c\u53f8\u540d\u79f0<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> Company, OrderNumber <span class=\"keyword\">FROM<\/span> Orders <span class=\"keyword\">ORDER<\/span> <span class=\"keyword\">BY<\/span> Company<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u540e\u9762\u8ddf\u4e0a DESC \u5219\u4e3a\u964d\u5e8f\u663e\u793a<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> Company, OrderNumber <span class=\"keyword\">FROM<\/span> Orders <span class=\"keyword\">ORDER<\/span> <span class=\"keyword\">BY<\/span> Company <span class=\"keyword\">DESC<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- Company\u4ee5\u964d\u5e8f\u663e\u793a\u516c\u53f8\u540d\u79f0\uff0c\u5e76OrderNumber\u4ee5\u987a\u5e8f\u663e\u793a<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> Company, OrderNumber <span class=\"keyword\">FROM<\/span> Orders <span class=\"keyword\">ORDER<\/span> <span class=\"keyword\">BY<\/span> Company <span class=\"keyword\">DESC<\/span>, OrderNumber <span class=\"keyword\">ASC<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"IN\">IN<\/h3>\n<blockquote><p>IN &#8211; \u64cd\u4f5c\u7b26\u5141\u8bb8\u6211\u4eec\u5728 WHERE \u5b50\u53e5\u4e2d\u89c4\u5b9a\u591a\u4e2a\u503c\u3002<br \/>\nIN &#8211; \u64cd\u4f5c\u7b26\u7528\u6765\u6307\u5b9a\u8303\u56f4\uff0c\u8303\u56f4\u4e2d\u7684\u6bcf\u4e00\u6761\uff0c\u90fd\u8fdb\u884c\u5339\u914d\u3002IN\u53d6\u503c\u89c4\u5f8b\uff0c\u7531\u9017\u53f7\u5206\u5272\uff0c\u5168\u90e8\u653e\u7f6e\u62ec\u53f7\u4e2d\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>SELECT \"\u5b57\u6bb5\u540d\"FROM \"\u8868\u683c\u540d\"WHERE \"\u5b57\u6bb5\u540d\" IN ('\u503c\u4e00', '\u503c\u4e8c', ...);<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u4ece\u8868 Persons \u9009\u53d6 \u5b57\u6bb5 LastName \u7b49\u4e8e Adams\u3001Carter<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> Persons <span class=\"keyword\">WHERE<\/span> LastName <span class=\"keyword\">IN<\/span> (<span class=\"string\">'Adams'<\/span>,<span class=\"string\">'Carter'<\/span>)<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"NOT\">NOT<\/h3>\n<blockquote><p>NOT &#8211; \u64cd\u4f5c\u7b26\u603b\u662f\u4e0e\u5176\u4ed6\u64cd\u4f5c\u7b26\u4e00\u8d77\u4f7f\u7528\uff0c\u7528\u5728\u8981\u8fc7\u6ee4\u7684\u524d\u9762\u3002<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"keyword\">SELECT<\/span> vend_id, prod_name <span class=\"keyword\">FROM<\/span> Products <span class=\"keyword\">WHERE<\/span> <span class=\"keyword\">NOT<\/span> vend_id = <span class=\"string\">'DLL01'<\/span> <span class=\"keyword\">ORDER<\/span> <span class=\"keyword\">BY<\/span> prod_name;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"UNION\">UNION<\/h3>\n<blockquote><p>UNION &#8211; \u64cd\u4f5c\u7b26\u7528\u4e8e\u5408\u5e76\u4e24\u4e2a\u6216\u591a\u4e2a SELECT \u8bed\u53e5\u7684\u7ed3\u679c\u96c6\u3002<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5217\u51fa\u6240\u6709\u5728\u4e2d\u56fd\u8868\uff08Employees_China\uff09\u548c\u7f8e\u56fd\uff08Employees_USA\uff09\u7684\u4e0d\u540c\u7684\u96c7\u5458\u540d<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> E_Name <span class=\"keyword\">FROM<\/span> Employees_China <span class=\"keyword\">UNION<\/span> <span class=\"keyword\">SELECT<\/span> E_Name <span class=\"keyword\">FROM<\/span> Employees_USA<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u5217\u51fa meeting \u8868\u4e2d\u7684 pic_url\uff0c<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- station \u8868\u4e2d\u7684 number_station \u522b\u540d\u8bbe\u7f6e\u6210 pic_url \u907f\u514d\u5b57\u6bb5\u4e0d\u4e00\u6837\u62a5\u9519<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u6309\u66f4\u65b0\u65f6\u95f4\u6392\u5e8f<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">id<\/span>,pic_url <span class=\"keyword\">FROM<\/span> meeting <span class=\"keyword\">UNION<\/span> <span class=\"keyword\">ALL<\/span> <span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">id<\/span>,number_station <span class=\"keyword\">AS<\/span> pic_url <span class=\"keyword\">FROM<\/span> station  <span class=\"keyword\">ORDER<\/span> <span class=\"keyword\">BY<\/span> update_at;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u901a\u8fc7 UNION \u8bed\u6cd5\u540c\u65f6\u67e5\u8be2\u4e86 products \u8868 \u548c comments \u8868\u7684\u603b\u8bb0\u5f55\u6570\uff0c\u5e76\u4e14\u6309\u7167 count \u6392\u5e8f<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"string\">'product'<\/span> <span class=\"keyword\">AS<\/span> <span class=\"keyword\">type<\/span>, <span class=\"keyword\">count<\/span>(*) <span class=\"keyword\">as<\/span> <span class=\"keyword\">count<\/span> <span class=\"keyword\">FROM<\/span> <span class=\"string\">`products`<\/span> <span class=\"keyword\">union<\/span> <span class=\"keyword\">select<\/span> <span class=\"string\">'comment'<\/span> <span class=\"keyword\">as<\/span> <span class=\"keyword\">type<\/span>, <span class=\"keyword\">count<\/span>(*) <span class=\"keyword\">as<\/span> <span class=\"keyword\">count<\/span> <span class=\"keyword\">FROM<\/span> <span class=\"string\">`comments`<\/span> <span class=\"keyword\">order<\/span> <span class=\"keyword\">by<\/span> <span class=\"keyword\">count<\/span>;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"AS\">AS<\/h3>\n<blockquote><p>as &#8211; \u53ef\u7406\u89e3\u4e3a\uff1a\u7528\u4f5c\u3001\u5f53\u6210\uff0c\u4f5c\u4e3a\uff1b\u522b\u540d<br \/>\n\u4e00\u822c\u662f\u91cd\u547d\u540d\u5217\u540d\u6216\u8005\u8868\u540d\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>select column_1 as \u52171,column_2 as \u52172 from table as \u8868<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> Employee <span class=\"keyword\">AS<\/span> emp<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u8fd9\u53e5\u610f\u601d\u662f\u67e5\u627e\u6240\u6709Employee \u8868\u91cc\u9762\u7684\u6570\u636e\uff0c\u5e76\u628aEmployee\u8868\u683c\u547d\u540d\u4e3a emp\u3002<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5f53\u4f60\u547d\u540d\u4e00\u4e2a\u8868\u4e4b\u540e\uff0c\u4f60\u53ef\u4ee5\u5728\u4e0b\u9762\u7528 emp \u4ee3\u66ff Employee.<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u4f8b\u5982 SELECT * FROM emp.<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">MAX<\/span>(OrderPrice) <span class=\"keyword\">AS<\/span> LargestOrderPrice <span class=\"keyword\">FROM<\/span> Orders<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5217\u51fa\u8868 Orders \u5b57\u6bb5 OrderPrice \u5217\u6700\u5927\u503c\uff0c<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u7ed3\u679c\u96c6\u5217\u4e0d\u663e\u793a OrderPrice \u663e\u793a LargestOrderPrice<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u663e\u793a\u8868 users_profile \u4e2d\u7684 name \u5217<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> t.name <span class=\"keyword\">from<\/span> (<span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">from<\/span> users_profile a) <span class=\"keyword\">AS<\/span> t;<\/span>\r\n\r\n<span class=\"line\"><span class=\"comment\">-- \u8868 user_accounts \u547d\u540d\u522b\u540d ua\uff0c\u8868 users_profile \u547d\u540d\u522b\u540d up<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u6ee1\u8db3\u6761\u4ef6 \u8868 user_accounts \u5b57\u6bb5 id \u7b49\u4e8e \u8868 users_profile \u5b57\u6bb5 user_id<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u7ed3\u679c\u96c6\u53ea\u663e\u793amobile\u3001name\u4e24\u5217<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> ua.mobile,up.name <span class=\"keyword\">FROM<\/span> user_accounts <span class=\"keyword\">as<\/span> ua <span class=\"keyword\">INNER<\/span> <span class=\"keyword\">JOIN<\/span> users_profile <span class=\"keyword\">as<\/span> up <span class=\"keyword\">ON<\/span> ua.id = up.user_id;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"JOIN\">JOIN<\/h3>\n<blockquote><p>\u7528\u4e8e\u6839\u636e\u4e24\u4e2a\u6216\u591a\u4e2a\u8868\u4e2d\u7684\u5217\u4e4b\u95f4\u7684\u5173\u7cfb\uff0c\u4ece\u8fd9\u4e9b\u8868\u4e2d\u67e5\u8be2\u6570\u636e\u3002<\/p><\/blockquote>\n<ul>\n<li><code>JOIN<\/code>: \u5982\u679c\u8868\u4e2d\u6709\u81f3\u5c11\u4e00\u4e2a\u5339\u914d\uff0c\u5219\u8fd4\u56de\u884c<\/li>\n<li><code>INNER JOIN<\/code>:\u5728\u8868\u4e2d\u5b58\u5728\u81f3\u5c11\u4e00\u4e2a\u5339\u914d\u65f6\uff0cINNER JOIN \u5173\u952e\u5b57\u8fd4\u56de\u884c\u3002<\/li>\n<li><code>LEFT JOIN<\/code>: \u5373\u4f7f\u53f3\u8868\u4e2d\u6ca1\u6709\u5339\u914d\uff0c\u4e5f\u4ece\u5de6\u8868\u8fd4\u56de\u6240\u6709\u7684\u884c<\/li>\n<li><code>RIGHT JOIN<\/code>: \u5373\u4f7f\u5de6\u8868\u4e2d\u6ca1\u6709\u5339\u914d\uff0c\u4e5f\u4ece\u53f3\u8868\u8fd4\u56de\u6240\u6709\u7684\u884c<\/li>\n<li><code>FULL JOIN<\/code>: \u53ea\u8981\u5176\u4e2d\u4e00\u4e2a\u8868\u4e2d\u5b58\u5728\u5339\u914d\uff0c\u5c31\u8fd4\u56de\u884c<\/li>\n<\/ul>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"keyword\">SELECT<\/span> Persons.LastName, Persons.FirstName, Orders.OrderNo<\/span>\r\n<span class=\"line\"><span class=\"keyword\">FROM<\/span> Persons<\/span>\r\n<span class=\"line\"><span class=\"keyword\">INNER<\/span> <span class=\"keyword\">JOIN<\/span> Orders<\/span>\r\n<span class=\"line\"><span class=\"keyword\">ON<\/span> Persons.Id_P = Orders.Id_P<\/span>\r\n<span class=\"line\"><span class=\"keyword\">ORDER<\/span> <span class=\"keyword\">BY<\/span> Persons.LastName;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"SQL-\u51fd\u6570\">SQL \u51fd\u6570<\/h3>\n<h3 id=\"COUNT\">COUNT<\/h3>\n<blockquote><p>COUNT \u8ba9\u6211\u4eec\u80fd\u591f\u6570\u51fa\u5728\u8868\u683c\u4e2d\u6709\u591a\u5c11\u7b14\u8d44\u6599\u88ab\u9009\u51fa\u6765\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>SELECT COUNT(\"\u5b57\u6bb5\u540d\") FROM \"\u8868\u683c\u540d\";<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u8868 Store_Information \u6709\u51e0\u7b14 store_name \u680f\u4e0d\u662f\u7a7a\u767d\u7684\u8d44\u6599\u3002<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \"IS NOT NULL\" \u662f \"\u8fd9\u4e2a\u680f\u4f4d\u4e0d\u662f\u7a7a\u767d\" \u7684\u610f\u601d\u3002<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">COUNT<\/span> (Store_Name) <span class=\"keyword\">FROM<\/span> Store_Information <span class=\"keyword\">WHERE<\/span> Store_Name <span class=\"keyword\">IS<\/span> <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span>; <\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u83b7\u53d6 Persons \u8868\u7684\u603b\u6570<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">COUNT<\/span>(<span class=\"number\">1<\/span>) <span class=\"keyword\">AS<\/span> totals <span class=\"keyword\">FROM<\/span> Persons;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u83b7\u53d6\u8868 station \u5b57\u6bb5 user_id \u76f8\u540c\u7684\u603b\u6570<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">select<\/span> user_id, <span class=\"keyword\">count<\/span>(*) <span class=\"keyword\">as<\/span> totals <span class=\"keyword\">from<\/span> station <span class=\"keyword\">group<\/span> <span class=\"keyword\">by<\/span> user_id;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"MAX\">MAX<\/h3>\n<blockquote><p>MAX \u51fd\u6570\u8fd4\u56de\u4e00\u5217\u4e2d\u7684\u6700\u5927\u503c\u3002NULL \u503c\u4e0d\u5305\u62ec\u5728\u8ba1\u7b97\u4e2d\u3002<br \/>\n\u8bed\u6cd5\uff1a<code>SELECT MAX(\"\u5b57\u6bb5\u540d\") FROM \"\u8868\u683c\u540d\"<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5217\u51fa\u8868 Orders \u5b57\u6bb5 OrderPrice \u5217\u6700\u5927\u503c\uff0c<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u7ed3\u679c\u96c6\u5217\u4e0d\u663e\u793a OrderPrice \u663e\u793a LargestOrderPrice<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> <span class=\"keyword\">MAX<\/span>(OrderPrice) <span class=\"keyword\">AS<\/span> LargestOrderPrice <span class=\"keyword\">FROM<\/span> Orders<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u89e6\u53d1\u5668\">\u89e6\u53d1\u5668<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<br \/>\ncreate trigger &lt;\u89e6\u53d1\u5668\u540d\u79f0&gt;<br \/>\n{ before | after} # \u4e4b\u524d\u6216\u8005\u4e4b\u540e\u51fa\u53d1<br \/>\ninsert | update | delete # \u6307\u660e\u4e86\u6fc0\u6d3b\u89e6\u53d1\u7a0b\u5e8f\u7684\u8bed\u53e5\u7684\u7c7b\u578b<br \/>\non &lt;\u8868\u540d&gt; # \u64cd\u4f5c\u54ea\u5f20\u8868<br \/>\nfor each row # \u89e6\u53d1\u5668\u7684\u6267\u884c\u95f4\u9694\uff0cfor each row \u901a\u77e5\u89e6\u53d1\u5668\u6bcf\u9694\u4e00\u884c\u6267\u884c\u4e00\u6b21\u52a8\u4f5c\uff0c\u800c\u4e0d\u662f\u5bf9\u6574\u4e2a\u8868\u6267\u884c\u4e00\u6b21\u3002<br \/>\n&lt;\u89e6\u53d1\u5668SQL\u8bed\u53e5&gt;<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">delimiter $<\/span>\r\n<span class=\"line\"><span class=\"keyword\">CREATE<\/span> <span class=\"keyword\">TRIGGER<\/span> set_userdate <span class=\"keyword\">BEFORE<\/span> <span class=\"keyword\">INSERT<\/span> <\/span>\r\n<span class=\"line\"><span class=\"keyword\">on<\/span> <span class=\"string\">`message`<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">for<\/span> <span class=\"keyword\">EACH<\/span> <span class=\"keyword\">ROW<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">BEGIN<\/span><\/span>\r\n<span class=\"line\">  <span class=\"keyword\">set<\/span> @statu = new.status; <span class=\"comment\">-- \u58f0\u660e\u590d\u5236\u53d8\u91cf statu<\/span><\/span>\r\n<span class=\"line\">  if @statu = 0 then       <span class=\"comment\">-- \u5224\u65ad statu \u662f\u5426\u7b49\u4e8e 0<\/span><\/span>\r\n<span class=\"line\">    <span class=\"keyword\">UPDATE<\/span> <span class=\"string\">`user_accounts`<\/span> <span class=\"keyword\">SET<\/span> <span class=\"keyword\">status<\/span>=<span class=\"number\">1<\/span> <span class=\"keyword\">WHERE<\/span> openid=NEW.openid;<\/span>\r\n<span class=\"line\">  <span class=\"keyword\">end<\/span> <span class=\"keyword\">if<\/span>;<\/span>\r\n<span class=\"line\"><span class=\"keyword\">END<\/span><\/span>\r\n<span class=\"line\">$<\/span>\r\n<span class=\"line\">DELIMITER ; <span class=\"comment\">-- \u6062\u590d\u7ed3\u675f\u7b26\u53f7<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>OLD\u548cNEW\u4e0d\u533a\u5206\u5927\u5c0f\u5199<\/p>\n<ul>\n<li>NEW \u7528NEW.col_name\uff0c\u6ca1\u6709\u65e7\u884c\u3002\u5728DELETE\u89e6\u53d1\u7a0b\u5e8f\u4e2d\uff0c\u4ec5\u80fd\u4f7f\u7528OLD.col_name\uff0c\u6ca1\u6709\u65b0\u884c\u3002<\/li>\n<li>OLD \u7528OLD.col_name\u6765\u5f15\u7528\u66f4\u65b0\u524d\u7684\u67d0\u4e00\u884c\u7684\u5217<\/li>\n<\/ul>\n<h3 id=\"\u6dfb\u52a0\u7d22\u5f15\">\u6dfb\u52a0\u7d22\u5f15<\/h3>\n<h3 id=\"\u666e\u901a\u7d22\u5f15-INDEX\">\u666e\u901a\u7d22\u5f15(INDEX)<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1aALTER TABLE\u00a0<code>\u8868\u540d\u5b57<\/code>\u00a0ADD INDEX \u7d22\u5f15\u540d\u5b57 (\u00a0<code>\u5b57\u6bb5\u540d\u5b57<\/code>\u00a0)<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u2013\u76f4\u63a5\u521b\u5efa\u7d22\u5f15<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">CREATE<\/span> <span class=\"keyword\">INDEX<\/span> index_user <span class=\"keyword\">ON<\/span> <span class=\"keyword\">user<\/span>(title)<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u2013\u4fee\u6539\u8868\u7ed3\u6784\u7684\u65b9\u5f0f\u6dfb\u52a0\u7d22\u5f15<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">ALTER<\/span> <span class=\"keyword\">TABLE<\/span> table_name <span class=\"keyword\">ADD<\/span> <span class=\"keyword\">INDEX<\/span> index_name <span class=\"keyword\">ON<\/span> (<span class=\"keyword\">column<\/span>(<span class=\"keyword\">length<\/span>))<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u7ed9 user \u8868\u4e2d\u7684 name\u5b57\u6bb5 \u6dfb\u52a0\u666e\u901a\u7d22\u5f15(INDEX)<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">ALTER<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"string\">`table`<\/span> <span class=\"keyword\">ADD<\/span> <span class=\"keyword\">INDEX<\/span> index_name (<span class=\"keyword\">name<\/span>)<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u2013\u521b\u5efa\u8868\u7684\u65f6\u5019\u540c\u65f6\u521b\u5efa\u7d22\u5f15<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">CREATE<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"string\">`table`<\/span> (<\/span>\r\n<span class=\"line\">    <span class=\"string\">`id`<\/span> <span class=\"built_in\">int<\/span>(<span class=\"number\">11<\/span>) <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> AUTO_INCREMENT ,<\/span>\r\n<span class=\"line\">    <span class=\"string\">`title`<\/span> <span class=\"built_in\">char<\/span>(<span class=\"number\">255<\/span>) <span class=\"built_in\">CHARACTER<\/span> <span class=\"keyword\">SET<\/span> utf8 <span class=\"keyword\">COLLATE<\/span> utf8_general_ci <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> ,<\/span>\r\n<span class=\"line\">    <span class=\"string\">`content`<\/span> <span class=\"built_in\">text<\/span> <span class=\"built_in\">CHARACTER<\/span> <span class=\"keyword\">SET<\/span> utf8 <span class=\"keyword\">COLLATE<\/span> utf8_general_ci <span class=\"literal\">NULL<\/span> ,<\/span>\r\n<span class=\"line\">    <span class=\"string\">`time`<\/span> <span class=\"built_in\">int<\/span>(<span class=\"number\">10<\/span>) <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"literal\">NULL<\/span> ,<\/span>\r\n<span class=\"line\">    PRIMARY <span class=\"keyword\">KEY<\/span> (<span class=\"string\">`id`<\/span>),<\/span>\r\n<span class=\"line\">    <span class=\"keyword\">INDEX<\/span> index_name (title(<span class=\"keyword\">length<\/span>))<\/span>\r\n<span class=\"line\">)<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u2013\u5220\u9664\u7d22\u5f15<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">DROP<\/span> <span class=\"keyword\">INDEX<\/span> index_name <span class=\"keyword\">ON<\/span> <span class=\"keyword\">table<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u4e3b\u952e\u7d22\u5f15-PRIMARY-key\">\u4e3b\u952e\u7d22\u5f15(PRIMARY key)<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1aALTER TABLE\u00a0<code>\u8868\u540d\u5b57<\/code>\u00a0ADD PRIMARY KEY (\u00a0<code>\u5b57\u6bb5\u540d\u5b57<\/code>\u00a0)<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u7ed9 user \u8868\u4e2d\u7684 id\u5b57\u6bb5 \u6dfb\u52a0\u4e3b\u952e\u7d22\u5f15(PRIMARY key)<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">ALTER<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"string\">`user`<\/span> <span class=\"keyword\">ADD<\/span> PRIMARY <span class=\"keyword\">key<\/span> (<span class=\"keyword\">id<\/span>);<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u552f\u4e00\u7d22\u5f15-UNIQUE\">\u552f\u4e00\u7d22\u5f15(UNIQUE)<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1aALTER TABLE\u00a0<code>\u8868\u540d\u5b57<\/code>\u00a0ADD UNIQUE (<code>\u5b57\u6bb5\u540d\u5b57<\/code>)<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u7ed9 user \u8868\u4e2d\u7684 creattime \u5b57\u6bb5\u6dfb\u52a0\u552f\u4e00\u7d22\u5f15(UNIQUE)<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">ALTER<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"string\">`user`<\/span> <span class=\"keyword\">ADD<\/span> <span class=\"keyword\">UNIQUE<\/span> (creattime);<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u5168\u6587\u7d22\u5f15-FULLTEXT\">\u5168\u6587\u7d22\u5f15(FULLTEXT)<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1aALTER TABLE\u00a0<code>\u8868\u540d\u5b57<\/code>\u00a0ADD FULLTEXT (<code>\u5b57\u6bb5\u540d\u5b57<\/code>)<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u7ed9 user \u8868\u4e2d\u7684 description \u5b57\u6bb5\u6dfb\u52a0\u5168\u6587\u7d22\u5f15(FULLTEXT)<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">ALTER<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"string\">`user`<\/span> <span class=\"keyword\">ADD<\/span> FULLTEXT (description);<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u6dfb\u52a0\u591a\u5217\u7d22\u5f15\">\u6dfb\u52a0\u591a\u5217\u7d22\u5f15<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<br \/>\nALTER TABLE\u00a0<code>table_name<\/code>\u00a0ADD INDEX index_name (\u00a0<code>column1<\/code>,\u00a0<code>column2<\/code>,\u00a0<code>column3<\/code>)<\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u7ed9 user \u8868\u4e2d\u7684 name\u3001city\u3001age \u5b57\u6bb5\u6dfb\u52a0\u540d\u5b57\u4e3aname_city_age\u7684\u666e\u901a\u7d22\u5f15(INDEX)<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">ALTER<\/span> <span class=\"keyword\">TABLE<\/span> <span class=\"keyword\">user<\/span> <span class=\"keyword\">ADD<\/span> <span class=\"keyword\">INDEX<\/span> name_city_age (<span class=\"keyword\">name<\/span>(<span class=\"number\">10<\/span>),city,age);<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u5efa\u7acb\u7d22\u5f15\u7684\u65f6\u673a\">\u5efa\u7acb\u7d22\u5f15\u7684\u65f6\u673a<\/h3>\n<p>\u5728<code>WHERE<\/code>\u548c<code>JOIN<\/code>\u4e2d\u51fa\u73b0\u7684\u5217\u9700\u8981\u5efa\u7acb\u7d22\u5f15\uff0c\u4f46\u4e5f\u4e0d\u5b8c\u5168\u5982\u6b64\uff1a<\/p>\n<ul>\n<li>MySQL\u53ea\u5bf9<code>&lt;<\/code>\uff0c<code>&lt;=<\/code>\uff0c<code>=<\/code>\uff0c<code>&gt;<\/code>\uff0c<code>&gt;=<\/code>\uff0c<code>BETWEEN<\/code>\uff0c<code>IN<\/code>\u4f7f\u7528\u7d22\u5f15<\/li>\n<li>\u67d0\u4e9b\u65f6\u5019\u7684<code>LIKE<\/code>\u4e5f\u4f1a\u4f7f\u7528\u7d22\u5f15\u3002<\/li>\n<li>\u5728<code>LIKE<\/code>\u4ee5\u901a\u914d\u7b26%\u548c_\u5f00\u5934\u4f5c\u67e5\u8be2\u65f6\uff0cMySQL\u4e0d\u4f1a\u4f7f\u7528\u7d22\u5f15\u3002<\/li>\n<\/ul>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u6b64\u65f6\u5c31\u9700\u8981\u5bf9city\u548cage\u5efa\u7acb\u7d22\u5f15\uff0c<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u7531\u4e8emytable\u8868\u7684userame\u4e5f\u51fa\u73b0\u5728\u4e86JOIN\u5b50\u53e5\u4e2d\uff0c\u4e5f\u6709\u5bf9\u5b83\u5efa\u7acb\u7d22\u5f15\u7684\u5fc5\u8981\u3002<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> t.Name  <\/span>\r\n<span class=\"line\"><span class=\"keyword\">FROM<\/span> mytable t <span class=\"keyword\">LEFT<\/span> <span class=\"keyword\">JOIN<\/span> mytable m <span class=\"keyword\">ON<\/span> t.Name=m.username <\/span>\r\n<span class=\"line\"><span class=\"keyword\">WHERE<\/span> m.age=<span class=\"number\">20<\/span> <span class=\"keyword\">AND<\/span> m.city=<span class=\"string\">'\u4e0a\u6d77'<\/span>;<\/span>\r\n\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> mytable <span class=\"keyword\">WHERE<\/span> username <span class=\"keyword\">like<\/span><span class=\"string\">'admin%'<\/span>; <span class=\"comment\">-- \u800c\u4e0b\u53e5\u5c31\u4e0d\u4f1a\u4f7f\u7528\uff1a<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">SELECT<\/span> * <span class=\"keyword\">FROM<\/span> mytable WHEREt <span class=\"keyword\">Name<\/span> <span class=\"keyword\">like<\/span><span class=\"string\">'%admin'<\/span>; <span class=\"comment\">-- \u56e0\u6b64\uff0c\u5728\u4f7f\u7528LIKE\u65f6\u5e94\u6ce8\u610f\u4ee5\u4e0a\u7684\u533a\u522b\u3002<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>\u7d22\u5f15\u7684\u6ce8\u610f\u4e8b\u9879<\/p>\n<ul>\n<li>\u7d22\u5f15\u4e0d\u4f1a\u5305\u542b\u6709NULL\u503c\u7684\u5217<\/li>\n<li>\u4f7f\u7528\u77ed\u7d22\u5f15<\/li>\n<li>\u4e0d\u8981\u5728\u5217\u4e0a\u8fdb\u884c\u8fd0\u7b97 \u7d22\u5f15\u4f1a\u5931\u6548<\/li>\n<\/ul>\n<h3 id=\"\u521b\u5efa\u540e\u8868\u7684\u4fee\u6539\">\u521b\u5efa\u540e\u8868\u7684\u4fee\u6539<\/h3>\n<h3 id=\"\u6dfb\u52a0\u5217\">\u6dfb\u52a0\u5217<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<code>alter table \u8868\u540d add \u5217\u540d \u5217\u6570\u636e\u7c7b\u578b [after \u63d2\u5165\u4f4d\u7f6e];<\/code><\/p><\/blockquote>\n<p>\u793a\u4f8b:<\/p>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5728\u8868students\u7684\u6700\u540e\u8ffd\u52a0\u5217 address: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">add<\/span> address <span class=\"built_in\">char<\/span>(<span class=\"number\">60<\/span>);<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5728\u540d\u4e3a age \u7684\u5217\u540e\u63d2\u5165\u5217 birthday: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">add<\/span> birthday <span class=\"built_in\">date<\/span> <span class=\"keyword\">after<\/span> age;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5728\u540d\u4e3a number_people \u7684\u5217\u540e\u63d2\u5165\u5217 weeks: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">add<\/span> <span class=\"keyword\">column<\/span> <span class=\"string\">`weeks`<\/span> <span class=\"built_in\">varchar<\/span>(<span class=\"number\">5<\/span>) <span class=\"keyword\">not<\/span> <span class=\"literal\">null<\/span> <span class=\"keyword\">default<\/span> <span class=\"string\">\"\"<\/span> <span class=\"keyword\">after<\/span> <span class=\"string\">`number_people`<\/span>;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u4fee\u6539\u5217\">\u4fee\u6539\u5217<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<code>alter table \u8868\u540d change \u5217\u540d\u79f0 \u5217\u65b0\u540d\u79f0 \u65b0\u6570\u636e\u7c7b\u578b;<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5c06\u8868 tel \u5217\u6539\u540d\u4e3a telphone: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">change<\/span> tel telphone <span class=\"built_in\">char<\/span>(<span class=\"number\">13<\/span>) <span class=\"keyword\">default<\/span> <span class=\"string\">\"-\"<\/span>;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5c06 name \u5217\u7684\u6570\u636e\u7c7b\u578b\u6539\u4e3a char(16): <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">change<\/span> <span class=\"keyword\">name<\/span> <span class=\"keyword\">name<\/span> <span class=\"built_in\">char<\/span>(<span class=\"number\">16<\/span>) <span class=\"keyword\">not<\/span> <span class=\"literal\">null<\/span>;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u4fee\u6539 COMMENT \u524d\u9762\u5fc5\u987b\u5f97\u6709\u7c7b\u578b\u5c5e\u6027<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">change<\/span> <span class=\"keyword\">name<\/span> <span class=\"keyword\">name<\/span> <span class=\"built_in\">char<\/span>(<span class=\"number\">16<\/span>) <span class=\"keyword\">COMMENT<\/span> <span class=\"string\">'\u8fd9\u91cc\u662f\u540d\u5b57'<\/span>;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u4fee\u6539\u5217\u5c5e\u6027\u7684\u65f6\u5019 \u5efa\u8bae\u4f7f\u7528modify,\u4e0d\u9700\u8981\u91cd\u5efa\u8868<\/span><\/span>\r\n<span class=\"line\"><span class=\"comment\">-- change\u7528\u4e8e\u4fee\u6539\u5217\u540d\u5b57\uff0c\u8fd9\u4e2a\u9700\u8981\u91cd\u5efa\u8868<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> meeting <span class=\"keyword\">modify<\/span> <span class=\"string\">`weeks`<\/span> <span class=\"built_in\">varchar<\/span>(<span class=\"number\">20<\/span>) <span class=\"keyword\">NOT<\/span> <span class=\"literal\">NULL<\/span> <span class=\"keyword\">DEFAULT<\/span> <span class=\"string\">\"\"<\/span> <span class=\"keyword\">COMMENT<\/span> <span class=\"string\">\"\u5f00\u653e\u65e5\u671f \u5468\u4e00\u5230\u5468\u65e5\uff1a0~6\uff0c\u95f4\u9694\u7528\u82f1\u6587\u9017\u53f7\u9694\u5f00\"<\/span>;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u5220\u9664\u5217\">\u5220\u9664\u5217<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<code>alter table \u8868\u540d drop \u5217\u540d\u79f0;<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5220\u9664\u8868students\u4e2d\u7684 birthday \u5217: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">drop<\/span> birthday;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u91cd\u547d\u540d\u8868\">\u91cd\u547d\u540d\u8868<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<code>alter table \u8868\u540d rename \u65b0\u8868\u540d;<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u91cd\u547d\u540d students \u8868\u4e3a workmates: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">alter<\/span> <span class=\"keyword\">table<\/span> students <span class=\"keyword\">rename<\/span> workmates;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u6e05\u7a7a\u8868\u6570\u636e\">\u6e05\u7a7a\u8868\u6570\u636e<\/h3>\n<blockquote><p>\u65b9\u6cd5\u4e00\uff1a<code>delete from \u8868\u540d;<\/code><br \/>\n\u65b9\u6cd5\u4e8c\uff1a<code>truncate from \"\u8868\u540d\";<\/code><\/p><\/blockquote>\n<ul>\n<li><code>DELETE:<\/code>1. DML\u8bed\u8a00;2. \u53ef\u4ee5\u56de\u9000;3. \u53ef\u4ee5\u6709\u6761\u4ef6\u7684\u5220\u9664;<\/li>\n<li><code>TRUNCATE:<\/code>1. DDL\u8bed\u8a00;2. \u65e0\u6cd5\u56de\u9000;3. \u9ed8\u8ba4\u6240\u6709\u7684\u8868\u5185\u5bb9\u90fd\u5220\u9664;4. \u5220\u9664\u901f\u5ea6\u6bd4delete\u5feb\u3002<\/li>\n<\/ul>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u6e05\u7a7a\u8868\u4e3a workmates \u91cc\u9762\u7684\u6570\u636e\uff0c\u4e0d\u5220\u9664\u8868\u3002 <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">delete<\/span> <span class=\"keyword\">from<\/span> workmates;<\/span>\r\n<span class=\"line\"><span class=\"comment\">-- \u5220\u9664workmates\u8868\u4e2d\u7684\u6240\u6709\u6570\u636e\uff0c\u4e14\u65e0\u6cd5\u6062\u590d<\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">truncate<\/span> <span class=\"keyword\">from<\/span> workmates;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u5220\u9664\u6574\u5f20\u8868\">\u5220\u9664\u6574\u5f20\u8868<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<code>drop table \u8868\u540d;<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5220\u9664 workmates \u8868: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">drop<\/span> <span class=\"keyword\">table<\/span> workmates;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u5220\u9664\u6574\u4e2a\u6570\u636e\u5e93\">\u5220\u9664\u6574\u4e2a\u6570\u636e\u5e93<\/h3>\n<blockquote><p>\u8bed\u6cd5\uff1a<code>drop database \u6570\u636e\u5e93\u540d;<\/code><\/p><\/blockquote>\n<figure class=\"highlight sql\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"comment\">-- \u5220\u9664 samp_db \u6570\u636e\u5e93: <\/span><\/span>\r\n<span class=\"line\"><span class=\"keyword\">drop<\/span> <span class=\"keyword\">database<\/span> samp_db;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3 id=\"\u4e2a\u4eba\u5c0f\u7a0b\u5e8f\"><\/h3>\n<p>http:\/\/www.wclimb.site\/2017\/07\/20\/MySQL%E5%9F%BA%E7%A1%80\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f00\u59cb\u4f7f\u7528 MySQL \u4e3a\u5173\u7cfb\u578b\u6570\u636e\u5e93(Relational Database Management Syste [&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":[],"_links":{"self":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/191"}],"collection":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/comments?post=191"}],"version-history":[{"count":2,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/191\/revisions"}],"predecessor-version":[{"id":193,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/191\/revisions\/193"}],"wp:attachment":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/media?parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/categories?post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/tags?post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}