Re: [Q] about AUTO_INCREMENT...

2003-07-27 Thread Write a Friend
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 generat

Re: [Q] about AUTO_INCREMENT...

2003-07-25 Thread William R. Mussatto
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 afte

[Q] about AUTO_INCREMENT...

2003-07-25 Thread Write a Friend
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]