How to reset auto_increment in MYSQL?

[basil]

Ok, I have a database table that I interface using PhP and this table has a column called PID which I have set to AUTO_INCREMENT. I have put 90 fields of data in the table and the auto_increment was working finr. However, The only problem is, I had to delete some colums (all above PID 74). But now, when I add new data onto the table, the PID gets updated as if I still had 90 fields. In otherwords, the next data I enter, the PID updates to 91, 92, 93, etc

Queston. How can I "reset" an Auto_increment column in my table, so that the next insert will increment the PID to 74?

Any help would be most appreciated,
Basil

[hermzz]

try inserting a new register and giving it the last value you want, 74 in your case, then delete it. you can also for the first new register you are going to insertgive it a value of 75 and from then on use last_used_id or whatever it is.

[basil]

Actually, I found what I was looking for. If, for example, I had 95 records and deleted all but 73 of them, and then wanted the next record to have ID=74 (and not 96), All I had to do was this:

Mysql> ALTER TABLE mytable Auto_Increment=74;

That reset the Auto_incremented field to 74. Worked perfect.

Cheers,
Basil