August 21st, 2000, 12:30 AM
Join Date: Jul 2000
Time spent in forums: < 1 sec
Reputation Power: 14
Say it I have a table like this :
id_Num int not null auto_increment
data varchar(250) not null
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 **