Re: renumbering auto-increment?

2002-02-04 Thread BD
At 01:19 PM 2/4/2002 , you wrote: >2) I use MySQLfront just for a couple of days. I find it very usefull (has >to be written in Delphi) Is this the best freeware for this job or is there >a better one ? Makis, MySQLFront is pretty good considering the price. :) There is

Re: renumbering auto-increment?

2002-02-04 Thread Nathan
If you are using tables of the MyISAM type, the auto-increment goes up every time you insert, regardless of any deletes. The only way to reset it is to drop and re-create the table or do a "delete from table" command with no where clause. ISAM tables do not do this. Read up in the manual on tab