Rollup for multiple fields in MySQL
I am able to run rollup for single field but unable to do for multiple fields in MySQL.
Any idea how can we do rollup on multiple fields
Try asking on http://dba.stackexchange.com if this is a database administration question, or on http://stackoverflow.com if it is a programming question.
You need to read "How to ask questions the smart way".
A quick google suggests "rollup" is used with grouped-queries, so it is a modifier to an SQL select operation, not a db-command as such.
"select country, state, city, SUM(sales), SUM(profit) from foo group by country, state, city with rollup;"
for a table with country, state, city, sales, profit as columns