{"id":4492,"date":"2025-08-28T12:30:07","date_gmt":"2025-08-28T03:30:07","guid":{"rendered":"https:\/\/www.kinryo.net\/?p=4492"},"modified":"2025-08-31T15:49:32","modified_gmt":"2025-08-31T06:49:32","slug":"mariadb%e3%81%a7date%e3%81%ae%e3%82%ab%e3%83%a9%e3%83%a0%e3%81%abnull%e3%82%92%e8%aa%8d%e3%82%81%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.kinryo.net\/?p=4492","title":{"rendered":"mariadb\u3067date\u306e\u30ab\u30e9\u30e0\u306bnull\u3092\u8a8d\u3081\u308b mariadb Ver 15.1 Distrib 10.5.27"},"content":{"rendered":"\r\n

\u307e\u305a\u306f\u73fe\u5728\u306e\u72b6\u6cc1\u3092\u30c1\u30a7\u30c3\u30af
MariaDB [(none)]><\/span> SELECT @@SESSION.sql_mode;<\/span>
\u524d\u7565
\uff5cSTRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,<\/span>
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION \uff5c
\u3042\u308c\u30fc\u3001NO_ZERO_IN DATE \u3082NO_ZERO_DATE \u3082\u5165\u3063\u3066\u3044\u306a\u3044\u3002
\u3053\u308c\u304cDATE\u30ab\u30e9\u30e0\u306bnull\u304c\u8a8d\u3081\u3089\u308c\u306a\u3044\u304c\u3001\u5165\u3063\u3066\u3044\u306a\u3044\u306e\u3067STRICT_TRANS_TABLES\u3060\u3051\u3092\u524a\u9664\u3059\u308b<\/span><\/span>
MariaDB [(none)]><\/span> SET SESSION sql_mode = ‘ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;<\/span>
\u3046\u3093\u3067\u3001\u518d\u5ea6\u30c1\u30a7\u30c3\u30af<\/span>
MariaDB [(none)]><\/span> SELECT @@SESSION.sql_mode;<\/span>
| ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,<\/span>
NO_ENGINE_SUBSTITUTION |
<\/span>STRICT_TRANS_TABLES<\/span>\u3092\u53d6\u308b\u3068\u3001NO_ZERO_IN DATE \u3084 NO_ZERO_DATE<\/span>\u304c\u5165\u3063\u3066\u3044\u3066\u3082\u3001\u30ef\u30fc\u30cb\u30f3\u30b0\u3092\u51fa\u3057\u3001\u30c7\u30fc\u30bf\u30fc\u306f\u4fdd\u5b58\u3055\u308c\u308b\u3088\u3046\u3060\u3002

\u3067\u3082\u3001\u5b9f\u969b\u306bdate\u30ab\u30e9\u30e0\u304c””(\u7a7a\u767d)\u306b\u306a\u3063\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30fc\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u3002(\u539f\u56e0\u306f\u4e0d\u660e\u3001sql_mode\u3067\u306f\u8868\u793a\u3055\u308c\u306a\u3044\u304c\u3001\u3069\u3046\u3082NO_ZERO_IN DATE \u3084 NO_ZERO_DATE<\/span>\u304c\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u304b\u306a\uff1f\uff09
\u306a\u306e\u3067\u518d\u5ea6\u3001NO_ENGINE_SUBSTITUTION \u3060\u3051\u3092\u6709\u52b9\u306b\u3057\u3066
MariaDB [(none)]> <\/span>SET SESSION sql_mode = ‘NO_ENGINE_SUBSTITUTION’;<\/span>
<\/span>\u3067\u3001\u518d\u5ea6\u30a4\u30f3\u30dd\u30fc\u30c8
MariaDB [(none)]><\/span><\/span> LOAD DATA INFILE \u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9 INTO \u30c6\u30fc\u30d6\u30eb\u540d FIELDS TERMINATED BY ‘\\T’ IGNORE 1 ROWS<\/span>
\u3084\u3063\u3068\u3001date\u30ab\u30e9\u30e0\u304c\u7a7a\u767d\u306b\u306a\u3063\u3066\u3044\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u304c\u51fa\u6765\u305f\u3002<\/p>\r\n\r\n\r\n","protected":false},"excerpt":{"rendered":"

\u307e\u305a\u306f\u73fe\u5728\u306e\u72b6\u6cc1\u3092\u30c1\u30a7\u30c3\u30afMariaDB [(none)]> SELECT @@SESSION.sql_mode;\u524d\u7565\uff5cSTRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO, … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"vkexunit_cta_each_option":"","footnotes":""},"categories":[10],"tags":[],"class_list":["post-4492","post","type-post","status-publish","format-standard","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/4492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4492"}],"version-history":[{"count":7,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/4492\/revisions"}],"predecessor-version":[{"id":4509,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=\/wp\/v2\/posts\/4492\/revisions\/4509"}],"wp:attachment":[{"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kinryo.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}