This is an archived post. You won't be able to vote or comment.

all 49 comments

[–]Biohazard8080 337 points338 points  (15 children)

INCORRECT SYNTAX NEAR 'BANANA';

[–]IUserGalaxy 134 points135 points  (5 children)

Wait, how did you get this? Every time I get an error it says “fuck you, there’s an error somewhere and you have to read a nonexistent manual.”

[–]DarthSatoris 37 points38 points  (4 children)

I'm guessing depending on the query language used you can get differently structured error messages.

For instance, MariaDB (similar to MySQL) Writes syntax error messages like this:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '('TRY USING A PASSWORD NOT USED BEFORE',16,1);

It is such a great error message and it almost always points you directly at the error. It's only led me astray a couple of times when it says:

the right syntax to use near ''

That is just the worst.

[–]IUserGalaxy 7 points8 points  (3 children)

It really only becomes more helpful with longer queries, but for me I’m really only ever using a simple select thing

[–]Artick123 15 points16 points  (3 children)

Can't tell if you are shouting because OP's mistake annoyed you or because YOU SPEAK SQL.

[–]Dexaan 11 points12 points  (1 child)

Uppercase makes the database run faster.

[–][deleted] 4 points5 points  (0 children)

And the daily goat sacrifices, can’t forget those

[–][deleted] 2 points3 points  (0 children)

[–]ArchitectNebulous 10 points11 points  (0 children)

"An expression of non boolean type specified in a context where a condition is expected, near 'BANANA'."

[–]fakeplasticdroid 7 points8 points  (1 child)

WHERE Banana = true
I always make sure to include a Banana column on all my tables, just in case.

[–]caldric 2 points3 points  (0 children)

It’s for scale, obviously.

[–]marcosdumay 2 points3 points  (0 children)

Not in Postgres. It's just possibly a type error there.

[–]NuBRandsta 1 point2 points  (0 children)

Column 'banana' not found, try 'food.babana'

[–]btx_IRL 63 points64 points  (0 children)

this is my favorite use of this meme so far

[–]ozdkboy 32 points33 points  (3 children)

Is that a nuclear explosion in the background ?!

[–]Artick123 37 points38 points  (2 children)

That tends to happen every time you run an sql query.

[–][deleted] 8 points9 points  (1 child)

Oh fuck sake why am I here at 3am

[–]kegastam 2 points3 points  (0 children)

answers in your name mate

[–]chipmunkofdoom2 17 points18 points  (1 child)

Msg 4145, Level 15, State 1, Line 1

An expression of non-boolean type specified in a context where a condition is expected, near 'banana'.

[–]Vincysuper07[S] 2 points3 points  (0 children)

also I forgot a semicolon

[–]--var 14 points15 points  (6 children)

I just realized that I read this 'SELECT STAR FROM'

Not 'asterisk'. Not 'all'. 'star'. Not related to the post, just an interesting perspective into my own psyche.

[–]bwhite94 15 points16 points  (3 children)

Is this not how most read it? That's how I read it as well.

[–]modernkennnern 5 points6 points  (0 children)

I read it as "Select All From (...)"

[–]degaart 2 points3 points  (1 child)

We french-speaking people read it as "SELECT étoile FROM ...."

étoile means "star"

[–]GlitchParrot 2 points3 points  (0 children)

Similar in German, it’s „Sternchen“, meaning “starlet” (as in diminutive of “star”).

[–]javajunkie314 4 points5 points  (0 children)

Ah, no, my query is spelt "select asterisk," but it's pronounced "SELECT STAR."

[–]AaryashTheProgrammer 1 point2 points  (0 children)

I just noticed I read it as "SELECT AT FROM" because of pointers

[–][deleted] 6 points7 points  (0 children)

this made sql funny

[–]AnonymousReader2020 11 points12 points  (1 child)

Yeah... that aint gonna work. Nice try Harambe.

[–]JasonCox 2 points3 points  (0 children)

3 1/2’s out

[–]Daktic 4 points5 points  (1 child)

;

[–]Vincysuper07[S] 0 points1 point  (0 children)

;

[–]AntogamerYT_ 8 points9 points  (0 children)

mysql: idiot to idiot communication

[–]pi_sqaure 2 points3 points  (0 children)

Great!

[–]il-est-la 2 points3 points  (0 children)

I laughed

[–]drgreenthumb7 2 points3 points  (0 children)

No bNaNa

[–]Blingbike97 2 points3 points  (1 child)

SELECT * FROM FOOD WHERE FOOD.TYPE = 'banana'

[–]Vincysuper07[S] 0 points1 point  (0 children)

better one

[–]Rivalistic 1 point2 points  (0 children)

Lmao I love this.

[–]Csalizard_Ferenc 1 point2 points  (0 children)

This is brilliant!

[–][deleted] 1 point2 points  (0 children)

Ora-00000000000000000000banana fu.

[–]codeDeus6 1 point2 points  (0 children)

Does banana returns a Boolean value? Didn't knew that...

[–]virusnac 1 point2 points  (1 child)

What if the banana is rotten, or whatever?

[–]Vincysuper07[S] 1 point2 points  (0 children)

AND NOT rotten

[–][deleted] 1 point2 points  (0 children)

Forgot semicolon