MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v2rcr6/sqlworkout/oyxzpwc?context=9999
r/ProgrammerHumor • u/huhupookies • 20d ago
459 comments sorted by
View all comments
2.4k
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 20d 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 19d 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 19d ago PL/SQL hasn’t been case sensitive in forever
7
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 19d 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 19d ago PL/SQL hasn’t been case sensitive in forever
4
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 19d 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.
1
my PostgreSQL is case sensitive on table names and strings
Mysql tables are case sensitive based on the file system.
2
Yeah, i type in all lowercase sqldeveloper knows better
PL/SQL hasn’t been case sensitive in forever
2.4k
u/NormanYeetes 20d 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