Comment on Spent half an hour on it. Felt good.

rtxn@lemmy.world ⁨3⁩ ⁨days⁩ ago

• Dave@lemmy.nz ⁨3⁩ ⁨days⁩ ago

  Do people actually write SQL in all caps? Ever since I was a boy I’ve always written SQL (and HTML) in lower case.

  source

  • PotatoesFall@discuss.tchncs.de ⁨3⁩ ⁨days⁩ ago

    I do it because it helps me visually separate SQL keywords from table and column names.

    Helps especially when your SQL is embedded in another file so there is no syntax highlighting.

    source

    • Dave@lemmy.nz ⁨3⁩ ⁨days⁩ ago

      That’s a good reason. I guess when I’m directly writing SQL the queries are point in time and not part of some enduring codebase.

      source
  • svc@lemmy.frozeninferno.xyz ⁨3⁩ ⁨days⁩ ago

    YEAH, THAT’S WHY HE PRESSED CAPSLOCK

    source
  • umbraroze@lemmy.world ⁨3⁩ ⁨days⁩ ago

    SQL is an Old Language of Ancient Power. You have to write the keywords in all caps.

    (Fortran is basically the same, but it’s rarer. Lisp is too, but you don’t need to capitalise everything, as the Ancient Power is contained in the parentheses.)

    source

    • Hupf@feddit.org ⁨2⁩ ⁨days⁩ ago

      xkcd.com/297/

      source
    • SeboBear@discuss.tchncs.de ⁨3⁩ ⁨days⁩ ago

      This just made my day 😂

      source
  • cobysev@lemmy.world ⁨3⁩ ⁨days⁩ ago

    They’re both acronyms, so yes? You always write acronyms in upper case.

    Structured Query Language (SQL)

    HyperText Markup Language (HTML)

    Some exceptions to the rule exist, like “Database” is usually abbreviated as Db in acronyms. For instance, IMDb (Internet Movie Database).

    Although considering database is a singular word, it makes sense to lower-case the middle letter of the word, as it wouldn’t be capitalized in the spelled-out word anyway.

    source

    • Dave@lemmy.nz ⁨3⁩ ⁨days⁩ ago

      Not sure if joking but I meant the language not the acronym.

      source

      • cobysev@lemmy.world ⁨3⁩ ⁨days⁩ ago

        SQL is the language. Its name is also an acronym, for “Structured Query Language.”

        source

        • -> View More Comments
• ZILtoid1991@lemmy.world ⁨3⁩ ⁨days⁩ ago

  '; DROP TABLE *
  

  source

  • flyingSock@feddit.org ⁨3⁩ ⁨days⁩ ago

    Such a sparkly string must be good.

    source

    • ByteJunk@lemmy.world ⁨3⁩ ⁨days⁩ ago

      What do you mean? That’s a surname.

      source

      • fulcrummed@lemmy.world ⁨2⁩ ⁨days⁩ ago

        Lil Bobby… there really is an xkcd for everything!

        source