job - HR: Sorry, we're a family here but we have to let you go. Engineer: Okay. The End. ---- *DELETE FROM employees WHERE - devRant

Ranter

Comments

15

GiddyNaya

10036

5y

Dude just successfully cleared all the employee records. Well done!
6

FinlayDaG33k

6328

5y

@GiddyNaya it's like they never existed!
3

beegC0de

1313

5y

>HR
ENOUGH.......
10

AlexAC53

75

5y

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

nikolatesla

16300

5y

@AlexAC53 That's nice! Me no DB guy. Thanks for the suggestion!
6

sjwsjwsjw

1448

5y

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

Lvh1

35

5y

@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

ctrl-alt-del

1288

5y

yeah I'm probably adopted

so much for "family"
1

gruff

563

5y

Truncate is also quicker because it doesn’t write to the redo log and can’t be rolled back
1

mrrmc

229

5y

Delete from employees...

Foreign key ref errors break the command -> nothing happens

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service