删除记录后的Mysql减少其他ID

Question

I have the database where i save my records. The records was saved as ID, name

example

1. Nick
2. Name
3. Username

Now when i delete the record with id 2. in my database it remains as 1. Nick 3. Username I want that when i delete one record from database other id's automatic decrement for one value so i get. 1. Nick 2. Username Do you understand my question. Sry for bad english

Button delete code

if(isset($_POST['tipkaobrisi'])) // pritisnuta tipka obrisi
{
    $obrisankorisnik = $_POST['obrisi'];
    if ( $obrisankorisnik == '' )echo "<div align='center'>Unesite korisnika kojeg  zelite obrisati!</div>";
    else
    {
        mysql_query("DELETE FROM Korisnici WHERE Korisnik ='$obrisankorisnik'");
        echo "<div align='center'>Korisnik obrisan<br><br></div>";
    }
}

Answer 1

After listening other programer's advice's. I decide that i don't want to edit my ID's.

Thanks to all for participating.