Thursday, June 20, 2002, 14:44:27, Marius Stan <[EMAIL PROTECTED]> wrote: > interesa o metoda (mai bine zis un mecanism al mysql-ului) sa resetez > valoarea interna a auto_increment-ului. > Am inteles ca nu exista. Asa ca... dump/import m-a rezolvat.
Iata citeva spicuiri din manual: "The AUTO_INCREMENT value can be reset with myisamchk." "If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value will be reused with an ISAM table but not with a MyISAM table." "You can set the first sequence number by executing SET INSERT_ID=# before ALTER TABLE or using the AUTO_INCREMENT = # table option." Nu stiu cit te ajuta... -- GZ --- Pentru dezabonare, trimiteti mail la [EMAIL PROTECTED] cu subiectul 'unsubscribe rlug'. REGULI, arhive si alte informatii: http://www.lug.ro/mlist/
