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