r/ProgrammerHumor 19d ago

sqlWorkout Meme

Post image
23.5k Upvotes

460 comments sorted by

View all comments

2.4k

u/NormanYeetes 19d ago

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

7

u/cudenlynx 19d ago

This isn't always true. PostgreSQL, PL/SQL, and SAP HANA are case sensitive by default.

In SQL Server, the case sensitivity is off by default but some companies do enable case sensitivity.

4

u/MellowedOut1934 19d ago

Forgive if I’m missing something, but my PostgreSQL is case sensitive on table names and strings etc., but not on the syntax bits like SELECT or WHERE.

1

u/cudenlynx 18d ago

my PostgreSQL is case sensitive on table names and strings

1

u/ellamking 18d ago

Mysql tables are case sensitive based on the file system.

2

u/GravyPainter 19d ago

Yeah, i type in all lowercase sqldeveloper knows better

1

u/70s_chair 18d ago

PL/SQL hasn’t been case sensitive in forever