When would you use ORDER BY in DELETE statement?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

When would you use ORDER BY in DELETE statement?

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

(Continued on next question...)

Other Job Interview Questions

• What is the difference between mysql_fetch_array and mysql_fetch_object?
• How do you change a password for an existing user via mysqladmin?
• MySQL - Why So Many Open tables?
• General Information About MySQL
• MySQL - How can I use replication to improve performance of my system?
• How do you get the number of rows affected by query?
• Database Basics
• The Main Features of MySQL
• MySQL - Troubleshooting Replication
• MySQL - When and how much can MySQL replication improve the performance of my system?
• More...