auto increment

[asmith]

$sql = "create table aaa(id int NOT NULL AUTO_INCREMENT, username varchar (30),PRIMRY KEY (id))";

 

i created a table just like that , i added one user name , it gave the id , 1 .

then i deleted the username, and  do a select * from table, it said it is empty,

i inserted another username, it gave id ,2 !

can i make it to give the id 1 again ?

[revraz]

This would be a MySQL issue, not really a PHP one.

[asmith]

php and mysql are like brothers ! or father and son ! 

[rarebit]

Sorry, took a while to find, also been a few posts since i last looked at it: http://www.phpfreaks.com/forums/index.php/topic,159599.0.html, it also refers to other posts...

[shedokan]

I had the same problem here's the solution:

ALTER TABLE yourtablehere AUTO_INCREMENT=1

[fenway]

Use TRUNCATE TABLE if you want to delete everything -- otherwise, leave the auto increment field alone.