update assignments and grades in moodle

gistfile1.sql

--update grades for all assignments for all courses in a given category
update mdl_assignment --update assignment object (front end)
set grade = 100
where course in 
(
'34','32','66','65','23','67' --list of courses
);

update mdl_grade_items --update gradebook (back end)
set grademax=100
where itemmodule='assignment' AND
courseid IN
(
'34','32','66','65','23','67'
);