Wagner, Chris (GEAE, CBTS) wrote:
But how will that interact with the auto increment counter? Will
truncate reset the counter.
According to the docs it will:
http://dev.mysql.com/doc/refman/5.1/en/truncate.html
The table handler does not remember the last used AUTO_INCREMENT value,
but starts counting from the beginning. This is true even for MyISAM and
InnoDB, which normally do not reuse sequence values.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]