Re: [Q] about AUTO_INCREMENT...
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]
Re: [Q] about AUTO_INCREMENT...
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]
[Q] about AUTO_INCREMENT...
When using AUTO_INCREMENT, is there a way to set the starting value. Thanks, Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]