But how will that interact with the auto increment counter? Will truncate reset the counter.
Chris wrote: > > Peter Lauri wrote: > > DELETE FROM table > > Truncate will be a lot better. > > DELETE FROM table will do it row by row which also means it will have to > update any indexes applicable to the table as it goes... > > Lots of data & lots of indexes = very slow. -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]