Menu

#524 Auto increment values reorganising

Needs_decision
invalid
nobody
3
2013-06-11
2004-05-16
McLamb
No

This is just a small suggestion but would be very
valueable to keeping a database organized, neat, and
possibly for large databases reducing the size. My idea is
if you have a primary key that just does 1, 2, 3, 4, with
the auto inc feature that there would be a link to
reorganize them. Sometimes you have to delete them, or
just when testing you skip around so its 1, 2, 45, 48, 49,
51 what about something that reorgainizes them into 1,
2, 3, 4, 5. It would be somewhat simple to code and you
could always put a big warning at the top about what
this does and to make sure your using it on the right
field. In my opinion this would be an extreamly useful
feature.

Thanks
- Derek
admin@mclamb.us

Discussion

  • Michal Čihař

    Michal Čihař - 2004-05-17
    • priority: 5 --> 3
    • summary: Organizing Primary Key --> Auto increment values reorganising
     
  • McLamb

    McLamb - 2004-05-28
    • priority: 3 --> 9
     
  • McLamb

    McLamb - 2004-05-28
    • priority: 9 --> 3
     
  • madurapradeep

    madurapradeep - 2013-02-12

    If somebody not try on this, then i will

     
  • Marc Delisle

    Marc Delisle - 2013-02-12

    I'm not sure that there is much interest for this feature.

     
  • McLamb

    McLamb - 2013-02-12

    I agree with Marc. Could someone delete this ticket or at least remove my name and email from it please?

     

    Last edit: McLamb 2013-02-12
  • Marc Delisle

    Marc Delisle - 2013-02-12
    • status: open --> closed-rejected
    • milestone: --> Needs_decision
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-rejected --> invalid