Not a member of GistPad yet?
Sign Up,
it unlocks many cool features!
- 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
RAW Paste Data
Copied
