We are trying to use Tim Hunt's Embed questions filter. Questions can only be embedded if they have an idnumber set, and where the category the question is in has an idnumber. Our question bank has a huge collection of questions without idnumber.
we are looking for some sql query to have auto-increment unique idnumber or same as id.
UPDATE `mdl_question` SET `idnumber` = '3403' WHERE `mdl_question`.`id` = 3403;
May I ask for any query like this to work on 100,000 questions altogether.
(Moodle 3.10; PhpMyAdmin 4.9.7; PHP 7.3.28)