sql - Deleting rows with MySQL -


hypothetically, if have 6 rows meet criteria ..

(ie, where first = 'bob' , middle = 'j' , last = 'dole')

..and delete table first = 'bob' , middle = 'j' , last = 'dole' limit 5..

which 5 rows deleted first?

my assumption delete rows lowest primary key first, correct?

by default sql delete rows top bottom in database, inshort first 5 records in table, if want, can order them first using order by clause asc or desc


Comments