{"id":741,"date":"2023-06-02T22:31:51","date_gmt":"2023-06-02T14:31:51","guid":{"rendered":"http:\/\/pony.xin\/?p=741"},"modified":"2026-03-08T19:22:28","modified_gmt":"2026-03-08T11:22:28","slug":"navicat-mysql%e6%95%b0%e6%8d%ae%e8%bf%81%e7%a7%bb%e6%8a%a5%e9%94%991067-invalid-default-value-for-xxx","status":"publish","type":"post","link":"https:\/\/lnmp.ivan.xin\/?p=741","title":{"rendered":"navicat  MySQL\u6570\u636e\u8fc1\u79fb\u62a5\u95191067 - Invalid default value for 'xxx'"},"content":{"rendered":"<p>\u6267\u884c\u547d\u4ee4 select @@GLOBAL.sql_mode;<br \/>\n\u5f97\u5230<br \/>\nONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION<\/p>\n<p>\u539f\u56e0\u5728\u4e8eNO_ZERO_IN_DATE,NO_ZERO_DATE\u8fd9\u4e24\u4e2a\u53c2\u6570\uff0c\u9700\u8981\u628a\u5b83\u4eec\u53bb\u6389<\/p>\n<p>\u65b9\u6cd5\uff1a\u5728my.cnf\u4e2d\u6dfb\u52a0 sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION<br \/>\n\u91cd\u542f\u6570\u636e\u5e93<\/p>\n<p>\u53e6\u5916\u4e00\u79cd\u65b9\u6cd5\uff0c\u662f\u4e34\u65f6\u89e3\u51b3\u95ee\u9898\uff1a\u5728\u5df2\u7ecf\u8f6c\u50a8\u7684sql\u6587\u4ef6\u4e2d\uff0c\u7b2c\u4e00\u884c\u6dfb\u52a0\u4e00\u53e5<br \/>\nSET @@sql_mode = '';<br \/>\n\u518d\u8fd0\u884csql\u6587\u4ef6\u5c31\u4e0d\u4f1a\u62a5\u9519\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6267\u884c\u547d\u4ee4 select @@GLOBAL.sql_mode; \u5f97\u5230 ONLY_FULL_GROUP_BY,ST...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15330],"tags":[],"class_list":["post-741","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=741"}],"version-history":[{"count":4,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/741\/revisions"}],"predecessor-version":[{"id":904,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/741\/revisions\/904"}],"wp:attachment":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}