I want to re-set mysql's auto_increment value from phpMyAdmin

[paulg]

Hi Guys,

I have a table which I've been using as a testbed, which I now want to make live.

The problem is that the primary field is an auto-increment field and although I've deleted 30 or so rows from the table (keeping 230 valid rows), the next inserted record gets a value of 263.

How can I reset this so that the next value will be 231, using phpMyAdmin if possible?

Many thanx in advance,

Paul.

[devinemke]

ALTER TABLE tablename AUTO_INCREMENT = 1

[paulg]

You are indeed devine - many thanks :-)