Re: [mySQL] Select Count(distinct xxx) from yyy ?

Article View: dk.edb.database

Article #15165

#15165

From: Martin H�jriis Kristensen
Date: Fri, 29 Jun 2001 11:27

14 lines
1638 bytes

"Henrik Larsson" <henrik_l@mailme.dk> skrev i en meddelelse
news:9hh9ca$ps1$1@sunsite.dk...
> > SELECT COUNT(distinct xxx) FROM yyy;

Desv�rre:
MySQL returnerede: You have an error in your SQL syntax near 'distinct xxx)
FROM yyy' at line 1

--
Med Venlig Hilsen

Martin H�jriis Kristensen
Svar bedes baseret p� RFC1855
Jeg repr�senterer med denne udtalelse mig selv og ikke TDC Internet

Technical Details

Message-ID: <9hholp$o12$1@news.inet.tele.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!uio.no!newsfeed1.uni2.dk!news.tele.dk!TDC-Europe.POSTED!fw1.inet.tele.dk!not-for-mail

References:

<9hfudm$2t3$1@news.inet.tele.dk> <9hg2i5$11a$1@sunsite.dk> <9hg3uh$3n6$1@news.inet.tele.dk> <9hh8vj$o04$1@sunsite.dk> <9hh9ca$ps1$1@sunsite.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,835ca28d5860df6
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-29 04:26:53 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!uio.no!newsfeed1.uni2.dk!news.tele.dk!TDC-Europe.POSTED!fw1.inet.tele.dk!not-for-mail
From: "Martin H�jriis Kristensen" <hoejriis@SLETDETTEiname.com>
Newsgroups: dk.edb.database
Subject: Re: [mySQL] Select Count(distinct xxx) from yyy ?
Date: Fri, 29 Jun 2001 13:27:19 +0200
Organization: Posted through some European Outpost of TDC Internet A/S
Lines: 15
Message-ID: <9hholp$o12$1@news.inet.tele.dk>
References: <9hfudm$2t3$1@news.inet.tele.dk> <9hg2i5$11a$1@sunsite.dk> <9hg3uh$3n6$1@news.inet.tele.dk> <9hh8vj$o04$1@sunsite.dk> <9hh9ca$ps1$1@sunsite.dk>
NNTP-Posting-Host: fw1.inet.tele.dk
Mime-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: news.inet.tele.dk 993814009 24610 193.163.158.4
X-Complaints-To: the appropriate department of the poster's provider
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

Reply to Parent Message