Nov 6, 2014

When would you use ORDER BY in DELETE statement?

When you’re 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.

0 comments:

Post a Comment