CREATE DEFINER=`3eva`@`%` EVENT `ponedor_notas`
ON SCHEDULE
EVERY 1 MINUTE STARTS '2025-04-07 18:08:53'
ON COMPLETION NOT PRESERVE
ENABLE
COMMENT ''
DO BEGIN
DECLARE alu INT;
-- DECLARE idalu INT;
DECLARE modu INT;
DECLARE bingo INT;
DECLARE consulta text;
SET alu := (SELECT COUNT(*) FROM alumnos);
-- SELECT COUNT(*) INTO alu FROM alumnos;
SET bingo := 1+truncate(RAND()*alu,0);
SET @consulta := CONCAT("SELECT @idalu:=id FROM alumnos ",
"LIMIT 1 OFFSET ",bingo);
PREPARE stmt FROM @consulta;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
INSERT ignore INTO notas VALUES (@idalu,1,0);
END
CREATE DEFINER=`3eva`@`%` EVENT `PONERDOR_NOTA2`
ON SCHEDULE
EVERY 1 MINUTE STARTS '2025-04-08 13:49:40' ENDS '2025-04-20 13:58:47'
ON COMPLETION NOT PRESERVE
ENABLE
COMMENT ''
DO BEGIN
DECLARE alu INT;
-- DECLARE idalu INT;
DECLARE modu INT;
DECLARE consulta text;
SELECT @idalu:=id FROM alumnos
ORDER BY RAND() LIMIT 1;
INSERT ignore INTO notas VALUES (@idalu,2,10);
END