> > > > > > > delete from mytable where record_no=? limit ? > > Setting the first parameter to the record number and the second to count > - 1. >
Ah "limit", yes that should help. However, I do not know each individual nos for these "record_no" Can I have sth that will dynamically delete those records when count > 1. My version does not allow subqueries, and I am not too familiar with advanced MySQL stuff. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]