{"id":1387,"date":"2017-09-08T16:14:35","date_gmt":"2017-09-08T14:14:35","guid":{"rendered":"https:\/\/www.speich.net\/articles\/?p=1387"},"modified":"2019-11-16T18:05:10","modified_gmt":"2019-11-16T17:05:10","slug":"why-i-love-jetbrains-phpstorm-sql-group-by-handling","status":"publish","type":"post","link":"https:\/\/www.speich.net\/articles\/en\/2017\/09\/08\/why-i-love-jetbrains-phpstorm-sql-group-by-handling\/","title":{"rendered":"Why I love PhpStorm: SQL GROUP BY handling"},"content":{"rendered":"<p>Here&#8217;s another post from my series why I love <a href=\"https:\/\/www.jetbrains.com\/phpstorm\/\" target=\"_blank\" rel=\"noopener noreferrer\">JetBrains PhpStorm<\/a>. This is a SQL query, where I have I list of column names. The IDE not only marks the columns missing in the GROUP BY clause as errors, it also offers an option to fix it for you by adding them to the GROUP BY clause.<\/p>\n<figure id=\"attachment_1388\" aria-describedby=\"caption-attachment-1388\" style=\"width: 675px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1388 size-full\" src=\"https:\/\/www.speich.net\/wp\/wp-content\/uploads\/2017\/09\/screenshot-sql.gif\" alt=\"\" width=\"675\" height=\"502\"><figcaption id=\"caption-attachment-1388\" class=\"wp-caption-text\">PhpStorm understands SQL mixed with PHP code.<\/figcaption><\/figure>\n<p>More PhpStorm love:<br \/>\n<a href=\"https:\/\/www.speich.net\/articles\/en\/2011\/05\/15\/why-i-love-jetbrains-phpstorm-ii\/\">SQL table aliases<\/a><br \/>\n<a href=\"https:\/\/www.speich.net\/articles\/en\/2010\/07\/16\/javascript-and-dojo-with-phpstorm\/\">JavaScript code completion with dojo<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s another post from my series why I love JetBrains PhpStorm. This is a SQL query, where I have I list of column names. The IDE not only marks the columns missing in the GROUP BY clause as errors, it also offers an option to fix it for you by adding them to the GROUP &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.speich.net\/articles\/en\/2017\/09\/08\/why-i-love-jetbrains-phpstorm-sql-group-by-handling\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Why I love PhpStorm: SQL GROUP BY handling&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,281],"tags":[250,75,81],"class_list":["post-1387","post","type-post","status-publish","format-standard","hentry","category-others","category-sql","tag-jetbrains","tag-phpstorm","tag-sql","entry"],"_links":{"self":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts\/1387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/comments?post=1387"}],"version-history":[{"count":11,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts\/1387\/revisions"}],"predecessor-version":[{"id":1731,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts\/1387\/revisions\/1731"}],"wp:attachment":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/media?parent=1387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/categories?post=1387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/tags?post=1387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}