The problem is the most recent 100 records won't be sequential. There
are records with many different identifiers, in random order mixed
with other records that I don't want deleted, and each time I do this
I'm going to be limiting each subset of identified records to only
the most recent 100. So I can't depend on the availability of a
autoincrement field.
Pretend it's a table of student test scores. I want to delete all of
Johnny's test scores except his 100 most recent, but I don't want to
delete anyone else's test scores in the same table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
