Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


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 
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.
 

 


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



Related Hot Questions



Government Jobs Opening


...