Hello,

When I run a DELETE FROM table_name, my primary key field is reset
back to 1. Is there any way for it to not do this? Preferably, if
there were 1000 records in table_name, and I ran DELETE FROM
table_name, that the primary key field would start at 1001.

This is an InnoDB table if that helps.

Thanks!