Restart Auto_increment

techgearfree · 02-13-2005, 07:36 PM

How do I restart a collumn with auto_increment. I want it to start counting up from 1 again.

hemebond · 02-13-2005, 09:09 PM

Why do you want to do that?

techgearfree · 02-13-2005, 09:43 PM

I was testing on my website how it makes users. When someone signs up. Their info goes into a table. I no longer need to test it, so I deleted all the users that I made. But, now when I make a user, in the user id column that is auto increment, the first user is like #42 (where I left off).

hemebond · 02-13-2005, 09:55 PM

And why is this a problem?

(drop and recreate the table)

techgearfree · 02-13-2005, 10:06 PM

Just for organizational sake. Is there any way to get the current code for the table so I don't have to type it all in again?

hemebond · 02-13-2005, 10:17 PM

If you use phpMyAdmin you can do a quick export. Otherwise, dump the table and edit out the data.

andyede · 02-14-2005, 12:43 AM

or just let it carry on counting from where it is. Is there any reason it needs to start at 1?

BigToque · 02-14-2005, 07:19 AM

The way to do this (the easy way) is with phpMyAdmin.

When looking at the table structure, drop the auto-incrementing field, then recreate it. All entries will be renumbered starting from 1.

kenetix · 02-15-2005, 02:06 PM

you could drop and reinsert the table and then populate it with the values.

Brandoe85 · 02-15-2005, 03:09 PM

You can try:
alter tableName auto_increment = 1;

Not tested though...

02-13-2005, 07:36 PM	PM User \| #1
techgearfree Regular Coder Join Date: Jan 2005 Posts: 148 Thanks: 0 Thanked 0 Times in 0 Posts	Restart Auto_increment How do I restart a collumn with auto_increment. I want it to start counting up from 1 again.

02-15-2005, 02:06 PM	PM User \| #9
kenetix New Coder Join Date: Feb 2005 Posts: 10 Thanks: 0 Thanked 0 Times in 0 Posts	you could drop and reinsert the table and then populate it with the values. __________________ Kenetix:: Achieving more than the ordinary. http://www.kenetix.net

02-15-2005, 03:09 PM	PM User \| #10
Brandoe85 teh Moderatorinator Join Date: Sep 2004 Location: USA Posts: 2,435 Thanks: 2 Thanked 38 Times in 38 Posts	You can try: alter tableName auto_increment = 1; Not tested though... __________________ -Brando Why using tables for eating is stupid!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

02-13-2005, 09:09 PM	PM User \| #2
hemebond Senior Coder Join Date: Jul 2004 Location: New Zealand Posts: 1,315 Thanks: 0 Thanked 2 Times in 2 Posts	Why do you want to do that?

02-13-2005, 09:43 PM	PM User \| #3
techgearfree Regular Coder Join Date: Jan 2005 Posts: 148 Thanks: 0 Thanked 0 Times in 0 Posts	I was testing on my website how it makes users. When someone signs up. Their info goes into a table. I no longer need to test it, so I deleted all the users that I made. But, now when I make a user, in the user id column that is auto increment, the first user is like #42 (where I left off).

02-13-2005, 09:55 PM	PM User \| #4
hemebond Senior Coder Join Date: Jul 2004 Location: New Zealand Posts: 1,315 Thanks: 0 Thanked 2 Times in 2 Posts	And why is this a problem? (drop and recreate the table)

02-13-2005, 10:06 PM	PM User \| #5
techgearfree Regular Coder Join Date: Jan 2005 Posts: 148 Thanks: 0 Thanked 0 Times in 0 Posts	Just for organizational sake. Is there any way to get the current code for the table so I don't have to type it all in again?

02-13-2005, 10:17 PM	PM User \| #6
hemebond Senior Coder Join Date: Jul 2004 Location: New Zealand Posts: 1,315 Thanks: 0 Thanked 2 Times in 2 Posts	If you use phpMyAdmin you can do a quick export. Otherwise, dump the table and edit out the data.

02-14-2005, 12:43 AM	PM User \| #7
andyede Regular Coder Join Date: Sep 2004 Posts: 133 Thanks: 0 Thanked 0 Times in 0 Posts	or just let it carry on counting from where it is. Is there any reason it needs to start at 1?

02-14-2005, 07:19 AM	PM User \| #8
BigToque New Coder Join Date: Jan 2005 Posts: 38 Thanks: 0 Thanked 0 Times in 0 Posts	The way to do this (the easy way) is with phpMyAdmin. When looking at the table structure, drop the auto-incrementing field, then recreate it. All entries will be renumbered starting from 1.