Re: renumbering auto-increment?

[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 table types and decide which is best for you. AFAIK there is no pack option for 
MyISAM.

# Nathan

- Original Message -
From: savaidis [EMAIL PROTECTED]
To: MySQL list (E-mail) [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 12:19 PM
Subject: renumbering auto-increment?



Hello all !

I see it's a very busy list so I will try to by short to my first question:

1) Is there a way to put the REAL numbers of rec in the ID=auto-increment? I
made some tests so this number is higher than total recs of the
table.(export/import to text doesn't help)
The Rec_num is stored somewhere? Or is there a pack command?

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 ?

Thanks

Makis

Thessaloniki
Makedonia
Greece




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: renumbering auto-increment?

[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 also MySQLMgr from EMS which is slightly better, 
but it costs $99. You can get a 30 day eval from 
http://www.ems-hitech.com/mymanager/. It has much better reporting and is 
MDI which means you display more than 1 table definition at a time.  It 
also has a lot of tools like a Grant Manager, SQL monitor, the ability to 
repair/optimize tables etc.. It runs under Windows.  If you plan on using 
MySQL a lot, it is worth a look.

Brent

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php