WHEN WOULD YOU USE ORDER BY IN DELETE STATEMENT?

Arun Singh

Total Post:310

Points:1550
Posted by  Arun Singh
MYSQL 
 1978  View(s)
Ratings:
Rate this:
  1. Arun Singh

    Post:310

    Points:1550
    When would you use ORDER BY in DELETE statement?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!