{"id":3562,"date":"2018-07-17T10:08:28","date_gmt":"2018-07-17T02:08:28","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=3562"},"modified":"2018-07-17T10:08:28","modified_gmt":"2018-07-17T02:08:28","slug":"mysql%e4%b9%8bonly_full_group_by%e9%97%ae%e9%a2%98%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql%e4%b9%8bonly_full_group_by%e9%97%ae%e9%a2%98%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95\/","title":{"rendered":"mysql\u4e4bONLY_FULL_GROUP_BY\u95ee\u9898\u89e3\u51b3\u529e\u6cd5"},"content":{"rendered":"<p>\u95ee\u9898\uff1a mysql \u8bed\u53e5\u67e5\u8be2\u65f6: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: In aggregated query without GROUP BY, expression #25 of SELECT list contains nonaggregated column \u2018nybx.l.PUSH_TIME\u2019; this is incompatible with sql_mode=only_full_group_by\u9519\u8bef<\/p>\n<p>\u89e3\u51b3\u529e\u6cd5\u4e0bmy.cnf\uff08windows\u4e0b\u662fmy.ini\uff09\u52a0\u4ee5\u4e0b\u884c<br \/>\n[mysqld]<br \/>\nsql_mode=\u2019STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,<br \/>\nNO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,<br \/>\nNO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\u2019<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\uff1a mysql \u8bed\u53e5\u67e5\u8be2\u65f6: com.mysql.jdbc.exceptions.jdbc4.MySQLS &#8230; <a title=\"mysql\u4e4bONLY_FULL_GROUP_BY\u95ee\u9898\u89e3\u51b3\u529e\u6cd5\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql%e4%b9%8bonly_full_group_by%e9%97%ae%e9%a2%98%e8%a7%a3%e5%86%b3%e5%8a%9e%e6%b3%95\/\" aria-label=\"\u9605\u8bfb mysql\u4e4bONLY_FULL_GROUP_BY\u95ee\u9898\u89e3\u51b3\u529e\u6cd5\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10,11],"tags":[],"class_list":["post-3562","post","type-post","status-publish","format-standard","hentry","category-shujuku","category-chengxujiaoben"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/3562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=3562"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/3562\/revisions"}],"predecessor-version":[{"id":3563,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/3562\/revisions\/3563"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=3562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=3562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=3562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}