mysqli : DELETE FROM tablename WHERE id - 1234;

[ela]

Chrishan Ran Jayakody
48 minutes ago near Colombo, Sri Lanka
I sat at the MySQL console for the production web application database and typed:

DELETE FROM tablename WHERE id - 1234;

...and hit return.

Note that I typed "id - 1234", not "id = 1234".

In MySQL the statement (value - value) is false if it evaluates to 0, and true if it evaluates to anything else. I just asked the database to delete all rows where the ID minus 1234 was not zero.

It replied "80,000 rows deleted".

The 16 Biggest Tech Intern Fails via Business Insider
Like · · Share
3 people like this.


Source FB

 

[Xeroxeen]

Chrishan is one of my friend

 

[ela]

Chrishan is one of my friend

Mokak ooge friend list eka balapan maath innawa.

 

[NUWAN BUWA]

B
U
M
P

 

[kosandpol]

he should've used a mysql manager like phpmyadmin where delete statements get an automatic reconfirmation box. It could've saved those 80000 records.

 

[Xeroxeen]

Mokak ooge friend list eka balapan maath innawa.

ehemada ela ela.u mage honda friend kenek

 

[ela]

ehemada ela ela.u mage honda friend kenek

elakiri machan.

 

[Xeroxeen]

elakiri machan.

 

[TreadLightly]

he should've used a mysql manager like phpmyadmin where delete statements get an automatic reconfirmation box. It could've saved those 80000 records.

He can still use rollback and get most of it back.

 

[coolparkinglot]

production wala ohoma thamai, - ekak rm ekak athi kela welama yanna

 

[M E T H]

MONA SUTTAKDA BAN ME?

 

[mottaya]

 

[ruchira88]

backup kiyala deyak thiyenne owata thama

 

[Xeroxeen]

backup kiyala deyak thiyenne owata thama

naha ban u kiyala thiyenne meka mysqli fault ekak kiyala.e issue eka fix karanna kiyala uge db eke backup ekak athi

 

[ruchira88]

naha ban u kiyala thiyenne meka mysqli fault ekak kiyala.e issue eka fix karanna kiyala uge db eke backup ekak athi

 

[ela]

naha ban u kiyala thiyenne meka mysqli fault ekak kiyala.e issue eka fix karanna kiyala uge db eke backup ekak athi

 

[Xeroxeen]

 

[prazadx]

hapoi mama nam kalinma backup ekak aragenai wedeta bahinne. karapu tikata kela unath kalin thibba point ekata hari badu have ne.

 

[Xeroxeen]

hapoi mama nam kalinma backup ekak aragenai wedeta bahinne. karapu tikata kela unath kalin thibba point ekata hari badu have ne.

 

[Manash]

hapoi mama nam kalinma backup ekak aragenai wedeta bahinne. karapu tikata kela unath kalin thibba point ekata hari badu have ne.