Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
Mitiko63558yNo, if I use caps lock, I forget that and then wonder why nothing shows up when googling something uppercase
-
omom13618yNo but seriously, I have been always wondering where that upper case thing came from.. it's not a norme it's just a habit, just googled that yesterday!
-
@omomthings i have found that its easier to understand long queries or see where you left off doing the query in uppercase
-
johnDoe32338yUppercase for all reserved words, and camelCase for user defined words.
Keep it simple. -
johnDoe32338y@Ashkin but for SQL it makes it easy to determine what is a language name or a user defined name. Works for me 👍
-
Root825088yI put keywords on the left with two spaces between them and the rest of the line. Makes the query extremely easy to read at a glance:
select *
from users
left join councillor
on councillor.user = user.id
where user.banned_at is null
and councillor.resigned_at is null
Uppercase/lowercase doesn't really change the readability.
Related Rants
DO NOT USE LOWERCASE IN SQL, STUPID.
undefined
sql