Hi,

I have one table which have more than 1076967 rows. the table have ID filed with auto-increment value.

I need to check if some row is deleted from that table or not? We are suspecting some hacker he delete some rows but in this huge records i cannot find if really it is deleted?

Please help to find out, how i can check if any record is deleted from this table?

Best Regards,

What makes you believe that data jas been deleted?
Is it because there are gaps in the sequence of IDs?
Do you know the ID, or other key values, of the deleted record?

Gaps can occur in the sequence of IDs due to delete's, transactions rolling back or bulk inserts - go to this page and search for the word gap.