SQL blunders
Started by Kyng




2 posts in this topic
Kyng
Junior Member
**


Members

17 posts 5 threads Joined: Jul 2020
02-08-2020, 05:29 PM -
#1
SQL is a very powerful language for manipulating databases. However, when it's in the hands of the wrong person, it can be rather dangerous: screw up a query, and you can do immense damage to your valuable data!

A perfect example can be seen here, where YouTuber Tom Scott recounts the story of the time he became the world's most efficient 'content'-creator:



So, do you have any SQL blunders to tell us about - either your own or anybody else's?
Ryan
Administrator
*****


Administrators

28 posts 16 threads Joined: Aug 2020
15-08-2020, 01:48 AM -
#2
Luckily, I generally use a GUI for databases when I'm making changes so luckily I haven't made any massive mistakes yet!

That story is brilliant! :P
This post was last modified: 15-08-2020, 01:48 AM by Ryan.
Kyng
Junior Member
**


Members

17 posts 5 threads Joined: Jul 2020
16-08-2020, 05:41 PM -
#3
(15-08-2020, 01:48 AM)Ryan Wrote: Luckily, I generally use a GUI for databases when I'm making changes so luckily I haven't made any massive mistakes yet!

That story is brilliant! :P

I only do that occasionally (in particular, for small changes to small databases). 

For anything large, I just write out the queries myself. Fortunately, I've yet to do anything *too* disastrous (mainly because I don't do my work on live versions: that task is entrusted to people in another department :P )
This post was last modified: 16-08-2020, 05:42 PM by Kyng.


Forum Jump:


Users browsing this thread: 1 Guest(s)