Tuesday, April 21, 2009

MYSql 5 GROUP BY query not support Field Name "div"

in MySql 5 query...
SELECT std,div,rollno,marks FROM result_data GROUP BY std,div
gives Error...
Error is due to field name div
Solution: Change Field Name div -> divi or other.

It works fine with MySql 4.

No comments: