From: "Issam W. Alameh" <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 3:46 AM
> I am using an auto_increment field, every time I delete from the table,
the
> counter goes back, is there any way to keep the incrementation regardless
of
> the number reached after delete
This is the way auto_increment work with the ISAM table format.
Solution: Upgrade to MySql version 3.23.xx and convert your tables to MyISAM
format, which behaves like you want.
Converting a table in the MySql console:
ALTER TABLE tablename TYPE = MYISAM;
- Carsten
~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
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
