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]