Hello!! ALTER TABLE $table1 AUTO_INCREMENT = 242
Replace the $table with your table's name and replace the end number with what number you want. Dan On Thursday, June 13, 2002, at 08:27 PM, [EMAIL PROTECTED] wrote: > Hi guys, > > The auto_increment field of my MySQL table gives me "258", although the > higher value at the moment is "241". > > I deleted the latest records, thinking that also the auto_increment > would > decrease, but this is not. > > I would like to know if there is a way to bring the auto_increment back > to > the higher value + 1. > > > Cheers > > Daniele > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
