These Two Will Be Married In 100 Days - Ch. 74 - Day 74

Group Leader
Joined
Feb 12, 2018
Messages
925
@Mogima He's deleting stuff from a table that presumably has customer data, but he didn't specify a condition for what he wants to delete, so it'll just delete everything in the table. (Disclaimer: I know like nothing about MySQL)
 
Member
Joined
Jan 27, 2018
Messages
160
I could be wrong but isn't good habits to have comments explaining what parts of code do?
 
Fed-Kun's army
Joined
Jan 18, 2018
Messages
318
Tom Scott uploaded a new video today that's very apt.
https://www.youtube.com/watch?v=X6NJkWbM1xk
 
MD@Home
Joined
Jan 30, 2018
Messages
18
it's nice that the author made this part "realistic" with the SQL statement and all, but i hope they also consider that every company that has something to its name does regular backups which makes this not harmless, but not as bad as "deleting everything" since they at most lost like 1 week of data
 
Dex-chan lover
Joined
Sep 21, 2018
Messages
641
@Mogima & @Lyanhyrt: The line of code is from a database-oriented language called MySQL. It's a query to database and translates into "delete all entries from the customers database table". This is a MAJOR no-no dealing with databases, second only to the DROP instruction (a.k.a. destroy a table and everything on it).

However, a thing: you cannot simply walk into Mordor use a query, it has to be written and coded beforehand. So what he's seeing is probably not his code, it's somebody else's. Probably is that query what he thinks that doesn't belong there. (Using queries like that isn't unusual in testing phases) That again, maybe he's cheching the DB so maybe he's in a world of trouble.
 
Active member
Joined
Jan 20, 2018
Messages
234
Goddyam OOF

I don't think I can keep up with regular updates any more, gonna have to wait this arc out.

Being omega-stupid hits a bit too close to home from my teens..
 
Dex-chan lover
Joined
Mar 21, 2019
Messages
199
That's why you should never write delete from first when editing a mysql database.
 
Dex-chan lover
Joined
Aug 9, 2018
Messages
4,208
I think something like this happened at pixar where some retard employee hit a delete command and they lost 3/4 of the work on Toy Story 2
 

Users who are viewing this thread

Top