MySQL Forums
Forum List  »  MyISAM

index auto_increment
Posted by: massimo tecnico
Date: February 07, 2014 11:45AM

Hello to all,

I have a table with MyISAM engine, with a key with more fields (year, customer idricevuta) auto_increment
When I add a field in automatic I read this becomes id is in receipt number.


But if I delete the fields I would like the next record inserted reuse index not used.

an example:

id user year
1 aaaa 2014 ...
2 aaaa 2014 ...
1 bbbb 2014 ...
2 bbbb 2014
3 bbbb 2014

if I delete record 2 aaaa 2014, and I insert two new a record I would like to have

id user year
1 aaaa 2014
2 aaaa 2014 new
1 bbbb 2014
2 bbbb 2014
3 bbbb 2014
3 aaaa 2014 new

do you think i can do?

Options: ReplyQuote


Subject
Views
Written By
Posted
index auto_increment
3484
February 07, 2014 11:45AM
1827
February 10, 2014 03:48PM
1818
February 11, 2014 07:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.