🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: dk.edb.database
Article #14988

[MySQL] ID-værdier i tabel

#14988
From: Christian Flintrup
Date: Fri, 27 Jul 2001 21:07
29 lines
1417 bytes
Hej,

Jeg har en tabel:

ID      Navn    By
------------------------
1       Finn    M�nevang
2       Kirk    �sterby
3       Ole     Vejby
4       Ronnie  Klosterbo

Hvordan laver jeg det s�dan, at hvis man fx sletter nr. 2, s� bliver det
s�dan her

1       Finn    M�nevang
2       Ole     Vejby
3       Ronnie  Klosterbo

I stedet for

1       Finn    M�nevang
3       Ole     Vejby
4       Ronnie  Klosterbo

Alts� s� den selv "vedligeholder" ID-kolonnen s� tallene er i r�kkef�lge

-- 
P� forh�nd tak
Christian Flintrup
Technical Details
Message-ID: <1ex882l.1h06pp71eu8fyeN%junk@osxhacks.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!grolier!fr.usenet-edu.net!usenet-edu.net!news.tele.dk!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,7e24e66917605510,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-27 14:07:04 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!grolier!fr.usenet-edu.net!usenet-edu.net!news.tele.dk!not-for-mail
Newsgroups: dk.edb.database
Subject: [MySQL] ID-værdier i tabel
From: junk@osxhacks.com (Christian Flintrup)
Date: Fri, 27 Jul 2001 23:07:03 +0200
Message-ID: <1ex882l.1h06pp71eu8fyeN%junk@osxhacks.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: MacSOUP/2.4.6
Lines: 29
Organization: TDC Internet
NNTP-Posting-Host: 62.243.43.100
X-Trace: 996268022 dread01.news.tele.dk 3204 62.243.43.100
X-Complaints-To: abuse@post.tele.dk