) 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
Hello
I am trying to run the following query on my server:
select Documents.ID,
Name
from Documents,
DocumentFiles,
DownloadLog
where Documents.ID = DocumentFiles.Document and
DocumentFiles.ID = DownloadLog.DocumentFile
order by DownloadLog.AddedOn desc
limit 5
I
I am running Apache/PHP 4/MySQL 3.23 on a Win98.
The following statement will not execute in PHP MyAdmin or through the
browser. However it does run under my SQL tool SQLion:
SELECT contacts.contactId,contacts.firstName,orders.orderId
FROM contacts INNER JOIN orders
ON contacts.contactId = order
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
Hello all,
I have a (probably dumb) question.
My table "temperatura" has two fields described bellow.
mysql> describe temperatura;
+-+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+-+--+--+-+
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
Hello all,
I have a (probably dumb) question.
My table "temperatura" has two fields described bellow.
mysql> describe temperatura;
+-+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+-+--+--+-+
orm to the standard ?
>
> Regards
> Thomas
>
>
> -Original Message-
> From: Hannes Niedner [mailto:[EMAIL PROTECTED]]
> Sent: 26. juni 2001 17:42
> To: [EMAIL PROTECTED]
> Subject: Re: HELP NEEDED: Problems with SELECT in combination with
> HAVING
>
Niedner [mailto:[EMAIL PROTECTED]]
Sent: 26. juni 2001 17:42
To: [EMAIL PROTECTED]
Subject: Re: HELP NEEDED: Problems with SELECT in combination with
HAVING
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime >= '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY
[mailto:[EMAIL PROTECTED]]
Sent: 26. juni 2001 17:42
To: [EMAIL PROTECTED]
Subject: Re: HELP NEEDED: Problems with SELECT in combination with
HAVING
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime >= '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY rob
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime >= '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit'
for all records specified in the where clause. And have a look in the manual
for
Hello there - I have this weird problem using MySql (version 3.23.39).
It seems that MySql interpretation of a SELECT statment using HAVING is
completely random.
I have a table called RobotRun which stores information about when a robot
has been running (start, stop and the id of the robot). Thi
21 matches
Mail list logo
