hello 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. Mysql Linux 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]
