{"id":1570,"date":"2012-04-10T02:15:44","date_gmt":"2012-04-09T17:15:44","guid":{"rendered":"http:\/\/codaholic.org\/?p=1570"},"modified":"2020-08-19T00:41:38","modified_gmt":"2020-08-18T15:41:38","slug":"mysql%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%81%ae%e6%a7%8b%e9%80%a0%e3%82%92%e8%a1%a8%e7%a4%ba%e3%81%99%e3%82%8b%e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89","status":"publish","type":"post","link":"https:\/\/codaholic.org\/?p=1570","title":{"rendered":"[MySQL] \u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3092\u8868\u793a\u3059\u308b\u30b3\u30de\u30f3\u30c9"},"content":{"rendered":"<p>\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3092\u8868\u793a\u3059\u308b\u306b\u306fMySQL\u306b\u30ed\u30b0\u30a4\u30f3\u5f8c\u3001\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n<pre><code class=\"language-sql\">show columns from TABLENAME;\n<\/code><\/pre>\n<p>\u51fa\u529b\u7d50\u679c\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u3061\u306a\u307f\u306b\u4e0b\u8a18\u306e\u30c6\u30fc\u30d6\u30eb\u306fMovable Type 4.2\u306emt_entry\u30c6\u30fc\u30d6\u30eb\u3067\u3059\u3002<\/p>\n<pre><code>+----------------------+--------------+------+-----+---------+----------------+\n| Field                | Type         | Null | Key | Default | Extra          |\n+----------------------+--------------+------+-----+---------+----------------+\n| entry_id             | int(11)      | NO   | PRI | NULL    | auto_increment |\n| entry_allow_comments | tinyint(4)   | YES  |     | NULL    |                |\n| entry_allow_pings    | tinyint(4)   | YES  |     | NULL    |                |\n| entry_atom_id        | varchar(255) | YES  |     | NULL    |                |\n| entry_author_id      | int(11)      | NO   | MUL | NULL    |                |\n| entry_authored_on    | datetime     | YES  |     | NULL    |                |\n| entry_basename       | varchar(255) | YES  |     | NULL    |                |\n| entry_blog_id        | int(11)      | NO   | MUL | NULL    |                |\n| entry_category_id    | int(11)      | YES  |     | NULL    |                |\n| entry_class          | varchar(255) | YES  | MUL | entry   |                |\n| entry_comment_count  | int(11)      | YES  | MUL | 0       |                |\n| entry_convert_breaks | varchar(30)  | YES  |     | NULL    |                |\n| entry_created_by     | int(11)      | YES  |     | NULL    |                |\n| entry_created_on     | datetime     | YES  | MUL | NULL    |                |\n| entry_excerpt        | mediumtext   | YES  |     | NULL    |                |\n| entry_keywords       | mediumtext   | YES  |     | NULL    |                |\n| entry_modified_by    | int(11)      | YES  |     | NULL    |                |\n| entry_modified_on    | datetime     | YES  | MUL | NULL    |                |\n| entry_ping_count     | int(11)      | YES  |     | 0       |                |\n| entry_pinged_urls    | mediumtext   | YES  |     | NULL    |                |\n| entry_status         | smallint(6)  | NO   | MUL | NULL    |                |\n| entry_tangent_cache  | mediumtext   | YES  |     | NULL    |                |\n| entry_template_id    | int(11)      | YES  |     | NULL    |                |\n| entry_text           | mediumtext   | YES  |     | NULL    |                |\n| entry_text_more      | mediumtext   | YES  |     | NULL    |                |\n| entry_title          | varchar(255) | YES  | MUL | NULL    |                |\n| entry_to_ping_urls   | mediumtext   | YES  |     | NULL    |                |\n| entry_week_number    | int(11)      | YES  |     | NULL    |                |\n+----------------------+--------------+------+-----+---------+----------------+\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3092\u8868\u793a\u3059\u308b\u306b\u306fMySQL\u306b\u30ed\u30b0\u30a4\u30f3\u5f8c\u3001\u4e0b\u8a18\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002 show columns from TABLENAME; \u51fa\u529b\u7d50\u679c\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u3061\u306a\u307f\u306b\u4e0b\u8a18\u306e\u30c6\u30fc\u30d6\u30eb\u306fMovable Type [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[43],"tags":[258],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8gd1W-pk","_links":{"self":[{"href":"https:\/\/codaholic.org\/index.php?rest_route=\/wp\/v2\/posts\/1570"}],"collection":[{"href":"https:\/\/codaholic.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codaholic.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codaholic.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codaholic.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1570"}],"version-history":[{"count":9,"href":"https:\/\/codaholic.org\/index.php?rest_route=\/wp\/v2\/posts\/1570\/revisions"}],"predecessor-version":[{"id":2373,"href":"https:\/\/codaholic.org\/index.php?rest_route=\/wp\/v2\/posts\/1570\/revisions\/2373"}],"wp:attachment":[{"href":"https:\/\/codaholic.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codaholic.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codaholic.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}