Home > DeveloperSection > Interviews > When would you use ORDER BY in DELETE statement?

Posted on    April-09-2012 9:04 AM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1655  View(s)
Rate this:

Arun Singh

Total Post:310

Points:1550
Posted on    April-09-2012 12:00 AM

When are you not deleting by row ID. Such as in DELETE FROM techpreparation_com_questions ORDER BY timestamp LIMIT 1. This will delete the most recently posted question in the table techpreparation_com_questions.


Don't want to miss updates? Please click the below button!

Follow MindStick