use ORDER BY in DELETE statement?

The ORDER BY clause in DELETE statement is used when a deletion has to take place by in a specified order. The syntax is like this 
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count] 
ORDER BY clause is specified, the rows are deleted in the order that is specified.


asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.