Tag Archives: sql

SQL Error

/* True story sent by Erisvaldo Carvalho */
Manager: What code is it that you’re trying to fix?
Programmer: SQL…
Manager: Hmmm… Let me see it…
Manager: I wonder that the error is there on these — (minus minus), because “minus minus” equals “plus”… It’s a calculus fail

Original: Erro de SQL

Where??

15 Replies

Programmer: Hey, man! What did you do to the database?
Jack: Nothing… Only an update for a client who asked to change the role of an user
Programmer: Uh… And by chance did you change his level to 4?
Jack: That’s right. Did you see that in the logs?
Programmer: No! You forgot the WHERE on UPDATE!!! All users are level 4 now!

Left Join

2 Replies

Boss: From now on, you’ll not use left or inner join anymore in database queries
Programmer: But what about the performance and…
Boss: It doesn’t matter! only simple joins… ’cause I had to fix a bug when you weren’t here and it’s hard to understand when you use “left join”

Original: LEFT JOIN

A Programmer's Life

/* Code lines of a programmer's life */

Tag Archives: sql

SQL Error

Where??

Left Join