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
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
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]