[New post] MySQL New Features #5

Author-Check- Article-or-Video posted: " MySQL New Features Cursor Example:CREATE PROCEDURE p25 (OUT return_val INT)BEGINDECLARE a,b INT;DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;DECLARE CONTINUE HANDLER FOR NOT FOUND < --SET b = 1; <--OPEN cur_1;REPEATFETCH cur_1 INTO a;UNTIL b = 1END " New post on উন্মুক্ত শিক্ষার আসর - Open Education MySQL New Features #5 by Author-Check- Article-or-Video MySQL New Features Cursor Example: CREATE PROCEDURE p25 (OUT return_val INT)BEGINDECLARE a,b INT;DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;DECLARE CONTINUE HANDLER FOR NOT FOUND < --SET b = 1; <--OPEN cur_1;REPEATFETCH cur_1 INTO a;UNTIL b = 1END REPEAT;CLOSE cur_1;SET return_val = a;END;// Stored procedure in MySQL http://www.mysqltutorial.org/stored-procedures-loop.aspx Loop in stored procedure DELIMITER $$ DROP […] Read more of this post Author-Check- Article-or-Video | August 12, 2021 at 12:03 am | Categories: FromSitesTree.com | URL: https://wp.me/p3jLTJ-hYD Comment    See all comments Unsubscribe to no longer receive posts from উন্মুক্ত শিক্ষার আসর - Open Education. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: http://bangla.salearningschool.com/recent-posts/mysql-new-features-5/