{"id":673,"date":"2022-01-29T16:33:41","date_gmt":"2022-01-29T07:33:41","guid":{"rendered":"https:\/\/josejose.tokyo\/?p=668"},"modified":"2022-01-29T16:33:41","modified_gmt":"2022-01-29T07:33:41","slug":"sql-3","status":"publish","type":"post","link":"https:\/\/josejose.net\/wordpress\/2022\/01\/29\/sql-3\/","title":{"rendered":"SQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">ELECT \u8fb2\u5bb6\u540d, SUM(\u91d1\u984d) FROM article7 WHERE \u65e5\u6642 BETWEEN &#8216;2022-01-11&#8217; AND &#8216;2022-01-25&#8217; GROUP BY \u8fb2\u5bb6\u540d, \u7d44\u52d8\u756a\u53f7 ORDER BY \u7d44\u52d8\u756a\u53f7;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3069\u3046\u3082 ORDER BY\u3092\u4f7f\u3046\u3068\u304d\u306b GROUP BY\u306e\u3068\u3053\u308d\u306b\u3082 \u5165\u308c\u306a\u304d\u3083\u3060\u3081\u307f\u305f\u3044\u3060<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT \u8fb2\u5bb6\u540d, SUM(\u91d1\u984d) FROM article7 WHERE \u65e5\u6642 BETWEEN &#8216;2022-01-11&#8217; AND &#8216;2022-01-25&#8217; GROUP BY \u8fb2\u5bb6\u540d ORDER BY \u7d44\u52d8\u756a\u53f7;<br>ERROR 1055 (42000): Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column &#8216;media.article7.\u7d44\u52d8\u756a\u53f7&#8217; which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3068\u306a\u308b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ELECT \u8fb2\u5bb6\u540d, SUM(\u91d1\u984d) FROM article7 WHERE \u65e5\u6642 BETWEEN &#8216;2022-01-11&#8217; AND &#8216;2022-01-25&#8217; GROUP  &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/josejose.net\/wordpress\/2022\/01\/29\/sql-3\/\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;SQL&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":3,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-673","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/posts\/673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/comments?post=673"}],"version-history":[{"count":0,"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/posts\/673\/revisions"}],"wp:attachment":[{"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/media?parent=673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/categories?post=673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/josejose.net\/wordpress\/wp-json\/wp\/v2\/tags?post=673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}