That SELECT and WHERE are all caps, but from is not is bugging me.
I don’t care if you choose to uppercase keywords or lowercase, but consistency please.
Also, great, love it.
It's that time of the year again!
Submitted 11 months ago by masimatutu@nerdica.net to programmer_humor@programming.dev
Comments
Truck_kun@beehaw.org 11 months ago
cupcakezealot@lemmy.blahaj.zone 11 months ago
it also implies that naughty or nice is an either or thing and not a weighted thing from an incidents table. the good place lied to us.
ursakhiin@beehaw.org 11 months ago
It could be a materialized view that is generated off of a weighting where you are nice until you have a certain number of incidents.
guy@lemmy.world 11 months ago
Guess that settles the debate, we got to pronounce it “sequel” then to optimally match syllables
RiikkaTheIcePrincess@pawb.social 11 months ago
Uuugghhh noooo! Ess Kyoo Ell!! ESS KYOO ELL!!! brandishes flaming pitchfork!
db2@sopuli.xyz 11 months ago
Squirrel works too though.
squiblet@kbin.social 11 months ago
The Australian pronunciation works… “squi-rell”. Common American one is somehow just one syllable, “Skwurl”
Doug@midwest.social 11 months ago
Yes but he serves a different community
threelonmusketeers@sh.itjust.works 11 months ago
_danny@lemmy.world 11 months ago
The only people I know who actually call it ess queue ell are either too new to know the “sequel” pronunciation, or the type of person you generally smell before you see.
SpeakinTelnet@programming.dev 11 months ago
I say ess cue ell for the sake of uniformity because it’s not Mysequel nor Postgresequel and the language changed from Sequel to the acronym SQL in the 70s so not really in the “too new” ballpark anymore.
relevants@feddit.de 11 months ago
Here in Germany everyone I know pronounces the letters individually – as German letters that is, which means the Q is pronounced “coo” rather than “cue”. I don’t mind it, it’s not quite as clunky as in English.
I do say sequel when speaking English though.
cm0002@lemmy.world 11 months ago
I’m neither, I refuse to pronounce acronyms if it doesn’t make sense to do so.
Same thing with ‘gooey’ for GUI, except I hate that even more because that straight up elicits feelings of disgust, I don’t want anything gooey anywhere near any electronics
pythonoob@programming.dev 11 months ago
Sequel to what?
cupcakezealot@lemmy.blahaj.zone 11 months ago
dammit bobby tables is on the naughty list again
aspitzer@lemmy.world 11 months ago
wait until it hits little bobby tables…
jaybone@lemmy.world 11 months ago
He drops when you are sleeping. He drops when you’re awake.
rufus@discuss.tchncs.de 11 months ago
Come they told me, pa rum pum pum pum A new born King to see, pa rum pum pum pum Our finest gifts we bring, pa rum pum pum pum To lay before the King, pa rum pum pum pum, rum pum pum pum, rum pum pum pum,
So to honor Him, pa rum pum pum pum, When we come.
Little Bobby, pa rum pum pum pum I am a poor boy too, pa rum pum pum pum I have no gift to bring, pa rum pum pum pum That’s fit to give the King, pa rum pum pum pum, rum pum pum pum, rum pum pum pum,
Shall I play for you, pa rum pum pum pum, On my unsanitized database inputs?
…
Akrenion@programming.dev 11 months ago
Can anyone recommend a cheap receipt printer that takes pictures from a pc or phone? I want to print mtg tokens on the fly.
halcyondays@midwest.social 11 months ago
[deleted]jasondj@ttrpg.network 11 months ago
Weird that we never consider that for retail workers though…
meliaesc@lemmy.world 11 months ago
Pencil
jasondj@ttrpg.network 11 months ago
Gameboy Pocket. Gameboy Camera. Gameboy Printer.
Both the perfect balance of “nostalgia” and “ridiculous”.
datelmd5sum@lemmy.world 11 months ago
Query OK, 0 rows affected
neuracnu@lemmy.blahaj.zone 11 months ago
I was reading that to the tune of the chorus of The Distance by Cake. It worked until the last line.
Cwilliams@beehaw.org 11 months ago
Lol that actually works so well
Donkter@lemmy.world 11 months ago
The beginning maps perfectly to “The Distance” by Cake and I was singing along to that tune as I read.
docAvid@midwest.social 11 months ago
Cut to Mrs Claus baking a spice cake:
She’s all alone, all alone, in her time of spice
BolexForSoup@kbin.social 11 months ago
He sees you when your bashing
He’s cracked your VPN
jballs@sh.itjust.works 11 months ago
He knows you’re not in the sudoers file
So he’ll report your ass again
SHBI7368@sh.itjust.works 11 months ago
Love it keep em coming
tsonfeir@lemm.ee 11 months ago
I started this in my head sounding like the singer from Cake.
GBU_28@lemm.ee 11 months ago
No closing semicolon, anyone got any extras to throw on this thing?
epyon22@sh.itjust.works 11 months ago
; found this in the back for you should still work though
db2@sopuli.xyz 11 months ago
Can confirm.
Moops@lemmy.world 11 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.
WHER 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.
mp04610@lemm.ee 11 months ago
behavioris an ENUM.moroni@lemmy.ca 11 months ago
That’s a table scan, right there. Naughty.
pruwybn@discuss.tchncs.de 11 months ago
Need to normalize the database. I would add a book yu to a BehaviorTypes table.
takeda@lemmy.world 11 months ago
You need semicolons if it is a script with multiple commands to separate them. It is not needed for a single statement, like you would use in most language libraries.
mellejwz@lemmy.world 11 months ago
If you don’t use a semicolon directly in MySQL it won’t do anything until you add it.
krotti@sh.itjust.works 11 months ago
Honest question, which ones wouldn’t it work with? Most add a semicolon to the end automatically or have libraries and interfaces saved me a million times?
GBU_28@lemm.ee 11 months ago
Other reply s accurate but it’s always a good practice to include the semicolon else you can get
“Bobby tables’ed” look that xkcd comic up
jaybone@lemmy.world 11 months ago
Usually with libraries like jdbc or whatever and prepared statements you don’t need the semicolon.
fmstrat@lemmy.nowsci.com 11 months ago
Can we get a SIMILARITY?