10 ms·
Bonus tip: don't even type COMMIT until after you've run a few select queries to verify the data has in fact changed how you expected it to change.
by bmurphy1976 5y ago
Bonus tip: don't even type COMMIT until after you've run a few select queries to verify the data has in fact changed how you expected it to change.
- beart 5y agosuper duper bonus tip: Don't execute SQL in a production environment that you just typed out on the fly.
- mdoms 5y agoIt's incredibly depressing how common this is in the real world, but I can tell you from experience that this NEVER happens in Atlassian production systems.
- sergiotapia 5y agoI fucked up once and lost 2 hours of customer data. I was so lucky we were a small startup and had daily backups AND the backup was only 2 hours old. I would have been royally fucked. Never making that mistake again. Always use a copy of prod on a staging server and run your queries there for testing.