Deleting hole row.....

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

when i delete a row i want to decrement the ID field.
example
let's say i have a table with those values
ID | name |
1 | Ivan |
2 | bojan |
3 | ranko |

and when i want to delete the second row, the third row to be decremented like this
ID | name |
1 | Ivan |
2 | ranko |

anyone know the command?

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Well, It is not good solution to change ID. But if You have to do it, I will suggest You to make cascade trigger which will go through all tables where this key is used, and change id. It is very bad solution, but You asked for it.

And, here is pseudo code for changing ID.

FOR n := DeletedID+1 to RowCount
Id := Id - 1
ENDFOR

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

hmmmm that is for mysql?

I readed somewhere that i can use "pack" at the end of the statemant, but it's not working or i m not using in the right way.