I want to delete all rows after 100th row in a table in mysql. For some reason this table does not have any coloumn with Auto\_increment or primary key. How can I delete all rows after 100th row? what can be the query for this?

**as I think** that I have to add another column in my table with auto\_increment and then delete after 100th row and then remove this column? or any better suggestion?

The actual problem aroused when I was copying all rows from 1 table to another and mistakenly duplicated all rows in the same table through a sql dump file. So, now I want to delete all rows after 100th row.