Re: delete from table where id = $id"

Article View: dk.edb.database

Article #15043

#15043

From: Henrik Hansen
Date: Sun, 22 Jul 2001 19:25

31 lines
1967 bytes

"hehe" <clark@cool.dk> wrote:

>>  > Hvordan sletter man en hel r�kke i en table. Jeg har pr�vet med
 > f�lgende,
>>  > men det virker ikke rigtigt...
>>  >
>>  >   $drop = "delete from nyheder where id = $id";
>>  >   mysql_query($drop)
>>  >     or die(mysql_error());
>>
>> Det skulle virke er du sikker p� der er en r�kke med det id du pr�ver
>> at slette?
 > 
 > Ja det er jeg 100% sikker p�...!! Jeg har 3 r�kker i den tabel, og jeg skal
 > have slettet alle sammen, s� der er ikke s� meget at g� fejl af :)

slettet alle sammen? s� skal du droppe den where du har p�.

 > Er der ikke en syntax hvor der st�r noget med "delete row" eller s�dan
 > noget??

syntaxen er:

DELETE [LOW_PRIORITY] FROM tbl_name
    [WHERE where_definition]
    [LIMIT rows]

http://www.mysql.com/doc/D/E/DELETE.html

-- 
Henrik Hansen

Technical Details

Message-ID: <itgkix5o.fsf@mailserver.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail

References: <9jf6v9$fdi$1@news.cybercity.dk> <n15wiylw.fsf@mailserver.dk> <9jf7t9$grk$1@news.cybercity.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,55494f23962d8bbc
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-22 12:22:55 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail
Newsgroups: dk.edb.database
Subject: Re: delete from table where id = $id"
References: <9jf6v9$fdi$1@news.cybercity.dk> <n15wiylw.fsf@mailserver.dk>
 <9jf7t9$grk$1@news.cybercity.dk>
From: Henrik Hansen <hh@mailserver.dk>
Message-ID: <itgkix5o.fsf@mailserver.dk>
Lines: 31
User-Agent: Gnus/5.090004 (Oort Gnus v0.04) Emacs/20.7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Date: Sun, 22 Jul 2001 21:25:23 +0200
NNTP-Posting-Host: 212.54.85.238
X-Complaints-To: news-abuse@wol.dk
X-Trace: news000.worldonline.dk 995829774 212.54.85.238 (Sun, 22 Jul 2001 21:22:54 MET DST)
NNTP-Posting-Date: Sun, 22 Jul 2001 21:22:54 MET DST
Organization: Customer of Tiscali A/S (World Online)

Reply to Parent Message