MyCity » Baze podataka » Deleting hole row.....

Deleting hole row.....

Napisano na dan: 23.6.2007

Deleting hole row.....
Sledeća strana Pagination

Idi na vrh

Poslao: 23 Jun 2007 12:33
Idi na vrh
offline
  • Pridružio: 30 Sep 2006
  • Poruke: 137

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?



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.
Poslao: 23 Jun 2007 13:05
Idi na vrh
offline
  • Pridružio: 19 Jun 2007
  • Poruke: 33
  • Gde živiš: Grad Beograd

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



Poslao: 23 Jun 2007 18:11
Idi na vrh
offline
  • Pridružio: 30 Sep 2006
  • Poruke: 137

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.

MyCity » Baze podataka » Deleting hole row.....

Ko je trenutno na forumu
 

Ukupno su 1167 korisnika na forumu :: 146 registrovanih, 13 sakrivenih i 1008 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 15694 - dana 01 Feb 2026 12:23

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: _Rade, A.R.Chafee.Jr., airliners, Alooo, ambra, amstel, Apok, Aska, babaroga, bakos022, Barista, blankspace, blue, Bo96, bojan_t, Bokimajk, Bombona, BORUTUS, borya90, BOXRR, bpvl, cifra, CikaKURE, cojapop, Colt D, comi, cvele130, cyprus, d.arsenal321, dankisha, dejan1972, DejvTroter, dekan.m, deki1001, deLacy, dijica, Diplomac, Djole3621, dnevnasoba, Dokon Pop, Dolinc, dukikan, Dzoni70, Ercomero, EVIDENTICAR, foka106, FOX, Fulcrum-A, galerija, GeoM, Georgius, GT, GveX, Heavy Jerk, Hemi, hyla, ikan, istokzapad, ivan1973, Jan, Jeremiah, JimmyNapoli, Jovan1983, Još malo pa deda, Kajzer Soze, Karaula, kinderpingvin, knutveliki, Kriglord, krkalon, lanishtefm, Lavočkin, LevQ, ljuba.b, LjubisaR, LostInSpaceandTime, Lucije Kvint, LUDI, maiden6657, Marko Marković, marsi, Medojed, metallac777, Mig 29, MIG-3, Miki 84, milenko crazy north, milutin134, mino bosanac, nebidrag, nemkea71, nenad81, niksa517, novator, Orc, perunnurep, petrovicrs, PlayerOne, PoolbegD02, Pv123, RILE-NS, royst33, Samo gledam, Sarmat, semity, Sevatar, Sharpshooter, shiro, singa, Singidunumac, SlaKoj, sluga, Sone0883, sova72, SpaDej, Srki98, stegonosa, steksi, stemark, Stoilkovic, SympathyForTheDevil, tachinni, tamno.nebo, Tandrkalo, The_new_Statesman, Tila Painen, tm, Toper, Tricko4190, Vanderx, vathra, Veless, Velizar Laro, Veljko™, vensla, vladao75, vladobreda, voja64, Vojkan Petrovic, Vrač, vzd1389, Yugol33, zdrebac, zivojin32, Zoca, Zukov