No direct access to prod database for any developer. No excuses. If you need to run a data migration, make a script and put it through code review. Run it on a jump box.
2024-12-31 20:21:00
6
Киевский ухилянт :
always before update or delete, write a select, ensure, then just change to u/d
2024-12-29 11:37:19
64
CoderContent :
At this point you might as well DELETE * 🙏😭
2024-12-29 11:00:39
72
damiano.colussi :
every SQL coder once in a lifetime mistake...Who says no Is a lier
2024-12-30 13:19:52
67
Billy :
One day I wanted to refresh my dev db from the prod in command line, I did the opposite
2024-12-29 11:11:34
54
thasvir9 :
pray autocommit is not enabled
2025-01-03 21:17:09
0
wiki green :
What about rollback transaction?
2024-12-29 11:54:03
1
White Senpai231 :
This is why im never gonna be a database manager
2024-12-29 00:35:22
37
paoloandres :
A good db tools ask if you want to run an update without where 😑 … i blame to the 12 weeks “become” a developer bootcamps
2024-12-29 14:04:19
36
Teemu Kukkola :
Thats why you need to write WHERE statement before the statement which makes the changes.
2024-12-31 09:33:09
0
Silent Moments :
I actually did this once accidentally, but I was making logs for each effected row, from logs I recovered the original records without anyone knowing 😂😂😂
2024-12-29 19:45:58
7
crtk :
what a great way to start your morning 😂
2024-12-28 08:04:59
25
Wolle :
Is that a classical "oh no!"-Moment? 😂
2024-12-29 20:55:28
8
Mush Gaming :
Buckup database is the key😅
2024-12-28 23:16:28
9
Banana Jesus :
Always start an update with WHERE 1 = 0 when you are crafting it. Or, you know, create the script in your dev environment first.
2024-12-29 18:22:08
1
NairaPlug :
I think it should be, Update Transactions set Status = "successful" where Transaction.id = ID
2024-12-29 09:27:56
3
___ :
this is why they don't give me access to prod
2025-01-01 06:19:53
29
Jack Haze :
When you send an email with the word “attached” in the message and you forget to attach a file, you get a warning in GMail. You should get a warning when you DELETE without a WHERE clause.
2025-01-01 08:18:20
0
Mark Anthony :
ROLLBACK TRANSACTION
2024-12-29 14:15:02
1
Red Dimond :
roll back😁😂
2024-12-28 18:58:30
10
Ozymandias :
keep calm and rollback 😅.
2024-12-29 20:47:36
0
Olasunmade :
no where condition 🤣🤣🤣
2024-12-29 15:19:11
0
To see more videos from user @billyeditiano, please go to the Tikwm
homepage.