mysql寫存儲(chǔ)過程的時(shí)候，當(dāng)游標(biāo)遍歷結(jié)束后怎么讓他跳出？DECLARE CONTINUE HANDLER FOR SQLSTATE "02000" SET DONE = 1 這種語句是異常捕獲內(nèi)容

mysql寫存儲(chǔ)過程的時(shí)候，當(dāng)游標(biāo)遍歷結(jié)束后怎么讓他跳出？

DECLARE CONTINUE HANDLER FOR SQLSTATE "02000" SET DONE = 1 這種語句是異常捕獲內(nèi)容，在mysql中都是使用HANDLER 來捕獲異常的。 建議你看下：MySQL存儲(chǔ)過程詳解 MySQL游標(biāo)循環(huán)遍歷的使用

存儲(chǔ)過程中游標(biāo)是怎么用的？

sql1=select * from (select *， row_number() over(order by username ) as rowNumber from users where regfrom="&admin&") as t where t.rowNumber > 0 and t.rowNumber <= 0 30 order by username怎么會(huì)有27 條記錄呢，除非你的表 一共就27條記錄吧。用游標(biāo)或臨時(shí)表--游標(biāo)declare youbiao1 for 查詢1open youbiao1fetch next from youbiao1 into 變量while @@FETCH_STATUS = 0begin 里面一次套用end--臨時(shí)表declare @ID intset @ID = 1while Exists(select * from 表)begin --處理 -- set @ID = @ID 1end