id

[adt2007]

hiii

 

im editing an old scriptof mine, and i want to "restart" the id system

 

what i mean is, for example, the next person to register their id will be 229.

 

how do i edit the mysql database so it starts from 1 again?

i've removed all users.

[pocobueno1388]

Just truncate the entire thing.

 

<?php

mysql_query("TRUNCATE TABLE users");

?>

 

In phpmyadmin, you can click on "empty" and it will restart it as well.

[jscix]

mysql internally keeps record of auto-incrementing values.. i'm sure you could look it up.. I personally haven't dealt w/ it before.. is there any specific reason you want to start it over? It doesnt really effect anything.

[wcsoft]

Two way.  If you're deleting all of the data in the table, you can use the TRUNCATE command:

 

truncate tablename

 

That deletes everything, and resets the auto_increment field to 0

 

Or:

 

ALTER TABLE tablename AUTO_INCREMENT=0;

[adt2007]

thanks everyone!

 

Two way.  If you're deleting all of the data in the table, you can use the TRUNCATE command:

 

truncate tablename

 

That deletes everything, and resets the auto_increment field to 0

 

Or:

 

ALTER TABLE tablename AUTO_INCREMENT=0;

 

where do i enter the command?

[wcsoft]

Either of those would be done in your mysql manager.  phpmyadmin, direct command line on the mysql shell.  Basically whatever you use to execute sql commands on your sql server.