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]