title: Syntax error in MySQL WITH ROLLUP query in MySQL Workbench?
body: <p>Any idea why the following query syntax is wrong:</p>
  
  <pre><code>SELECT year, sum(profit)
  FROM BASEDATA b 
  group by year WITH rollup
  </code></pre>
  
  <p>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.....</p>
  
  <p>MYSQL Version 5.0.77-community-log</p>