{"id":9129,"date":"2023-12-14T21:58:09","date_gmt":"2023-12-14T12:58:09","guid":{"rendered":"https:\/\/www.xenos.jp\/~zen\/blog2\/?p=9129"},"modified":"2023-12-14T21:58:11","modified_gmt":"2023-12-14T12:58:11","slug":"post-9129","status":"publish","type":"post","link":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/2023\/12\/14\/post-9129\/","title":{"rendered":"Google Cloud SQL\u306eMySQL\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u5909\u66f4\u3059\u308b"},"content":{"rendered":"\n

Google Cloud SQL\u3067MySQL\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u3068\u3001\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u304cUTC\u306b\u306a\u308b\u3002\u3053\u308c\u3092\u3001\u65e5\u672c\u306b\u5909\u3048\u308b\u65b9\u6cd5\u306e\u30e1\u30e2\u3002<\/p>\n\n\n\n

\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u78ba\u8a8d\u306eSQL\u3068\u5b9f\u884c\u4f8b\u3002<\/p>\n\n\n\n

MySQL [(none)]> SHOW VARIABLES LIKE '%time_zone%'\n    -> ;\n+------------------+--------+\n| Variable_name    | Value  |\n+------------------+--------+\n| system_time_zone | UTC    |\n| time_zone        | SYSTEM |\n+------------------+--------+\n2 rows in set (0.157 sec)\nMySQL [(none)]><\/code><\/pre>\n\n\n\n
\u5909\u66f4\u65b9\u6cd5<\/p>\n\n\n\n
1. Google Cloud\u306e\u7ba1\u7406\u753b\u9762\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u3001SQL\u306e\u7ba1\u7406\u753b\u9762\u3092\u958b\u304f\u3002<\/p>\n\n\n\n
2. \u8a2d\u5b9a\u5909\u66f4\u3059\u308b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u958b\u304f\u3002<\/p>\n\n\n\n
3. \u4e0a\u90e8\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u958b\u304f\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<\/p>\n\n\n\n
4. \u300c\u30d5\u30e9\u30b0\u300d\u306e\u3068\u3053\u308d\u3092\u5e83\u3052\u308b<\/p>\n\n\n\n
5. \u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30e9\u30b0\u3092\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<\/p>\n\n\n\n
6. \u30d5\u30e9\u30b0\u9078\u629e\u3067\u3001\u300cdefault_time_zone\u300d\u3092\u9078\u629e\u3059\u308b\u3002<\/p>\n\n\n\n
7. \u5024\u306b\u3001\u300cAsia\/Tokyo\u300d\u3092\u5165\u529b\u3059\u308b\uff08\u9078\u629e\u3067\u306f\u306a\u304f\u3066\u3001\u5165\u529b\u3059\u308b\uff09\u3002<\/p>\n\n\n\n
8. \u4fdd\u5b58\u3059\u308b\u3002<\/p>\n\n\n\n
9. \u4fdd\u5b58\u5f8c\u306b\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u518d\u8d77\u52d5\u304c\u5fc5\u8981\u306b\u306a\u308b\u306e\u3067\u3001\u518d\u8d77\u52d5\u3059\u308b\u3002<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u8a2d\u5b9a\u5909\u66f4\u5f8c\u306b\u78ba\u8a8d\u3057\u305f\u4f8b\u3002<\/p>\n\n\n\n
\u30b7\u30b9\u30c6\u30e0\u5074\u306fUTC\u306e\u307e\u307e\u3060\u304c\u3001\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3068\u304d\uff08\u30bb\u30c3\u30b7\u30e7\u30f3\uff09\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306f\u3001Asia\/Tokyo\u306b\u5909\u308f\u3063\u3066\u304a\u308a\u3001\u73fe\u5728\u6642\u523b\u3092\u53d6\u5f97\u3057\u305f\u969b\u306e\u6642\u9593\u3082\u65e5\u672c\u6642\u9593\u306b\u306a\u3063\u3066\u3044\u305f\u3002<\/p>\n\n\n\n
MySQL [(none)]> SHOW VARIABLES LIKE '%time_zone%';\n+------------------+------------+\n| Variable_name    | Value      |\n+------------------+------------+\n| system_time_zone | UTC        |\n| time_zone        | Asia\/Tokyo |\n+------------------+------------+\n2 rows in set (0.159 sec)\nMySQL [(none)]> select now();\n+---------------------+\n| now()               |\n+---------------------+\n| 2023-12-11 13:50:43 |\n+---------------------+\n1 row in set (0.154 sec)\nMySQL [(none)]><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Google Cloud SQL\u3067MySQL\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u3068\u3001\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u304cUTC\u306b\u306a\u308b\u3002\u3053\u308c\u3092\u3001\u65e5\u672c\u306b\u5909\u3048\u308b\u65b9\u6cd5\u306e\u30e1\u30e2\u3002 \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u78ba\u8a8d\u306eSQL\u3068\u5b9f\u884c\u4f8b\u3002 \u5909\u66f4\u65b9\u6cd5 1. Google Cloud\u306e\u7ba1\u7406\u753b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7],"tags":[92,49],"class_list":["post-9129","post","type-post","status-publish","format-standard","hentry","category-tech","category-tech-memo","tag-google","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/9129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/comments?post=9129"}],"version-history":[{"count":1,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/9129\/revisions"}],"predecessor-version":[{"id":9131,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/9129\/revisions\/9131"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=9129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=9129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=9129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}