@flying_gel - lemmy.cnschn.com

flying_gel@lemmy.world

0 Posts
2 Comments

Joined 1 year ago

Cake day: July 8th, 2023

You are not logged in. If you use a Fediverse account that is able to follow users, you can follow this user.

OverviewCommentsPosts

flying_gel@lemmy.worldtoProgramming@programming.dev•I accidentally removed the WHERE clause from my SQL query in a personal tool. Every row is now the same. I overwrote 206,000+ rows. I have no backup, I am stupid.
link
fedilink
arrow-up
2·
1 year ago
That would be SQL management studio and psql on the command line.

The best I could find was some plugins for SQL management studio (ssmsboost) and disable automatic commits for psql.

link
fedilink

flying_gel@lemmy.worldtoProgramming@programming.dev•I accidentally removed the WHERE clause from my SQL query in a personal tool. Every row is now the same. I overwrote 206,000+ rows. I have no backup, I am stupid.
link
fedilink
arrow-up
8·
1 year ago
I tried to find this setting for postgres and Ms SQLserver, the two databases I interact with. I wasn’t able to find any settings to that effect, do you happen to know them?

link
fedilink