CREATE DEFINER= root @'localhost PROCEDURE sp_subject_insert ()
BEGIN
DECLARE i INT default 1;
DECLARE count INT default 1;
DECLARE t_id INT default 1;
SELECT Count (id) INTO i FROM subjects;
SET count = i + 100;
WHILE i ‹ count DO
SELECT id INTO t_id FROM teachers ORDER BY RAND() LIMIT 1;
INSERT INTO subjects(sub_name, hours, teacher_id)
VALUES (
add_name_subject(),
FLOOR (RAND () * 100), t_id
) ;
SET i = i + 1;
END WHILE;
END