SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:23 AM
| ||||
| ||||
 Retaining last primary key value 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!      |
|
02-28-2008, 05:23 AM
| ||||
| ||||
| Re: Retaining last primary key value 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 <adamz@imagespaceinc.com> 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? >> unsub=docbook.xml@gmail.com >> >> > > > -- > Saqib Ali, CISSP, ISSAP > http://www.full-disk-encryption.net > > |
Linear Mode
