> "Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: >> >> I once red that using "truncate table xx" instead of "delete from xx" >> should reset autoincrement , but it seem not to happend. >> >> but when I try to insert data with "insert" or "load data in " >> it remember the old autoincrement value. >> >> from manual : >> "Truncate operations drop and re-create the table, which is much faster >> than deleting rows one by one. " >> >> seems not , when I drop table and the create table again it works >> perfect. >>
> > What table type do you use? TRUNCATE TABLE reset auto_increment value for > MyISAM table, but not for InnoDB. > > thanks Egor I use InnoDB , so that explains it :-) what Are the most easy way to reset the value in innodb 4.014 regards Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
