MySQL 使用 LOOP 的 ITERATE 語句示例

mysql>  mysql>  mysql>?DELIMITER?//  mysql>?CREATE?PROCEDURE?myProc?(IN?in_count?INT)  ????->?BEGIN  ????->?????DECLARE?count?INT?default?0;  ????->  ????->?????increment:?LOOP  ????->?????SET?count?=?count?+?1;  ????->?????IF?count??????IF?count?>?in_count?THEN?LEAVE?increment;  ????->?????END?IF;  ????->?????END?LOOP?increment;  ????->  ????->?????SELECT?count;  ????->?END  ????->?//  Query?OK,?0?rows?affected?(0.00?sec)  ?  mysql>?DELIMITER?;  mysql>  mysql>?call?myProc(5);  +-------+  |?count?|  +-------+  |????20?|  +-------+  1?row?in?set?(0.00?sec)  ?  Query?OK,?0?rows?affected?(0.00?sec)  ?  mysql>  mysql>?drop?procedure?myProc;  Query?OK,?0?rows?affected?(0.00?sec)  ?  mysql>