Welcome, Guest

ORDER BY in DELETE statement

(1 viewing) (1) Guest

All your queries regarding
MySQL Installation,
Learning MySQL DBA,
and tonnes more... will be solved in this forum

Reply Topic

TOPIC:

ORDER BY in DELETE statement

ORDER BY in DELETE statement 1 year, 3 months ago #497

palak OFFLINE Senior Boarder Posts: 55 Karma: 0	When would you use ORDER BY in DELETE statement?
	Reply Quote

isaac OFFLINE Senior Boarder Posts: 64 Karma: 0	When you’re not deleting by row ID. Such as in DELETE FROM table_name ORDER BY col_name LIMIT 1. This will delete the most recently posted question in the table table_name
	Reply Quote

Reply Topic

Time to create page: 2.01 seconds