Why I love PhpStorm: SQL GROUP BY handling

Here’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 BY clause.

PhpStorm understands SQL mixed with PHP code.

More PhpStorm love:
SQL table aliases
JavaScript code completion with dojo

2 thoughts on “Why I love PhpStorm: SQL GROUP BY handling

  1. Pingback: Why I love JetBrains PhpStorm: SQL table aliases – Articles

  2. Pingback: Why I love Jetbrains PhpStorm: JavaScript code completion with dojo – Articles

Leave a Reply

Your email address will not be published. Required fields are marked *