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

@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)
 
I could be wrong but isn't good habits to have comments explaining what parts of code do?
 
Tom Scott uploaded a new video today that's very apt.
https://www.youtube.com/watch?v=X6NJkWbM1xk
 
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
 
@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.
 
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..
 
That's why you should never write delete from first when editing a mysql database.
 
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

Back
Top