) 908-4185 Fax
http://www.meitech.com/
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 26, 2005 12:08 AM
To: Frederic Wenzel
Cc: Gustafson, Tim; mysql@lists.mysql.com
Subject: Re: Problems with "select distinct"
Frederic Wenzel wrote
Frederic Wenzel wrote:
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last operati
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
> I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
> reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last operation, after any sele
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible. Try:
SELECT Documents.ID, Name
FROM Documents, DocumentFiles, DownloadLog
WHERE Documents.ID = DocumentFiles.Document
AND DocumentFiles.ID = DownloadLog.DocumentFile
GROUP B
Hi.
You forgot "" around temp example:
mysql>select datetime,temperatura from temperatura where
datetime="2002-02-08 09:30:00" and temperatura="15.8";
Regards
/PM\
Miguel Figueiredo wrote:
>
> Hello all,
>
> I have a (probably dumb) question.
> My table "temperatura" has two fields described b
> I have a (probably dumb) question.
> My table "temperatura" has two fields described bellow.
>
>
>
> When I try to select rows with floats, the result is an empty set.
This is not a MySQL problem, nor a database one, but a general computer
science one. It is
almost never save to compare two
MySQL manual A.5.7 Problems with floating point comparison
=dn
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 08 February 2002 15:24
Subject: Re: Problems with select
> 15.8 has no
15.8 has no exact binary representation, so a test for equality will fail.
Do not use floating point if you want to test for equality. Try DECIMAL
Miguel Figueiredo wrote:
>Hello all,
>
>I have a (probably dumb) question.
>My table "temperatura" has two fields described bellow.
>
>mysql> descr
MySQL manual A.5.7 Problems with floating point comparison
=dn
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 08 February 2002 15:24
Subject: Re: Problems with select
> 15.8 has no
15.8 has no exact binary representation, so a test for equality will fail.
Do not use floating point if you want to test for equality. Try DECIMAL
Miguel Figueiredo wrote:
>Hello all,
>
>I have a (probably dumb) question.
>My table "temperatura" has two fields described bellow.
>
>mysql> descr
> I have a (probably dumb) question.
> My table "temperatura" has two fields described bellow.
>
>
>
> When I try to select rows with floats, the result is an empty set.
This is not a MySQL problem, nor a database one, but a general computer
science one. It is
almost never save to compare two
Hi.
You forgot "" around temp example:
mysql>select datetime,temperatura from temperatura where
datetime="2002-02-08 09:30:00" and temperatura="15.8";
Regards
/PM\
Miguel Figueiredo wrote:
>
> Hello all,
>
> I have a (probably dumb) question.
> My table "temperatura" has two fields described b
12 matches
Mail list logo
