On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
> Hi,
>
> I have a table with an auto_increment field. When I
> delete all the record and insert a new one the
> auto_increment field is not clean, its follows the
> sequence.
>
> Can I restart this sequence? Start from 0 again?

When I need to do this, I just drop and re-create the table.

simon



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to