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
Thanks for the reply but that didn't do it.
I believe I've got this to work by performing the following steps:
DELETE FROM table_name (1000 rows)
INSERT INTO table_name(column) VALUES(value)
DELETE FROM table_name
Now when I perform another INSERT, the primary key starts at 1001.
Adam Zerlin
