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
On Dec 8, 2006, at 11:38 AM, Saqib Ali wrote:
try the DELETE with the WHERE clause
e.g.
DELETE FROM table_name WHERE 1=1
saqib
http://www.full-disk-encryption.net
On 12/8/06, Adam Zerlin <[EMAIL PROTECTED]> wrote:
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!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
Saqib Ali, CISSP, ISSAP
http://www.full-disk-encryption.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
