On Wed, 27 Aug 2003 09:05:17 -0300 "bernardaum" <[EMAIL PROTECTED]> 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? yes, use TRUNCATE TABLE table; to restart sequence. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
