there was a small error in the sql in WHERE `name`='numsections'
the correct one as follows:
to update the number of course sections for all courses to a specific value (15 in my case):
UPDATE `mdl_course_format_options` SET `value`=15 WHERE `name`='numsections' AND `courseid`<>1 and `format`='weeks'