全部博文
-
编辑 删除
mysql存储过程中的游标循环和PHP获取结果集
BEGIN DECLARE var1 INT DEFAULT 0; DECLARE done INT DEFAULT 0; DECLARE cardsortID INT DEFAULT 0; DECLARE alart INT DEFAULT 0; DECLARE cur CURSOR FOR (SELECT sortID, alarmCount FROM monitoring WHERE hide=1 ORDER BY sortID ASC); open cur; FETCH cur INTO cardsortID, alart; WHILE done <> 1 DO SELECT cardName,cardsortID,co
