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
> visits
 group by pet' at line 1

Nuke the space after 'sum' and before (id).

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to