---

Hvad er syntaxen for at få antal rows hvor, f.eks., "done" er lig 0?

Det er det tredje begynder spørgsmål jeg stiller her om MySQL. Er der
nogen der har et link til en god tutorial?
--
Nis Sarup http://www.nis.sarup.dk/

"Time is fun when you're having flies" -- Kermit the Frog

---

On Tue, 10 Feb 2004 21:04:56 +0100, Nis sarup
<myfirstname@mylastname.dk> wrote:

>Hvad er syntaxen for at få antal rows hvor, f.eks., "done" er lig 0?

SELECT COUNT(*) FROM tabel WHERE done = 0;

--
- Peter Brodersen

Ugens sprogtip: saltomortale (og ikke saltomotale)

---

Nis sarup wrote:
> Hvad er syntaxen for at få antal rows hvor, f.eks., "done" er lig 0?
>
> Det er det tredje begynder spørgsmål jeg stiller her om MySQL. Er der
> nogen der har et link til en god tutorial?

http://www.geocities.com/SiliconValley/Vista/2207/sql1.html

--
Kristian Damm Jensen damm (at) ofir (dot) dk
Universities are truly storehouses of knowledge: Students arrive from
school confident that they know very nearly everything, and they leave
years later certain that they know practically nothing. Where did the
knowledge go in the meantime? Into the university, of course, where it
is carefully dried and stored. -- Terry Prachett, Ian Steward & Jack
Cohen