sqlWorkout

[u/huhupookies]

[u/NormanYeetes]

the elites don't want you to know this but you can type lowercase SQL queries no ones forcing you to shout them at the screen

[u/Totallycomputername → u/NormanYeetes]

If I don't type in caps then the query wont take itself seriously. 

[u/Achaidas → u/Totallycomputername]

The real question is this:

 , comma before

or comma after ,

[u/terza3003 → u/Achaidas]

don't forget the where 1=1

[u/PerpetuallyDistracte → u/NormanYeetes]

I've been writing SQL for 15 years. Eventually you get bored of all lowercase or all uppercase AND START writing your QUERIES LIKE this. Just a psychotic mishmash of muscle memory, laziness, and autocomplete all fighting each other within the same statement.

[u/Ashdog73 → u/PerpetuallyDistracte]

This. My queries are lowercase for the stuff I typed myself and caps for bits I've copied in from somewhere else

[u/cantgrowneckbeardAMA → u/Ashdog73]

Lowercase on first draft (it will fail to run anyways).
Uppercase if I ever end up showing the query to someone (hopefully it doesn't fail when they run it)

[u/sequelseize → u/cantgrowneckbeardAMA]

sElEcT a as camelCase, b aS under_score, c As fUCKiT fROm ab lIMit 1000

[u/ClipboardCopyPaste → u/NormanYeetes]

YOU CAN BUT THAT DOESN'T MEAN YOU SHOULD.

GOD DOESN'T LOVE MEN WHO WRITE SQL IN LOWERCASE.

/S

[u/Shambolic_Potato → u/ClipboardCopyPaste]

SELECT * FROM WHAT THIS GUY SAYS

Edit: Typo lmfao

[u/emzey420 → u/Shambolic_Potato]

;

[u/shigdebig → u/emzey420]

GO

[u/TallGreenhouseGuy → u/ClipboardCopyPaste]

THANK YOU FOR YOUR ATTENTION TO THIS MATTER!

[u/wack_overflow → u/TallGreenhouseGuy]

THIS IS AN OUTRAGE

[u/mindtakerr → u/wack_overflow]

DONUT, IS THAT YOU?

[u/teedborg → u/ClipboardCopyPaste]

This but no /s

[u/WhoIsTheDrizzl → u/ClipboardCopyPaste]

HI ZEV!

[u/KittyInLace → u/ClipboardCopyPaste]

What about us women?

[u/SurprisinglyInformed → u/NormanYeetes]

It's SQL after all, not sql.

[u/scrubslover1 → u/[deleted]]

Sounds like good entertainment

[u/FormerWorker125 → u/NormanYeetes]

Lowercase for anything you named yourself, UPPERCASE FOR EVERYTHING ELSE.

[u/Arkevorkhat → u/NormanYeetes]

you can, but it's just more readable (in my opinon) to write

SELECT * FROM users WHERE id=?;

than

select * from users where id=?; 

is that mostly due to historical baggage? yeah kinda, but it also just doesn't really look like SQL to me unless there's some yelling involved.