Any idea why the following query syntax is wrong:
SELECT year, sum(profit)
FROM BASEDATA b
group by year WITH rollup
Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near.....
MYSQL Version 5.0.77-community-log