On Thu, 29 Apr 2004 12:27:46 -0300 (ART) Leandro Melo <[EMAIL PROTECTED]> wrote:
> Hi, > i got a table wich its pk is an auto_increment field. > I have 10 elements in this table, wich makes the pk_id > field = 10. > I inserted incorrectly anoter row in this table (the > 11th) and imediately deleted it. Although, i'd like > that the next time i insert a row in this table, it's > index be still 11 (not 12 as mysql would do by > default). > Is there any fast command i can make to correct the > table situation? ALTER TABLE your_table AUTO_INCREMENT = 11; Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]