Re: query

Article View: nl.comp.programmeren

Article #455

Back to nl.comp.programmeren Previous Next

#455

From: Dr.Ruud
Date: Fri, 02 Apr 2004 17:54

34 lines
2110 bytes

Toen ik Snuyt kietelde, kwam er dit uit:

> tabel
> id Ander_id waarde
> [...]
> het kan dus zijn dat er meerdere rijen zijn met Ander_id dezelfde
> waarde. Ik wil nu 1 rij verwijderen met Ander_id=1 (of een andere
> waarde). Ik gebruik volgende query, maar hij geeft een foutmelding:
>
> DELETE FROM tabel WHERE Ander_id=1 LIMIT 1


Probeer hier eens wat van (allemaal ongetest)

DELETE * FROM tabel WHERE Ander_id=1 LIMIT 1

DELETE * FROM (SELECT tabel WHERE Ander_id=1 LIMIT 1)

DELETE A.* FROM (SELECT tabel AS A WHERE Ander_id=1 LIMIT 1)

DELETE * FROM tabel WHERE Ander_id=1 AND id = (SELECT Min(Id) FROM tabel
WHERE Ander_Id=1)

DELETE * FROM tabel WHERE Ander_id=1 AND id = (SELECT Min(Id) FROM tabel
WHERE Ander_Id=1 GROUP BY Ander_id)

Die laatste 2 zoeken dus het Minimum-ID op, ik neem aan dat je die row
wilt verwijderen?

-- 
Affijn, Ruud   `  -  �
               + ` � *
                 � `
               �  =  `

Technical Details

Message-ID: <c4kgn6.1mo.1@news.isolution.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!news2.telebyte.nl!humbolt.nl.linux.org!news.nl.linux.org!transit.news.xs4all.nl!not-for-mail

References: <406d7eb8$0$1962$ba620e4c@news.skynet.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII
X-Google-Thread: 107324,bb2ad80a5b4cc582
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,bb2ad80a5b4cc582
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2004-04-02 10:02:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!news2.telebyte.nl!humbolt.nl.linux.org!news.nl.linux.org!transit.news.xs4all.nl!not-for-mail
Message-ID: <c4kgn6.1mo.1@news.isolution.nl>
Reply-To: "Dr.Ruud" <(rvtol+news(AT)hacktic.nl) Administrator@[127.0.0.1]>
From: "Dr.Ruud" <'t.leven.is.fijn@life.i$.great>
Newsgroups: nl.comp.programmeren,be.comp.programming
References: <406d7eb8$0$1962$ba620e4c@news.skynet.be>
Subject: Re: query
Date: Fri, 2 Apr 2004 19:54:17 +0200
Organization: Chaos rules.
X-Newsreader: WMDIYB
Approved: yesterday
X-Face: &CQ$FIr!=+=w,8`0Q^Ug"1>F[(/op8->E;NQet`5fe$;=e*!Z5&REvp<~Tj|"Y[|8OcJ{w#z&mB7B:I)XO*%_|\]|YW$C>>$Q[9-#K~c$tQ^Mf0,wMo?h\C)TE>f
Lines: 37
NNTP-Posting-Date: 02 Apr 2004 20:02:23 CEST
NNTP-Posting-Host: 194.109.164.102
X-Trace: 1080928943 news.xs4all.nl 64453 [::ffff:194.109.164.102]:33831
X-Complaints-To: abuse@xs4all.nl

Reply to Parent Message