Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Как убрать ошибку #1064?
- Вот сам запрос:
- DELIMITER //
- CREATE PROCEDURE `SelectPerson` (OUT `cha` TEXT)
- LANGUAGE SQL
- DETERMINISTIC
- SQL SECURITY DEFINER
- COMMENT 'Some proc!'
- BEGIN
- DECLARE minimal INT;
- SET minimal = 100;
- DECLARE ids Int;
- SET ids = 1;
- DECLARE r,cr Int;
- DECLARE reit CURSOR FOR SELECT reiting FROM stud;
- DECLARE CONTINUE HANDLER FOR NOT FOUND SET ids = 0;
- OPEN reit;
- WHILE ids = 1 DO
- FETCH reit INTO r;
- IF ids = 1
- IF r < minimal THEN
- Set minimal = r;
- SET cr = SELECT ids FROM stud;
- END IF;
- END IF;
- END WHILE;
- CLOSE reit;
- SET cha = = SELECT cr FROM stud;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
