{"id":76,"date":"2023-03-23T22:53:12","date_gmt":"2023-03-23T14:53:12","guid":{"rendered":"https:\/\/btc354.com\/?p=76"},"modified":"2023-03-24T16:48:48","modified_gmt":"2023-03-24T08:48:48","slug":"mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6","status":"publish","type":"post","link":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/","title":{"rendered":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066"},"content":{"rendered":"<p>MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u304c\u6e9c\u307e\u308a\u3001\u524a\u9664\u3059\u308b\u969b\u306b\u300crm\u300d\u30b3\u30de\u30f3\u30c9\u3067<\/p>\n<p>\u30d5\u30a1\u30a4\u30eb\u3092\u6d88\u3057\u3066\u3057\u307e\u3046\u4eba\u3092\u3057\u3070\u3057\u3070\u898b\u307e\u3059\u3002<br \/>\n\u524a\u9664\u3067\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u304c\u3001MySQL\u306f\u8a8d\u8b58\u3057\u305f\u307e\u307e\u306a\u306e\u3067\u3001\u3061\u3083\u3093\u3068<br \/>\n\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u3010\u524a\u9664\u65b9\u6cd5\u3011<br \/>\n\u2460\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u72b6\u614b\u306e\u78ba\u8a8d\uff08\u203b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b8\u30e7\u30f3\u4f7f\u7528\u306e\u5834\u5408\uff09<br \/>\n\u30b9\u30ec\u30d6\u5168\u53f0\u306b\u3066\u3000\u3069\u3053\u307e\u3067\u4f1d\u642c\u3057\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3092\u3057\u307e\u3057\u3087\u3046\uff01<\/p>\n<p>show slave status \\G<\/p>\n<p>\u2461\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664<br \/>\nshow master logs;<\/p>\n<p>purge master logs to \u2018mysql-bin.010\u2019;<br \/>\n\u203bmysql-bin.009\u307e\u3067\u304c\u524a\u9664\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>show master logs;<\/p>\n<p>\u203bbinary \u3068 master \u306f\u540c\u7fa9\u8a9e\u3067\u3059\u3002<br \/>\n\u3010\u5099\u8003\u3011<br \/>\n\u4e00\u5b9a\u6642\u9593\u304c\u7d4c\u904e\u3057\u305f\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u3092\u81ea\u52d5\u7684\u306b\u524a\u9664\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u2460my.cnf\u306b\u3066\u4e0b\u8a18\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\u203bmy.cnf\u306b\u8a18\u8f09\u3057\u305f\u3060\u3051\u3067\u306f\u53cd\u6620\u3055\u308c\u307e\u305b\u3093\u3002MySQL\u518d\u8d77\u52d5\u3082\u3057\u304f\u306fset global\u3067\u306e\u8a2d\u5b9a\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<p>expire_logs_days : \u8a2d\u5b9a\u3055\u308c\u305f\u65e5\u6570\u304c\u7d4c\u904e\u3057\u305f\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306f\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u308b\u3002 \u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u3001\u81ea\u52d5\u524a\u9664\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u4f8b\uff09\/etc\/my.cnf<br \/>\n[mysqld] \u2026<br \/>\nexpire_logs_days = 7<br \/>\n\u2461 set global\u3092\u4f7f\u3063\u3066\u8a2d\u5b9a\u3092\u5909\u66f4<br \/>\n$ mysql -u\u30e6\u30fc\u30b6\u540d -p \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d<br \/>\nEnter password: [\u30d1\u30b9\u30ef\u30fc\u30c9]<\/p>\n<p>show global variables like \u2018expire_logs_days\u2019;<br \/>\nset global expire_logs_days = 7;<br \/>\nshow global variables like \u2018expire_logs_days\u2019;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u304c\u6e9c\u307e\u308a\u3001\u524a\u9664\u3059\u308b\u969b\u306b\u300crm\u300d\u30b3\u30de\u30f3\u30c9\u3067 \u30d5\u30a1\u30a4\u30eb\u3092\u6d88\u3057\u3066\u3057\u307e\u3046\u4eba\u3092\u3057\u3070\u3057\u3070\u898b\u307e\u3059\u3002  [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-76","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066 - \u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066 - \u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9\" \/>\n<meta property=\"og:description\" content=\"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u304c\u6e9c\u307e\u308a\u3001\u524a\u9664\u3059\u308b\u969b\u306b\u300crm\u300d\u30b3\u30de\u30f3\u30c9\u3067 \u30d5\u30a1\u30a4\u30eb\u3092\u6d88\u3057\u3066\u3057\u307e\u3046\u4eba\u3092\u3057\u3070\u3057\u3070\u898b\u307e\u3059\u3002 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066\/\" \/>\n<meta property=\"og:site_name\" content=\"\u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-23T14:53:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-24T08:48:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/btc354.com\/wp-content\/uploads\/2023\/03\/1511759270.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"tan, keito\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@tqd354\" \/>\n<meta name=\"twitter:site\" content=\"@tqd354\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"tan, keito\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/\"},\"author\":{\"name\":\"tan, keito\",\"@id\":\"https:\\\/\\\/btc354.com\\\/#\\\/schema\\\/person\\\/00e13932981b0e8ae19d3ae6b5734178\"},\"headline\":\"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066\",\"datePublished\":\"2023-03-23T14:53:12+00:00\",\"dateModified\":\"2023-03-24T08:48:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/\"},\"wordCount\":65,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/#\\\/schema\\\/person\\\/00e13932981b0e8ae19d3ae6b5734178\"},\"image\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/1511759270.png\",\"articleSection\":[\"mysql\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/\",\"url\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/\",\"name\":\"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066 - \u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/1511759270.png\",\"datePublished\":\"2023-03-23T14:53:12+00:00\",\"dateModified\":\"2023-03-24T08:48:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#primaryimage\",\"url\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/1511759270.png\",\"contentUrl\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/1511759270.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/2023\\\/03\\\/23\\\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\\\/\\\/btc354.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/btc354.com\\\/#website\",\"url\":\"https:\\\/\\\/btc354.com\\\/\",\"name\":\"\u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9\",\"description\":\"tiro354\",\"publisher\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/#\\\/schema\\\/person\\\/00e13932981b0e8ae19d3ae6b5734178\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/btc354.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/btc354.com\\\/#\\\/schema\\\/person\\\/00e13932981b0e8ae19d3ae6b5734178\",\"name\":\"tan, keito\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/cropped-tiro354_logo7-1.png\",\"url\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/cropped-tiro354_logo7-1.png\",\"contentUrl\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/cropped-tiro354_logo7-1.png\",\"width\":1023,\"height\":1023,\"caption\":\"tan, keito\"},\"logo\":{\"@id\":\"https:\\\/\\\/btc354.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/cropped-tiro354_logo7-1.png\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/tqd354\"],\"url\":\"https:\\\/\\\/btc354.com\\\/index.php\\\/author\\\/tanqidong\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066 - \u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066\/","og_locale":"zh_CN","og_type":"article","og_title":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066 - \u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9","og_description":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u304c\u6e9c\u307e\u308a\u3001\u524a\u9664\u3059\u308b\u969b\u306b\u300crm\u300d\u30b3\u30de\u30f3\u30c9\u3067 \u30d5\u30a1\u30a4\u30eb\u3092\u6d88\u3057\u3066\u3057\u307e\u3046\u4eba\u3092\u3057\u3070\u3057\u3070\u898b\u307e\u3059\u3002 [&hellip;]","og_url":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066\/","og_site_name":"\u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9","article_published_time":"2023-03-23T14:53:12+00:00","article_modified_time":"2023-03-24T08:48:48+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/btc354.com\/wp-content\/uploads\/2023\/03\/1511759270.png","type":"image\/png"}],"author":"tan, keito","twitter_card":"summary_large_image","twitter_creator":"@tqd354","twitter_site":"@tqd354","twitter_misc":{"\u4f5c\u8005":"tan, keito"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#article","isPartOf":{"@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/"},"author":{"name":"tan, keito","@id":"https:\/\/btc354.com\/#\/schema\/person\/00e13932981b0e8ae19d3ae6b5734178"},"headline":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066","datePublished":"2023-03-23T14:53:12+00:00","dateModified":"2023-03-24T08:48:48+00:00","mainEntityOfPage":{"@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/"},"wordCount":65,"commentCount":0,"publisher":{"@id":"https:\/\/btc354.com\/#\/schema\/person\/00e13932981b0e8ae19d3ae6b5734178"},"image":{"@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#primaryimage"},"thumbnailUrl":"https:\/\/btc354.com\/wp-content\/uploads\/2023\/03\/1511759270.png","articleSection":["mysql"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/","url":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/","name":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066 - \u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9","isPartOf":{"@id":"https:\/\/btc354.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#primaryimage"},"image":{"@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#primaryimage"},"thumbnailUrl":"https:\/\/btc354.com\/wp-content\/uploads\/2023\/03\/1511759270.png","datePublished":"2023-03-23T14:53:12+00:00","dateModified":"2023-03-24T08:48:48+00:00","breadcrumb":{"@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#primaryimage","url":"https:\/\/btc354.com\/wp-content\/uploads\/2023\/03\/1511759270.png","contentUrl":"https:\/\/btc354.com\/wp-content\/uploads\/2023\/03\/1511759270.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/btc354.com\/index.php\/2023\/03\/23\/mysql-%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e5%89%8a%e9%99%a4%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/btc354.com\/"},{"@type":"ListItem","position":2,"name":"MySQL \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u524a\u9664\u306b\u3064\u3044\u3066"}]},{"@type":"WebSite","@id":"https:\/\/btc354.com\/#website","url":"https:\/\/btc354.com\/","name":"\u4e2a\u4eba\u5b66\u4e60\u7ad9\u70b9","description":"tiro354","publisher":{"@id":"https:\/\/btc354.com\/#\/schema\/person\/00e13932981b0e8ae19d3ae6b5734178"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/btc354.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/btc354.com\/#\/schema\/person\/00e13932981b0e8ae19d3ae6b5734178","name":"tan, keito","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/btc354.com\/wp-content\/uploads\/2025\/01\/cropped-tiro354_logo7-1.png","url":"https:\/\/btc354.com\/wp-content\/uploads\/2025\/01\/cropped-tiro354_logo7-1.png","contentUrl":"https:\/\/btc354.com\/wp-content\/uploads\/2025\/01\/cropped-tiro354_logo7-1.png","width":1023,"height":1023,"caption":"tan, keito"},"logo":{"@id":"https:\/\/btc354.com\/wp-content\/uploads\/2025\/01\/cropped-tiro354_logo7-1.png"},"sameAs":["https:\/\/x.com\/tqd354"],"url":"https:\/\/btc354.com\/index.php\/author\/tanqidong\/"}]}},"_links":{"self":[{"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":1,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/posts\/76\/revisions"}],"predecessor-version":[{"id":77,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/posts\/76\/revisions\/77"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/media\/108"}],"wp:attachment":[{"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/media?parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/categories?post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/btc354.com\/index.php\/wp-json\/wp\/v2\/tags?post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}