List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 5 2001 4:47am
Subject:Re: Refresh table after deleting a row
View as plain text  
At 4:26 PM -0500 11/4/01, duraid wrote:
>i have a table with and ID column that auto_increment with that 
>following content
>
>+----+--------------+------------+------------+
>| ID | JokeText     | JokeDate   | AuthorName |
>+----+--------------+------------+------------+
>|  1 |   what's up? | 2001-11-04 | duraid     |
>| 2 |   duraid     | 2001-11-04 | mama       |
>|  3 |   why        | 2001-11-04 |            |
>+----+--------------+------------+------------+
>
>problem is say i delete ID=2 row i end up with
>+----+--------------+------------+------------+
>| ID | JokeText     | JokeDate   | AuthorName |
>+----+--------------+------------+------------+
>|  1 |   what's up? | 2001-11-04 | duraid     |
>|  3 |   why        | 2001-11-04 |            |
>+----+--------------+------------+------------+
>
>and when add a new row , ID will be 4. how can i reorganize the 
>table after deleting a row so that the ID wil remain intatct.

Why bother?  MySQL doesn't care if the IDs are sequential.
Thread
Refresh table after deleting a rowduraid4 Nov
  • Re: Refresh table after deleting a rowPaul DuBois5 Nov
RE: Refresh table after deleting a rowRick Emery5 Nov