Original: Backup Transcription ↓/* true story sent by Washington Aquino */ Programmer: Do you have an updated backup from the database? I'll need to restore it. Support: Backup??? Oh, sure, I have it... (At the computer) DROP DATABASE? OK! Programmer: Can you send me the backup, please? Support: Well... backup??? uh...(…) leia mais
Transcription ↓/* True story sent by Edmilson Felix */ Programmer: DBA? I need a new column in the `workaround` table please. DBA: Okay! Whats this column for? Programmer: It will store the URL that the user typed in the browser. DBA: Hmm Okay, but whats an URL? Programmer: DBA: Uh, okay. But what a browser?(…) leia mais
Transcription ↓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!!!(…) leia mais
Boss: From now on, you'll not use left or inner join anymore in database queriesProgrammer: 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