I have a mysql table loaded with image data. that is used to display images . It has the following definition. 

| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(10)      |      | PRI | NULL    | auto_increment |
| name     | varchar(50)  |      |     |         |                |
| filename | varchar(100) | YES  | MUL | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

[download]
I use a auto_incremented field id to identify the image.The client wants to be able to delete a image. when I delete the image from the table there is a gap in the id field. id=1,id=2, id=4, id=6. I need to be able to reassign the id number when I delete an image from the table. so it is unbroken or skip id numbers for which there is no image. Is there any way to accomplish this.

thank you
jwlarson3rd

Edit, BazB: fix code tag.

In reply to mysql auto_incremented id by jwlarson3rd

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.