This is a continuation of my previous rant...
I did it! I overcame my anxiety to work on the dev database (don't worry, I made backups). At first I got really anxious and almost panicked at the thought of possibly messing up and procrastinated a few minutes. After the intial anxiety has passed I just did it and it worked. I didn't destroy anything nor did I made any mistakes. One step closer to becoming more confident when working with company assets

nice

Good for you! Just don't get too cocky my friend. Truth be told, everyone probably fucks the company database at least once in their lifetime xD so if it didn't happen today, it might happen tomorrow. It even happened to me, though I never felt anxious about it. It just happened one day when doing routine stuff on a database that I didn't notice which database I was connected to and just mindlessly did my thing. Luckily we have automated backups and i put everything back in order fast :D Never happened again though

But as long as you have backups and know what you're doing, you will be fine, keep learning :)

Go lucadev !

Best advise I can give you is that when running any update or delete query, do it in a COMMIT.

Just in case something is messed up, you can use ROLLBACK to undo the update without the need of a backup or whatever.

Or just test it always with a select first.