(转)A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'

mother(alice, amy).
father(bob, amy).
parent(P, C) :- mother(P, C).
parent(P, C) :- father(P, C).

?- parent(X, amy).
yes: X = alice.
yes: X = bob.

?- parent(amy, X).
no.

The joke on Prolog form is then:

?- changebulb(prologprogrammer, X)
no.

[–]jensm -2 分/分 2 years ago

[–]jenkinsloveschicken 1 分/分 2 years ago

[+] mattb0611 comment score below threshold (0 children)

[+] rainman_104 comment score below threshold (0 children)

[–]calib0rx 19 分/分 2 years ago*

permalink

[–]neilk 78 分/分 2 years ago

permalink

[–]ringzero 47 分/分 2 years ago

[+] Charice comment score below threshold (0 children)

[–]---sniff--- -4 分/分 2 years ago

[+] franksvalli comment score below threshold (2 children)

[–]pyry 4 分/分 2 years ago

[–]matthewt 1 分/分 2 years ago

[–]MostUsually 0 分/分 2 years ago*

[–]organic 0 分/分 2 years ago

[–]Rofl_Waffler 63 分/分 2 years ago

permalink

[–]FunnyMan3595 10 分/分 2 years ago

mysql> explain select * from table_1 JOIN table_2;
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
| id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows | Extra |
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
|  1 | SIMPLE      | table_2 | ALL  | NULL          | NULL | NULL    | NULL |    5 |       | 
|  1 | SIMPLE      | table_1 | ALL  | NULL          | NULL | NULL    | NULL |    9 |       | 
+----+-------------+---------+------+---------------+------+---------+------+------+-------

[–]scook0 10 分/分 2 years ago

It's a pun, or play on words.

Normally the phrase "Can I join you?" would mean "Can I accompany you?". However, because the speaker is an SQL query and the subjects are tables, "join" can also refer to an operation that combines data from two tables in a database. This intentional ambiguity between multiple meanings can be considered humorous.

In addition, the word "table" can refer to the item of furniture (as might be found in a bar), or to a collection of data elements in a database. However, this extra pun is not essential to the core joke.

[–]killerstorm 60 分/分 2 years ago

[–]scook0 46 分/分 2 years ago

[–][deleted] 10 分/分 2 years ago

[–]Daleo 3 分/分 2 years ago

[–]MihaiC 14 分/分 2 years ago

[–]SgtSausage 10 分/分 2 years ago

[–]arnar 2 分/分 2 years ago

[–][deleted] -2 分/分 2 years ago*

[+] cL0h comment score below threshold (0 children)

[–]CadillacJoe 36 分/分 2 years ago

permalink

[–]shamhow 16 分/分 2 years ago

[–]Porges 3 分/分 2 years ago*

[–]willdabeast 3 分/分 2 years ago

[–]akatherder 6 分/分 2 years ago

[–]ErroneousFrog 1 分/分 2 years ago

[–][deleted] 115 分/分 2 years ago*

permalink

[–][deleted] 33 分/分 2 years ago

[+] nokilli comment score below threshold (2 children)

[+] waxo comment score below threshold (5 children)

[–]thatAnonymousGuy 1 分/分 2 years ago

[–][deleted] 14 分/分 2 years ago

[–]munificent 3 分/分 2 years ago

[–]solfood 1 分/分 2 years ago

[+] benihana comment score below threshold (3 children)

[–]kbedell 7 分/分 2 years ago

Two queries walk into a bar. They overhear a query next to them say, 'Shut the @#!@#% up you dumb son of a #$@%&!@$)'.

The first query leans over to the second and whispers, 'hmmm... she must be using a CURSOR'...

permalink

[–]mahlzeit 2 分/分 2 years ago

'Shut the wookie up you dumb son of a banana'.

That doesn't even make sense.

[–]spacepope 3 分/分 2 years ago

[–]kbedell 9 分/分 2 years ago

[–]spacepope 5 分/分 2 years ago

[–]kbedell 4 分/分 2 years ago

[–]nshrestha -1 分/分 2 years ago

[–]damagednoob 7 分/分 2 years ago

permalink

[–]paranoidgeek 5 分/分 2 years ago*

permalink

[–][deleted] 3 分/分 2 years ago

The tables have nothing in common. So the SQL query elects to just do a carestian join. As the SQL query stares at that ungodly scene, the DBA comes rushing in the door.

"What the fucking hell? Who is thrashing the instance?!?"

The DBA proceeds to kill the query. The DBA is arrested, and sentenced to life in jail.

Thus, a new DBA position is posted on Craigslist, doing a small part to help stimulate a very weak job market.

And that, kids, is why cartesian joins aren't always bad. They do have their uses.

permalink

[–]kbedell 1 分/分 2 years ago

[–]elus 1 分/分 2 years ago

[–]ChrisRathman 14 分/分 2 years ago*

Then the drunk dbdebunk guys sitting in the corner stand up and start complaining that SQL has no business walking into a bar and pretending to be a relational match maker and that there are better ways to arrange a Date.

permalink

[–]OvidPerl 0 分/分 2 years ago

[–]yourparadigm 16 分/分 2 years ago

permalink

[–]LudoA 7 分/分 2 years ago

Actually, if you look up on it, you'll see that it was originally Sequel, then due to copyrights it had to be changed to SQL.

Personally, as I'm not a fan of copyrights, and because "Sequel" is IMHO *much* more pronouncable, I say Sequel.

[–]scook0 7 分/分 2 years ago

If you look more closely you'll find that it was a trademark issue, not a copyright issue.

Changing the name for copyright reasons wouldn't make much sense.

[–]LudoA 1 分/分 2 years ago

[–]killerstorm 6 分/分 2 years ago*

In the original SQL standard, ANSI declared that the official pronunciation for SQL is "es queue el"

is IMHO much more pronouncable, I say Sequel.

standard conformance is often sacrificed for the sake of convenience

[–]muffinman 3 分/分 2 years ago

yeah here in Germany CTRL on keyboards is translated to "STRG" ("Steuerung", meaning "Control" (duh)).

Most (computer illiterate) people say something along the lines of string, strang, strong, stategie(!!!)

[–]frankster 5 分/分 2 years ago

[–][deleted] 6 分/分 2 years ago

[–]grigri 3 分/分 2 years ago

That would be cool in French as "citrouille" means pumpkin.

commits that to long-term storage

[–]LudoA 2 分/分 2 years ago

[–]killerstorm 1 分/分 2 years ago*

standard conformance is often sacrificed for the sake of compatibility with older versions

[–]LudoA 1 分/分 2 years ago

Actually, in this case the compatibility was sacrificed by the standard for stupid reasons.

But you know that pronouncing it doesn't have much to do with writing ANSI-compliant SQL, so this discussion doesn't have much point.

I'm also not convinced it's the ANSI standard's place to dictate how its name should be pronounced.

[–]psyhofreak 1 分/分 2 years ago

I predate ANSI, so I pronounce it "squeal". As in "I'm gonna make you-a SQL database!"

[–]newredditsucks 3 分/分 2 years ago

I'm probably the only one, but I make my living from it and still call it SQuirreL. Makes just as much sense to me as SeQueL.

[–]greyfinch 1 分/分 2 years ago

Haw, another one with alternate pronunciations! I like calling it SQuiggLe, it sounds very friendly. SQuirreL is pretty friendly too.

[–]LudoA 1 分/分 2 years ago

A squiggle actually already exists. You know those red, non-straight lines which a spell-checker puts under an incorrect word? It's called a squiggle.

[–]CritterM72800 0 分/分 2 years ago

In the case of MySQL...

"The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way." http://dev.mysql.com/doc/refman/5.0/en/what-is-mysql.html

I say sequel too :/.

[–]jplindstrom 5 分/分 2 years ago

Or, unofficially, "that piece of crap".

Is that not in their FAQ? Weird.

[–]gordonjay2 1 分/分 2 years ago

[–]Tordek 2 分/分 2 years ago

You store your data in yourskull? Awesome.

[–]gordonjay2 1 分/分 2 years ago

i have a 90mb BrainDrive.

[–]thatAnonymousGuy 2 分/分 2 years ago

Came here to say the same thing. So reddit, how do YOU pronounce SQL? Es queue el, or sequel?

[–]mycatverbs 3 分/分 2 years ago

[–]thatAnonymousGuy 1 分/分 2 years ago

I haven't heard that one. I like it!

[–]xoxox 4 分/分 2 years ago

My Ess Queue El. Not My-sequel!!!

[–]LeeJunFan 5 分/分 2 years ago

No habla espanol!

[–]ktvoelker 4 分/分 2 years ago

I think you meant Post Gress Queue El.

[–]jehahn 2 分/分 2 years ago

And never Post Greh See Quel.

[–]gecko 1 分/分 2 years ago

Personally, when it comes to that, my preferred pronunciation is unquestionably My Squeal.

[–]maweaver 1 分/分 2 years ago

I've heard it both ways, and I lean towards sequel, just because it's one less syllable. I'm not a "M$" developer, and didn't realize that had an impact on which was favored. What an odd thing to be snooty about.

[–]raskolnikov027 1 分/分 2 years ago

I've always said Ess Que El, and My EssQueEl. But for some reason I've always gone with MySequelServer, which isn't consistent at all.

[–]my_nth_account_name 1 分/分 2 years ago

Squeal, es queue ell, or sequel, in decreasing order of preference.

[–][deleted] 2 分/分 2 years ago*

Round here we pronounce it 'squeal', as in 'MySqueal'.

[–]gordonjay2 1 分/分 2 years ago

that's how i usually pronounce it, but more of a 'Squhl.' laziness FTW

[–][deleted] 3 分/分 2 years ago

Its Squizzle in da hizzle!

[–]vagif 13 分/分 2 years ago

Tables show him index finger.

permalink

[–]jehahn 3 分/分 2 years ago

Just the one? Is it a UNIQUE index finger?

[–]rreader 6 分/分 2 years ago

"OK," they say.
"And how would you like that sorted" the query asks."Top to bottom," they answer."I knew you were my kind of tables," the query exclaims.

permalink

[–]eytanlevit 5 分/分 2 years ago

i heard it was the bar's name was inetpub

permalink

[–]dggoldst 7 分/分 2 years ago*

Tables: Ick. We BOTH knew you'd SELECT us FOR one of those cheesy LINES. WHERE do you get the RIGHT TO INSERT yourself ALL IN our faces LIKE that? Just DROP it and LEAVE, OR ELSE ...

Query: Hey, let me EXPLAIN. Don't be CROSS. WHILE I may appear INSENSITIVE, BEFORE you IGNORE me, I just want TO DECLARE you're, LIKE, the FIRST NORMAL TABLES I've seen IN a LONG TIME!

Tables: RIGHT, RIGHT ...

Query: It's TRUE! You're UNIQUE, AND DISTINCT FROM the GROUP. Look, I'm NOT TRAILING you, AND I'm NOT OUT TO USE you, AND and I'm NOT OUT TO get WITH you.

Tables: Fine. IF you FETCH us EACH a drink, you can CONTINUE ....

permalink

[–]shamhow 2 分/分 2 years ago

it was going good until they saw my old honda and started cartesian

permalink

[–]tamrix 3 分/分 2 years ago*

"You posses the primary key to my heart!" said the table. The SQL query then joined both the tables hands and the primary and secondary key combined to create a new index of love. "It just feels so right, joined." the table said as a row got added. They lived happily ever.. or until Mr Redundant came along..

"Why table, you are surposed to be joined to me, we have had an index since version 1!" dropped Mr Redundant as his pain could be heard echo'ing into to management systems room.

The table replied "I'm sorry. in our relationship you were only a temp table, besides the table I'm with now has soo many rows and such a handsome schema".

permalink

[–]kbedell 5 分/分 2 years ago

A PREPARED STATEMENT walks into a bar and sees a couple of cute STRINGS sitting at a table.

He walks up and asks for their NUMBERS and they say -- 'Just DROP it! We're the wrong data type!'

He responds, 'don't worry! I can overload my function calls!'.

permalink

[–]Howard_Beale 3 分/分 2 years ago

"only if you belong to a union!"

permalink

[–]hacksoncode 3 分/分 2 years ago

To which they respond, "No, we have no index in common."

permalink

[–]jehahn 3 分/分 2 years ago

"That's okay. We can do it real slow," the query answered.

[–]fas2 1 分/分 2 years ago

Go over the books!

[–]kbedell 1 分/分 2 years ago

When considering joins - given the choice, I'd rather be INNER.

permalink

[–]G_Morgan 1 分/分 2 years ago

This one time a SQL query was stopped in its track by a check constraint denying insertion into the rear table.

Also one query I know uses a cursor to iterate across every entry in the club.

permalink

[–]uriel 1 分/分 2 years ago

God, that joke was so bad I laughed out loud.

permalink

[–]henrygeorge 1 分/分 2 years ago

Bus error: driver executed

permalink

[–]xamox 1 分/分 2 years ago

WHERE joke="lame' OR 1=1--

permalink

[–]deleteduser 1 分/分 1 year ago

Msg 105, Level 15, State 1, Line 1Unclosed quotation mark before the character string 'lame'

[–]monkeyman114 -1 分/分 2 years ago

I'm a DBA, and that one just floored me.

permalink

[–]bprager 1 分/分 2 years ago

To be or not to be = FFHex: 2b || ^2b

permalink

[–]LOLster -2 分/分 2 years ago

"An SQL query"

With respect,Grammar Nazi

permalink

[–]piderman 14 分/分 2 years ago

Unless you pronounce it 'Sequel' as some people do.

[–]jones77 3 分/分 2 years ago

Grammar Nazis Denied!!!!

Puta. I was gonna come in here to complain too.

[–]eatadonut 1 分/分 2 years ago

I'm still not sure which is considered more "in the know". I grew up calling it S-Q-L, but then in high school my teacher called it Sequel.

[–]rabidcow 3 分/分 2 years ago

That depends on how long you've been using SQL.

[–]pyry 1 分/分 2 years ago

Or your ability to change.

[–]a1phanumeric 2 分/分 2 years ago

An Structured Query Language?

[–]pyry 2 分/分 2 years ago

An Ess-Queue-El query.

[–]mahlzeit 1 分/分 2 years ago

I heard those silly Americans pronounce it "Sequel".

[–]SubGothius 2 分/分 2 years ago

Actually, I picked up that pronunciation from an Oxford-educated VP of Dev/Ops at an ISP where I once worked.

[–]tch 0 分/分 2 years ago

/facepalm

permalink

[–][deleted] 2 years ago

[deleted]

permalink

[–]thatAnonymousGuy 2 分/分 2 years ago

Yea that was lame.

You mean that was crappy...

[–][deleted] 0 分/分 2 years ago*

Your incredibly bad joke has shown me I'm still not over my 'poop is funny' phase. I laughed. :(

[–]kernelhappy 0 分/分 2 years ago

! I can't find it. Since we're talking geek humor....

When I was young and green (working on Tandems so you get my age) someone sent me an email (no not THAT old) made completely out of single character statements.

Anyone happen to remember/know what I'm talking about.

permalink

[–]kking254 0 分/分 2 years ago

I'm going to pretend I don't know what you're talking about so I don't feel like such a nerd.

permalink

[–]helleborus 0 分/分 2 years ago

It's LIKE 'that*', is it?

permalink

[–]arnar 5 分/分 2 years ago

Fail. It's LIKE 'that%'.

[–]helleborus 1 分/分 2 years ago

Yeah - I've been in Access all day and I get used to *.

[–]randroid 0 分/分 2 years ago

Is that some kind of a nerd joke?

permalink

[–]MikeSeth -2 分/分 2 years ago

Oh my $deity best thread ever

permalink

[+] 20man comment score below threshold (1 child)

[+] [deleted] comment score below threshold (0 children)

[–]amccloud -4 分/分 2 years ago

SQL pulled up to a house about seven or eight and he yelled to the cabby yo, home smell you later. SQL looked at his kingdom, he was finally there, to settle in his throne as the prince of bel-air.

permalink

[–]aradil 6 分/分 2 years ago

I think you need to work on your setup.

[+] sigint_bn comment score below threshold (0 children)

[+] _argoplix comment score below threshold (0 children)

不码代码的IT民工

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
(转)A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'

A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'(self.programming)submitted 2 years ago
复制链接

扫一扫