57

DO NOT USE LOWERCASE IN SQL, STUPID.

Comments
  • 9
  • 2
    No, if I use caps lock, I forget that and then wonder why nothing shows up when googling something uppercase
  • 21
    WHY DO I HAVE TO YELL TO WRITE A QUERY?
  • 35
    @TheHatBandit It responds faster if you shout
  • 2
  • 2
    No 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!
  • 4
    @omomthings i have found that its easier to understand long queries or see where you left off doing the query in uppercase
  • 11
    names in lower case, RESERVED WORDS IN UPPER CASE
  • 1
    oops
  • 1
    Uppercase for all reserved words, and camelCase for user defined words.
    Keep it simple.
  • 0
    @nicnaknic but why? These aren't the BASIC days anymore.
  • 0
    @Ashkin but for SQL it makes it easy to determine what is a language name or a user defined name. Works for me 👍
  • 2
    I 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.
Add Comment