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
Post a Comment