3 ms·
Personaly, I put the comma before the column name : SELECT col1 ,col2 ,col3 It's easier for me to add a column or move it like this. Otherwis
by whynotmaybe 7y ago
Personaly, I put the comma before the column name :
SELECT
col1
,col2
,col3
It's easier for me to add a column or move it like this.
Otherwise I have to search the comma when my query has only one column and I add one or when I add a column at the end
- BossingAround 7y agoI know this is a question of style, but wow that looks ugly. The point about ease of adding a new column is absolutely valid. The best answer to it, subjectively and IMHO, is on the language level, e.g. making it legal to end the statement with a comma: SELECT col1, col2, col3, from ...
- whynotmaybe 7y agoThat would definitely be a game changer... but I'm not sure I might be ready for that !