3 ms·
I also use UPPER case for SQL Keywords to visually distinguish them from user-defined names (i.e. similar purpose to syntax coloring), but I don't collapse SELE
by mythz 10y ago
I also use UPPER case for SQL Keywords to visually distinguish them from user-defined names (i.e. similar purpose to syntax coloring), but I don't collapse SELECT over multiple lines and line up each statement so the conditions line-up, e.g:
SELECT foo, bar
FROM baz
WHERE foo > 3
AND bar = 'craig.kerstiens@gmail.com'
- alistairbayley 10y agoRe uppercase: can't afford a syntax-highlighting editor?
- Sean1708 10y agoIt's true that there are some editors which highlight SQL inside strings, but most don't.
- bhrgunatha 10y agoThat covers the simplest case. What would you do when you're selecting 20 columns from 5 different tables joined together?