Erick,
Thursday, July 18, 2002, 10:17:12 AM, you wrote:
>> let us say i have a table:
>>
>> customers
>> id int(10) auto_increment
>> name varchar(20)
>>
>>
>> whenever i do,
>>
>> insert into customers (name) values ('...');
>>
>> it automatically generates the id, right? that is the meaning of the
>> auto_increment index key. now my question is that if i add a name and
>> then delete it, this index remains increasing. if i add a new row, and
>> then immediately delete it (not some time later, immediately) in that
>> case do i have a way of rewinding the index?
On BDB and ISAM tables, yes. If you delete row with maximum id, the next
inserted row will have the same value in the auto_increment field.
On MyISAM and InnoDB tables, no.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
