Organizational Research By

Surprising Reserch Topic

When to use ORDER BY in DELETE statement?


 

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



Related Hot Questions

1 Answer

0 votes
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 
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count] 
ORDER BY clause is specified, the rows are deleted in the order that is specified.
 

 

answered Sep 13, 2013 by rajesh
edited Sep 12, 2013

...