Learn More
Resend Email
71
nikolatesla
8y

HR: Sorry, we're a family here but we have to let you go.

Engineer: Okay.

The End.
----

*DELETE FROM employees WHERE 1=1;*

rant

job

mysql

hr

career

database

admin
Favorite
Ranter
Comments
  • 15
    8y
    Dude just successfully cleared all the employee records. Well done!
  • 6
    8y
    @GiddyNaya it's like they never existed!
  • 3
    8y
    >HR
    ENOUGH.......
  • 10
    8y
    Not very efficient, 1=1 will lead to a full table scan and depending on the number of rows it can take a while. "TRUNCATE TABLE employees;" is a lot faster :)
  • 0
    8y
    @AlexAC53 That's nice! Me no DB guy. Thanks for the suggestion!
  • 6
    8y
    I remember that when a company/hr talks about being a family and shit, remember it's like telling a prostitute you love them.
  • 2
    8y
    @sudo-rm-rf it should but some databases throw an error by default when executing a delete statement without where clause, as a safety measure I suppose.
  • 1
    8y
    yeah I'm probably adopted

    so much for "family"
  • 1
    7y
    Truncate is also quicker because it doesn’t write to the redo log and can’t be rolled back
  • 1
    7y
    Delete from employees...

    Foreign key ref errors break the command -> nothing happens
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment