willya@lemmyf.uk to Programmer Humor@lemmy.mlEnglish · 10 months agoWhoopsthumbsnap.comimagemessage-square81fedilinkarrow-up11.33Karrow-down117
arrow-up11.31Karrow-down1imageWhoopsthumbsnap.comwillya@lemmyf.uk to Programmer Humor@lemmy.mlEnglish · 10 months agomessage-square81fedilink
minus-squareerogenouswarzone@lemmy.mllinkfedilinkEnglisharrow-up17·10 months 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·10 months agoAlways start every command with EXPLAIN and don’t remove it until you’ve run it
minus-squarebitflag@lemmy.worldlinkfedilinkarrow-up2·10 months 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 😞