Is there any reason that you need to "sum" the id? I'm assuming that
you're trying to "count". Ya?
-Original Message-
From: Noamn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:22 PM
To: [EMAIL PROTECTED]
Subject: 'Sum' syntax
Noamn <[EMAIL PROTECTED]> wrote:
> I'm using v3.23.51 on Linux.
>
> Can anyone explain why a simple 'sum' select won't work?? Here is the
> example:
>
> mysql> select sum (id), pet from visits group by pet;
> ERROR 1064: You have an error in your SQL syntax near '(id), pet from visits
> group by
On Tuesday 16 December 2003 09:22, Noamn wrote:
> I'm using v3.23.51 on Linux.
>
> Can anyone explain why a simple 'sum' select won't work?? Here is the
> example:
>
> mysql> select sum (id), pet from visits group by pet;
> ERROR 1064: You have an error in your SQL syntax near '(id), pet from
> v
I'm using v3.23.51 on Linux.
Can anyone explain why a simple 'sum' select won't work?? Here is the
example:
mysql> select sum (id), pet from visits group by pet;
ERROR 1064: You have an error in your SQL syntax near '(id), pet from visits
group by pet' at line 1
--
MySQL General Mailing List
F
