1193
It's that time of the year again! (files.mastodon.social)
you are viewing a single comment's thread
view the rest of the comments
[-] GBU_28@lemm.ee 78 points 9 months ago

No closing semicolon, anyone got any extras to throw on this thing?

[-] Moops@lemmy.world 17 points 9 months ago* (last edited 9 months ago)

At the very least I'd try to clean up that fuzzy condition on behavior to anticipate any bad or inconsistent data entry.

WHERE UPPER(TRIM(behavior)) = 'NICE'

Depending on the possible values in behavior, adding a wildcard or two might be useful but would need to know more about that field to be certain. Personally I'd rather see if there was a methodology using code values or existing indicators instead of a string, but that's often just wishful thinking.

Edit: Also, why dafuq we doing a select all? What is this, intro to compsci? List out the values you need, ya heathen ;)

(This is my favorite Xmas meme lol)

[-] moroni@lemmy.ca 4 points 9 months ago

That’s a table scan, right there. Naughty.

load more comments (1 replies)
load more comments (14 replies)
this post was submitted on 09 Dec 2023
1193 points (97.5% liked)

Programmer Humor

19190 readers
1211 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago
MODERATORS