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.
Liked By
Write Answer
When would you use ORDER BY in DELETE statement?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
09-Apr-2012When 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.