Arghh... shame on me forever.
I'm speachless.
Mikhail Entaltsev wrote:
Missed FROM clause... ;)
Best regards,
Mikhail.
- Original Message -
From: "Mário Gamito" <[EMAIL PROTECTED]>
To:
Sent: Friday, March 11, 2005 1:49 PM
Subject: Problem in a very simple SQL stateme
[snip]
select count(email) where email='[EMAIL PROTECTED]';
[/snip]
select count(email) FROM TABLE where email='[EMAIL PROTECTED]';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Missed FROM clause... ;)
Best regards,
Mikhail.
- Original Message -
From: "Mário Gamito" <[EMAIL PROTECTED]>
To:
Sent: Friday, March 11, 2005 1:49 PM
Subject: Problem in a very simple SQL statement
> Hi,
>
> Why do i get an error on this statement:
>
Hi,
Why do i get an error on this statement:
select count(email) where email='[EMAIL PROTECTED]';
The error is:
"ERROR 1064: You have an error in your SQL syntax near 'where
email='[EMAIL PROTECTED]'' at line 1"
The statement seems pretty clear to me, but obviously something's wrong.
What can it
