{"id":1239,"date":"2020-05-18T07:57:40","date_gmt":"2020-05-17T23:57:40","guid":{"rendered":"http:\/\/39.97.231.10\/?p=1239"},"modified":"2020-05-18T07:57:40","modified_gmt":"2020-05-17T23:57:40","slug":"mysql%e6%9f%a5%e7%9c%8b%e8%a1%a8%e7%bb%93%e6%9e%84%e5%8f%8a%e5%bb%ba%e8%a1%a8%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=1239","title":{"rendered":"MySQL\u67e5\u770b\u8868\u7ed3\u6784\u53ca\u5efa\u8868\u8bed\u53e5"},"content":{"rendered":"<ul>\n<li><strong>MySQL\u67e5\u770b\u8868\u7ed3\u6784\uff1a<code>desc tablename;<\/code><\/strong><\/li>\n<\/ul>\n<pre class=\\\"prettyprint\\\">mysql&gt; desc weijing;\n+--------+-------------+------+-----+---------+----------------+\n| Field  | Type        | Null | Key | Default | Extra          |\n+--------+-------------+------+-----+---------+----------------+\n| Id     | int(11)     | NO   | PRI | NULL    | auto_increment |\n| Name   | varchar(20) | YES  |     | NULL    |                |\n| Date   | date        | YES  |     | NULL    |                |\n| Scount | int(11)     | YES  |     | NULL    |                |\n+--------+-------------+------+-----+---------+----------------+\n4 rows in set (0.00 sec)<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>MySQL\u67e5\u770b\u5efa\u8868\u8bed\u53e5\uff1a<code>show create table tablename;<\/code><\/strong><\/li>\n<\/ul>\n<pre class=\\\"prettyprint\\\" style=\\\"padding-left: 40px;\\\">mysql&gt; show create table weijing;\n+---------+------------------------------------------------------------------+\n| Table   | Create Table                                                                                                                                                                                                                                |\n+---------+------------------------------------------------------------------+\n| weijing | CREATE TABLE `weijing` (\n  `Id` int(11) NOT NULL AUTO_INCREMENT,\n  `Name` varchar(20) DEFAULT NULL,\n  `Date` date DEFAULT NULL,\n  `Scount` int(11) DEFAULT NULL,\n  PRIMARY KEY (`Id`)\n) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 |\n+---------+------------------------------------------------------------------+\n1 row in set (0.01 sec)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u67e5\u770b\u8868\u7ed3\u6784\uff1adesc tablename; mysql&gt; desc weijing; +&#8212; &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/www.weijing.co\/?p=1239\"> <span class=\"screen-reader-text\">MySQL\u67e5\u770b\u8868\u7ed3\u6784\u53ca\u5efa\u8868\u8bed\u53e5<\/span> \u67e5\u770b\u5168\u6587 &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":0,"uagb_excerpt":"MySQL\u67e5\u770b\u8868\u7ed3\u6784\uff1adesc tablename; mysql&gt; desc weijing; +---&hellip;","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1239"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1239"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1239\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}