Writing more legible SQL

Re:Writing more legible SQL by berntb on Thursday November 03, 2016 @05:26AM (#12862526)

Why not this?

  WHERE A
    AND B
    AND C

Or better, this? You can comment out any part easily.

  WHERE 1
    AND A
    AND B
    AND C

(With keywords capitalized, as g-d intended. :-) Or not.)

[ Parent | on HN ]

Re:Writing more legible SQL by nerdponx on Thursday November 03, 2016 @07:02AM (#12862885)

I like the "WHERE 1" trick, thanks!

[ Parent | on HN ]