auto_increment in MySQL

Say it I have a table like this :

table testing
id_Num int not null auto_increment
data varchar(250) not null
primary key(id_Num)

Then I insert into the table :
insert into testing (data) values ("Testing");

I do it until it has about 3 records.

Then I delete record number 3.
After that I insert another record, according to me the id_Num should be 3. Isn't it??

The fact id_Num of the new record is 4.

I tried it at home and I got what I want (the id_Num of new record id 3), but at college it doesn't work !!

Can anybody tell me why ???



------------------
** It's the world of Oscario **

Yeah.. i sort of wanted to know how to do that too..

This i haven't tried.. but have you tried to set the default to 0??

Tell me if it works..

scoobydoo

Finally...
I found it.

Just check out the documentation in www.mysql.com

It's said that my problem is caused by the type of the table.

MyISAM table can't do that !!
But ISAM table can.
So I just change the type of my table by issuing :
"alter table tablename type=ISAM"

or create the table with ISAM type by issuing :
" create table tablename (fields specification) type = ISAM"

And the problems solved out !!

See ya !!!



------------------
** It's the world of Oscario **