I think your confusion stems from the fact that
a AND b NOT c
is not a valid boolean expression. You probably
mean to say
a AND b AND NOT c
Lezz Giles
- Original Message -
From: "Libor Matyáš" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday
r hand, I think if you have a recent MySQL
(I don't, so I can't test this) you can say...
SELECT COUNT(DISTINCT name) FROM table...
HTH
Lezz Giles
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
To: "Lezz Giles" <[EMAIL PROTECTED]>
I haven't tested this; I'm not an SQL guru. I just
like a challenge :-)
SELECT COUNT(*) FROM table WHERE team = "support" GROUP BY name;
Lezz Giles
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
t PHP only supports
a limited number of database engines.
Lezz Giles
- Original Message -
From: "Nilesh Parmar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 10, 2001 8:13 PM
Subject: MySQL and Perl
> Hi
> I just wanted to know how well
is a text file, use an editor
to look at the contents of the file. You'll almost certainly
find that it contains SQL commands instead of being
the executable image that it should be.
HTH
Lezz Giles
- Original Message -
From: "christopher sagayam" <[EMAIL PROTECTED]>
read up as much as you can on EXPLAIN, and you should
use EXPLAIN on any SELECT that might end up being really big.
HTH,
Lezz Giles
"Frederick L. Steinkopf" wrote:
> I can't comment on whatever Borland client you're talking about but MySQL
> supports multiple table joi
ybody shed any light on what I'm doing wrong?
Thanks,
Lezz Giles
--
Leslie Giles Software Release Manager Avici Systems Inc
[EMAIL PROTECTED] Phone: 978.964.2030 Fax: 978.964.2100
