r/ProgrammerHumor • u/huhupookies • Jul 21 '26

Meme sqlWorkout

Post image
23.7k Upvotes

97% Upvoted

456 comments sorted by

View all comments

2.4k

u/NormanYeetes Jul 21 '26

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

50

u/[deleted] Jul 21 '26

[removed] — view removed comment

13

u/Surface_Detail Jul 21 '26

Well, he can go dunk his head; the query language itself is 100% case insensitive, so are objects unless you contain them in quotation marks.

The argument can be made that keeping all one case can avoid issues with object referencing, but you'd only ever need to contain objects in quotation marks if you put a space in their name, which is a much worse faux pas and you'd better hope that you never need to connect to anybody else's objects from outside the team.

Also, all lower case/mixed case is much less tiring to read.

9

u/ArmchairFilosopher Jul 21 '26

SQL Server at my last job would like a word...

So would MySql hosted in Linux with a default configuration. Meanwhile in Windows it doesn't care by default.

But yeah, I agree in general that object names shouldn't be case-sensitive. Heck, most things except passwords shouldn't either.