《Mysql必讀mysql動態游標與mysql存儲過程游標(示例)》要點：
本文介紹了Mysql必讀mysql動態游標與mysql存儲過程游標(示例)，希望對您有用。如果有疑問，可以聯系我們。
-- 樹立測試表和數據
create table webuser (username varchar(10));
insert into webuser values ('a1'),('a2'),('a3'),('b1'),('b2'),('b3');
commit;MYSQL學習
-- 建立存儲進程
drop procedure if exists dynamic_cursor;
delimiter // www.jbxue.com
CREATE PROCEDURE dynamic_cursor (IN p_name varchar(10))
BEGIN
??? DECLARE done INT DEFAULT 0;
??? DECLARE v_username varchar(10);
??? DECLARE cur CURSOR for( SELECT username from webuser_view);
??? DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;MYSQL學習
??? DROP VIEW IF EXISTS webuser_view;MYSQL進修
??? SET @sqlstr = "CREATE VIEW webuser_view as ";
??? SET @sqlstr = CONCAT(@sqlstr , "SELECT username FROM webuser WHERE username like '", p_name,"%'");MYSQL進修
??? PREPARE stmt FROM @sqlstr;
??? EXECUTE stmt;
??? DEALLOCATE PREPARE stmt;MYSQL進修
??? OPEN cur;
??? f_loop:LOOP
??? FETCH cur INTO v_username;
??? IF done THEN
??????? LEAVE f_loop;?
??? END IF;
??? SELECT v_username;???
??? END LOOP f_loop;
??? CLOSE cur;
END;
//
delimiter ;MYSQL進修
-- 測試
call dynamic_cursor('a');MYSQL進修
維易PHP培訓學院每天發布《Mysql必讀mysql動態游標與mysql存儲過程游標(示例)》等實戰技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培養人才。
