{"id":16,"date":"2022-05-18T10:14:22","date_gmt":"2022-05-18T02:14:22","guid":{"rendered":"https:\/\/blog.mumudlin.com\/?p=16"},"modified":"2022-06-28T23:29:06","modified_gmt":"2022-06-28T15:29:06","slug":"mysql_database","status":"publish","type":"post","link":"https:\/\/blog.mumudlin.com\/index.php\/mysql_database\/","title":{"rendered":"\u6570\u636e\u5e93-mysql"},"content":{"rendered":"<h2>\u5e38\u7528\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u547d\u4ee4\u5199\u6cd5<\/h2>\n<pre><code class=\"language-sql\">show databases; # \u67e5\u8be2\u6709\u591a\u5c11\u4e2a\u6570\u636e\u5e93\n\ncreate database db1; # \u521b\u5efa\u540d\u4e3adb1\u7684\u6570\u636e\u5e93\n\ncreate database if not exists db1;# \u5982\u679cdb1\u4e0d\u5b58\u5728\u518d\u521b\u5efa\n\ncreate database db2; # \u521b\u5efa\u540d\u4e3adb2\u7684\u6570\u636e\u5e93\n\ndrop database db2;# \u5220\u9664\u540d\u4e3adb2\u7684\u6570\u636e\u5e93\n\ndrop database if exists db2; #\u540c\u4e0a\n\nuse database db1; # \u5207\u6362\u5230db1\u6570\u636e\u5e93<\/code><\/pre>\n<h2>SQL\u4e2d\u7684\u6570\u636e\u7c7b\u578b<\/h2>\n<p>\u5927\u81f4\u53ef\u5206\u4e3a\u4e09\u7c7b<\/p>\n<ul>\n<li>\u6570\u503c<\/li>\n<li>\u65e5\u671f<\/li>\n<li>\u5b57\u7b26\u4e32<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181034403.png\" alt=\"Untitled\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181035828.png\" alt=\"Untitled\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublogUntitled%202.png\" alt=\"Untitled\" \/><\/p>\n<h2>\u521b\u5efa\u6848\u4f8b<\/h2>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181035112.png\" alt=\"Untitled\" \/><\/p>\n<pre><code class=\"language-sql\">create table student(\n    id int,\n    name varchar(10),\n    gender char(1),\n    birthday date,\n    score double(5,2),\n    email varchar(64),\n    tel varchar(15),\n    status tinyint\n);\n\nshow tables ;\n\ndesc student;<\/code><\/pre>\n<h2>DDL<\/h2>\n<pre><code class=\"language-sql\">## \u5220\u9664\u8868\nshow tables;\n\ndrop table tb_user;\n\ndrop table if exists tb_user;<\/code><\/pre>\n<pre><code class=\"language-sql\">## \u4fee\u6539\u8868\nshow tables;\ndesc student;\n\nalter table student rename to stu; # \u4fee\u6539\u8868\u540d\nshow tables;\ndesc stu;\n\nalter table stu add address varchar(50); # \u589e\u52a0\u5217\ndesc stu;\n\nalter table stu modify address char(50); # \u4fee\u6539\u5217\ndesc stu;\n\nalter table stu change address addr varchar(30); # \u540c\u65f6\u4fee\u6539\u5217\u540d\u548c\u6570\u636e\u7c7b\u578b\ndesc stu;\n\nalter table stu drop addr; # \u5220\u9664\u5217\ndesc stu;<\/code><\/pre>\n<h2>DML<\/h2>\n<h3>\u6dfb\u52a0\u6570\u636e<\/h3>\n<pre><code class=\"language-sql\"># \u67e5\u8be2\u6240\u6709\u6570\u636e\nselect *\nfrom stu;\n\n# \u8be5\u6307\u5b9a\u5217\u6dfb\u52a0\u6570\u636e\ninsert into stu(id, name)\nvalues (1, &#039;\u5f20\u4e09&#039;);\n\n# \u7ed9\u6240\u6709\u5217\u6dfb\u52a0\u6570\u636e,\u5217\u540d\u7684\u5217\u8868\u53ef\u4ee5\u7701\u7565\ninsert into stu(id, name, sex, birthday, score, email, tel, status)\nvalues (2, &#039;\u674e\u56db&#039;, &#039;\u7537&#039;, &#039;1999-11-11&#039;, 88.88, &#039;lisi@itcast.cn&#039;, &#039;13812345678&#039;, 1);\nselect *\nfrom stu;<\/code><\/pre>\n<h3>\u4fee\u6539\u6570\u636e<\/h3>\n<pre><code class=\"language-sql\"># \u4fee\u6539\u6570\u636e update \u8868\u540d set \u5217\u540d1=\u503c1,\u5217\u540d2=\u503c2 [where \u6761\u4ef6];\n\n# \u5c06\u5f20\u4e09\u7684\u6027\u522b\u6539\u4e3a\u5973\nupdate stu set sex = &#039;\u5973&#039; where name = &#039;\u5f20\u4e09&#039;;\n\n# \u5c06\u5f20\u4e09\u7684\u751f\u65e5\u6539\u4e3a1999-12-12\uff0c\u5206\u6570\u6539\u4e3a99.99\nupdate stu\nset birthday = &#039;1999-12-12&#039;,score = 99.99\nwhere name = &#039;\u5f20\u4e09&#039;;\n# \u6ce8\uff1a\u5982\u679cupdate\u8bed\u53e5\u6ca1\u6709\u52a0where\u6761\u4ef6\uff0c\u5219\u4f1a\u5c06\u8868\u4e2d\u7684\u6240\u6709\u6570\u636e\u90fd\u6539\u4e3a\u6307\u5b9a\u7684\u503c\n<\/code><\/pre>\n<h3>\u5220\u9664\u6570\u636e<\/h3>\n<pre><code># \u5220\u9664\u5f20\u4e09\u8bb0\u5f55\ndelete from stu where name=&#039;\u5f20\u4e09&#039;;\n\ndelete from stu;\n<\/code><\/pre>\n<h2>DQL<\/h2>\n<p>\u67e5\u8be2\u8bed\u6cd5<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181036856.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u9884\u521b\u5efa\u6570\u636e<\/h3>\n<pre><code class=\"language-sql\"># \u5220\u9664stu\u8868\ndrop table if exists stu;\n\n# \u521b\u5efastu\u8868\ncreate table stu(\n    id int,  # \u7f16\u53f7\n    name varchar(20), # \u59d3\u540d\n    age int, # \u5e74\u9f84\n    sex varchar(5), # \u6027\u522b\n    address varchar(100), # \u5730\u5740\n    math double(5,2), # \u6570\u5b66\u6210\u7ee9\n    english double(5,2), # \u82f1\u8bed\u6210\u7ee9\n    hire_date date #\u5165\u5b66\u65f6\u95f4\n);\n\n# \u6dfb\u52a0\u6570\u636e\ninsert into stu(id,name,age,sex,address,math,english,hire_date)\nvalues\n(1,&#039;\u9a6c\u8fd0&#039;,55,&#039;\u7537&#039;,&#039;\u676d\u5dde&#039;,66,78,&#039;1995-09-01&#039;),\n(2,&#039;\u9a6c\u82b1\u75bc&#039;,45,&#039;\u5973&#039;,&#039;\u6df1\u5733&#039;,98,87,&#039;1998-09-01&#039;),\n(3,&#039;\u9a6c\u65af\u514b&#039;,55,&#039;\u7537&#039;,&#039;\u9999\u6e2f&#039;,56,77,&#039;1999-09-02&#039;),\n(4,&#039;\u67f3\u767d&#039;,20,&#039;\u5973&#039;,&#039;\u6e56\u5357&#039;,76,65,&#039;1997-09-05&#039;),\n(5,&#039;\u67f3\u9752&#039;,20,&#039;\u7537&#039;,&#039;\u6e56\u5357&#039;,86,NULL,&#039;1998-09-01&#039;),\n(6,&#039;\u5218\u5fb7\u82b1&#039;,57,&#039;\u7537&#039;,&#039;\u9999\u6e2f&#039;,99,99,&#039;1998-09-01&#039;),\n(7,&#039;\u5f20\u5b66\u53f3&#039;,22,&#039;\u5973&#039;,&#039;\u9999\u6e2f&#039;,99,99,&#039;1998-09-01&#039;),\n(8,&#039;\u5fb7\u739b\u897f\u4e9a&#039;,18,&#039;\u7537&#039;,&#039;\u5357\u4eac&#039;,56,65,&#039;1994-09-02&#039;);<\/code><\/pre>\n<h3>\u57fa\u7840\u67e5\u8be2<\/h3>\n<pre><code class=\"language-sql\"># \u57fa\u7840\u67e5\u8be2\nselect *\nfrom stu;\n# \u6700\u597d\u4e0d\u8981\u4f7f\u7528\uff0c\u5f71\u54cd\u9605\u8bfb\u6027\n\n# \u67e5\u8be2name age\u4e24\u5217\nselect name, age\nfrom stu;\n\n# \u53bb\u9664\u91cd\u590d\u8bb0\u5f55\nselect distinct address\nfrom stu;\n\n# \u67e5\u8be2\u59d3\u540d\uff0c\u6570\u5b66\u6210\u7ee9\uff0c\u82f1\u8bed\u6210\u7ee9\nselect name, math as \u6570\u5b66\u6210\u7ee9, english as \u82f1\u8bed\u6210\u7ee9 # as \u522b\u540d as# \u4e0d\u662f\u5fc5\u987b\u7684\nfrom stu;\n<\/code><\/pre>\n<h3>\u6761\u4ef6\u67e5\u8be2<\/h3>\n<pre><code class=\"language-sql\"># \u6761\u4ef6\u67e5\u8be2\u8bed\u6cd5\nselect \u5b57\u6bb5\u5217\u8868\nfrom \u8868\u540d\nwhere \u6761\u4ef6\u5217\u8868;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181038061.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u6761\u4ef6\u67e5\u8be2\u793a\u4f8b<\/h3>\n<pre><code class=\"language-sql\"># \u6761\u4ef6\u67e5\u8be2\n# 1.\u67e5\u8be2\u5e74\u9f84\u5927\u4e8e20\u5c81\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where age &gt; 20;\n# 2.\u67e5\u8be2\u5e74\u9f84\u5927\u4e8e\u7b49\u4e8e20\u5c81\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where age &gt;= 20;\n# 3.\u67e5\u8be2\u5e74\u9f84\u5927\u4e8e\u7b49\u4e8e20\u5c81\u5e76\u4e14\u5e74\u9f84\u5c0f\u4e8e\u7b49\u4e8e30\u5c81\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where age &gt;= 20 and age &lt;= 30;\nselect * from stu where age between 20 and 30;\n# 4.\u67e5\u8be2\u5165\u5b66\u65e5\u671f\u5728&#039;1998-09-01\u00b7\u52301999-09-01&#039;\u4e4b\u95f4\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where hire_date between &#039;1998-09-01&#039; and &#039;1999-09-01&#039;;\n# 5.\u67e5\u8be2\u5e74\u9f84\u7b49\u4e8e18\u5c81\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where age = 18;\n# 6.\u67e5\u8be2\u5e74\u9f84\u4e0d\u7b49\u4e8e18\u5c81\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where age != 18;\n# 7.\u67e5\u8be2\u5e74\u9f84\u7b49\u4e8e18\u5c81\u6216\u8005\u5e74\u9f84\u7b49\u4e8e20\u5c81\u6216\u8005\u5e74\u9f84\u7b49\u4e8e22\u5c81\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where age = 18 or age = 20 or age = 22;\n# 8.\u67e5\u8be2\u82f1\u8bed\u6210\u7ee9\u4e3anull\u7684\u5b66\u5458\u4fe1\u606f\n# \u6ce8\u610f\uff1anull\u503c\u4e0d\u80fd\u7528=,!=\u6bd4\u8f83\uff0c\u53ea\u80fd\u7528is null\u6216\u8005is not null\u6bd4\u8f83\nselect * from stu where english is null;\n<\/code><\/pre>\n<h3>\u6a21\u7cca\u67e5\u8be2<\/h3>\n<pre><code class=\"language-sql\"># \u6a21\u7cca\u67e5\u8be2like\n\/*\n\u901a\u914d\u7b26\uff1a\n(1)_:\u4ee3\u8868\u5355\u4e2a\u4efb\u610f\u5b57\u7b26\n(2)%\u53f7\uff1a\u4ee3\u8868\u4efb\u610f\u4e2a\u6570\u5b57\u7b26\n*\/\n\n# 1.\u67e5\u8be2\u59d3\u9a6c&#039;\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where name like &#039;\u9a6c%&#039;;\n# 2.\u67e5\u8be2\u7b2c\u4e8c\u4e2a\u5b57\u662f&#039;\u82b1\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where name like &#039;_\u82b1%&#039;;\n# 3.\u67e5\u8be2\u540d\u5b57\u4e2d\u5305\u542b\u00b7\u5fb7&#039;\u7684\u5b66\u5458\u4fe1\u606f\nselect * from stu where name like &#039;%\u5fb7%&#039;;<\/code><\/pre>\n<h3>\u6392\u5e8f\u67e5\u8be2<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181039961.png\" alt=\"Untitled\" \/><\/p>\n<pre><code class=\"language-sql\"># 1. \u67e5\u8be2\u5b66\u751f\u4fe1\u606f\uff0c\u6309\u7167\u5e74\u9f84\u5347\u5e8f\u6392\u5217\nselect * from stu order by age;\n\n# 2. \u67e5\u8be2\u5b66\u751f\u4fe1\u606f\uff0c\u6309\u7167\u6570\u5b66\u6210\u7ee9\u964d\u5e8f\u6392\u5217\nselect * from stu order by math desc;\n\n# 3. \u67e5\u8be2\u5b66\u751f\u4fe1\u606f\uff0c\u6309\u7167\u6570\u5b66\u6210\u7ee9\u964d\u5e8f\u6392\u5217\uff0c\u5982\u679c\u6570\u5b66\u6210\u7ee9\u76f8\u540c\uff0c\u518d\u6309\u82f1\u8bed\u6210\u7ee9\u5347\u5e8f\u6392\u5217\nselect * from stu order by math desc, english;<\/code><\/pre>\n<h3>\u5206\u7ec4\u67e5\u8be2<\/h3>\n<h4>\u805a\u5408\u51fd\u6570<\/h4>\n<pre><code>\/*\n\u805a\u5408\u51fd\u6570\ncount:\u7edf\u8ba1\u6570\u91cf\nmax:\u6c42\u6700\u5927\u503c\nmin:\u6c42\u6700\u5c0f\u503c\nsum:\u6c42\u548c\navg:\u6c42\u5e73\u5747\u503c\n*\/\n# 1.\u7edf\u8ba1\u73ed\u7ea7\u4e00\u5171\u6709\u591a\u5c11\u4e2a\u5b66\u751f\nselectcount(id) from stu;\nselectcount(english) from stu;\nselectcount(*) from stu;\n\n# 2.\u67e5\u8be2\u6570\u5b66\u6210\u7ee9\u7684\u6700\u9ad8\u5206\nselectmax(math) from stu;\n\n# 3.\u67e5\u8be2\u6570\u5b66\u6210\u7ee9\u7684\u6700\u4f4e\u5206\nselectmin(math) from stu;\n\n# 4.\u67e5\u8be2\u6570\u5b66\u6210\u7ee9\u7684\u603b\u5206\nselectsum(math) from stu;\n\n# 5.\u67e5\u8be2\u6570\u5b66\u6210\u7ee9\u7684\u5e73\u5747\u5206\nselectavg(math) from stu;\n\n# 6.\u67e5\u8be2\u82f1\u8bed\u6210\u7ee9\u7684\u6700\u4f4e\u5206\nselectmin(english) from stu;<\/code><\/pre>\n<h4>\u5206\u7ec4<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181039230.png\" alt=\"Untitled\" \/><\/p>\n<pre><code class=\"language-sql\">\/*\n\u5206\u7ec4\u51fd\u6570\nSELECT \u5b57\u6bb5\u5217\u8868 FROM \u8868\u540d [WHERE \u5206\u7ec4\u524d\u6761\u4ef6\u9650\u5b9a]\nGROUP BY \u5206\u7ec4\u5b57\u6bb5\u540d [HAVING \u5206\u7ec4\u540e\u6761\u4ef6\u8fc7\u6ee4]...\uff1a\n*\/\nselect *\nfrom stu;\n# 1.\u67e5\u8be2\u7537\u540c\u5b66\u548c\u5973\u540c\u5b66\u5404\u81ea\u7684\u6570\u5b66\u5e73\u5747\u5206\nselect sex,avg(math)\nfrom stu\ngroup by sex;\n\n# 2.\u67e5\u8be2\u7537\u540c\u5b66\u548c\u5973\u540c\u5b66\u5404\u81ea\u7684\u6570\u5b66\u5e73\u5747\u5206\uff0c\u4ee5\u53ca\u5404\u81ea\u4eba\u6570\nselect sex,avg(math),count(*)\nfrom stu\ngroup by sex;\n\n# 3.\u67e5\u8be2\u7537\u540c\u5b66\u548c\u5973\u540c\u5b66\u5404\u81ea\u7684\u6570\u5b66\u5e73\u5747\u5206\uff0c\u4ee5\u53ca\u5404\u81ea\u4eba\u6570\uff0c\u8981\u6c42\uff1a\u5206\u6570\u4f4e\u4e8e70\u5206\u7684\u4e0d\u53c2\u4e0e\u5206\u7ec4\nselect sex,avg(math),count(*)\nfrom stu\nwhere math &gt; 70\ngroup by sex;\n\n# 4.\u67e5\u8be2\u7537\u540c\u5b66\u548c\u5973\u540c\u5b66\u5404\u81ea\u7684\u6570\u5b66\u5e73\u5747\u5206\uff0c\u4ee5\u53ca\u5404\u81ea\u4eba\u6570\uff0c\u8981\u6c42\uff1a\u5206\u6570\u4f4e\u4e8e70\u5206\u7684\u4e0d\u53c2\u4e0e\u5206\u7ec4\uff0c\u5206\u7ec4\u4e4b\u540e\u4eba\u6570\u5927\u4e8e2\nselect sex,avg(math),count(*)\nfrom stu\nwhere math &gt; 70\ngroup by sex\nhavingcount(*) &gt; 2;\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181040871.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u5206\u9875\u67e5\u8be2<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181040917.png\" alt=\"Untitled\" \/><\/p>\n<pre><code class=\"language-sql\">\/*\n\u5206\u9875\u67e5\u8be2\uff1a\nSELECT \u5b57\u6bb5\u5217\u8868 FROM \u8868\u540d LIMIT \u8d77\u59cb\u7d22\u5f15, \u67e5\u8be2\u6761\u76ee\u6570\n        * \u8d77\u59cb\u7d22\u5f15\uff1a\u4ece0\u5f00\u59cb\n*\/\nselect * from stu;\n\n# 1.\u4ece0\u5f00\u59cb\u67e5\u8be2\uff0c\u67e5\u8be23\u6761\u6570\u636e\nselect * from stu limit 0,3;\n\n# 2.\u6bcf\u9875\u663e\u793a3\u6761\u6570\u636e\uff0c\u67e5\u8be2\u7b2c1\u9875\u6570\u636e\nselect * from stu limit 0,3;\n\n# 3.\u6bcf\u9875\u663e\u793a3\u6761\u6570\u636e\uff0c\u67e5\u8be2\u7b2c2\u9875\u6570\u636e\nselect * from stu limit 3,3;\n\n# 4.\u6bcf\u9875\u663e\u793a3\u6761\u6570\u636e\uff0c\u67e5\u8be2\u7b2c3\u9875\u6570\u636e\nselect * from stu limit 6,3;\n<\/code><\/pre>\n<h2>\u7ea6\u675f<\/h2>\n<h3>\u6982\u5ff5&amp;\u5206\u7c7b<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181040432.png\" alt=\"Untitled\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181040040.png\" alt=\"Untitled\" \/><\/p>\n<h4>\u7ea6\u675f\u6848\u4f8b<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181041422.png\" alt=\"Untitled\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181041687.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u975e\u7a7a\u7ea6\u675f<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181042319.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u552f\u4e00\u7ea6\u675f<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181042477.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u4e3b\u952e\u7ea6\u675f<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181042951.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u9ed8\u8ba4\u7ea6\u675f<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181043591.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u5916\u952e\u7ea6\u675f<\/h3>\n<p><a target=\"_blank\" rel=\"noopener\" href=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181043998.png\">Untitled<\/a><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181043590.png\" alt=\"Untitled\" \/><\/p>\n<h2>\u6570\u636e\u5e93\u8bbe\u8ba1<\/h2>\n<h3>\u6570\u636e\u5e93\u8bbe\u8ba1\u7b80\u4ecb<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181043644.png\" alt=\"Untitled\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181044310.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u8868\u5173\u7cfb<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181044590.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u8868\u5173\u7cfb\u4e4b\u4e00\u5bf9\u591a<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog1toduo.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u8868\u5173\u7cfb\u4e4b\u591a\u5bf9\u591a<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublogduototuo.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u8868\u5173\u7cfb\u4e4b\u4e00\u5bf9\u4e00<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublogonetoone.png\" alt=\"Untitled\" \/><\/p>\n<h3>\u603b\u7ed3<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/rain-1302105611.cos.ap-chengdu.myqcloud.com\/\/mumublog202206181045976.png\" alt=\"Untitled\" \/><\/p>\n<h2>\u591a\u8868\u67e5\u8be2<\/h2>\n<h2>\u4e8b\u52a1<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>\u5e38\u7528\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u547d\u4ee4\u5199\u6cd5 show databases; # \u67e5\u8be2\u6709\u591a\u5c11\u4e2a\u6570\u636e\u5e93 create databa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-javaweb"],"_links":{"self":[{"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":7,"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/posts\/16\/revisions"}],"predecessor-version":[{"id":28,"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/posts\/16\/revisions\/28"}],"wp:attachment":[{"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/media?parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/categories?post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mumudlin.com\/index.php\/wp-json\/wp\/v2\/tags?post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}