willya@lemmyf.uk to Programmer Humor@lemmy.mlEnglish · 2 years agoWhoopsthumbsnap.comimagemessage-square79linkfedilinkarrow-up11.32Karrow-down117
arrow-up11.3Karrow-down1imageWhoopsthumbsnap.comwillya@lemmyf.uk to Programmer Humor@lemmy.mlEnglish · 2 years agomessage-square79linkfedilink
minus-squareerogenouswarzone@lemmy.mllinkfedilinkEnglisharrow-up17·2 years agoYou can also do this by forgetting a WHERE clause. I know this because I ruined a production database in my early years. Always write your where before your insert, kids.
minus-squarethemusicman@lemmy.worldlinkfedilinkarrow-up6·2 years agoAlways start every command with EXPLAIN and don’t remove it until you’ve run it
minus-squarebitflag@lemmy.worldlinkfedilinkarrow-up2·2 years agoI learned the same lesson the same way 😞
You can also do this by forgetting a WHERE clause. I know this because I ruined a production database in my early years.
Always write your where before your insert, kids.
Always start every command with EXPLAIN and don’t remove it until you’ve run it
I learned the same lesson the same way 😞