Thanks, Carlos > > Write a Friend said: > > When using AUTO_INCREMENT, is there a way to set the starting > > value. > > > > Thanks, > > Carlos > Alter Table TABLENAME AUTO_INCREMENT=1 > > where TABLENAME is your table. > > Of course this resets it so the next use of auto increment will generate a > 1 for the table. I use is right after deleting the contents of the table > and any related tables. (Its for a conversion program and I delete > everything if the conversion fails). > > William R. Mussatto, Senior Systems Engineer > Ph. 909-920-9154 ext. 27 > FAX. 909-608-7061 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]