MySql中循环的使用

一、while循环 语法：WHILE [条件] DO [逻辑] END WHILE;

delimiter $$
DROP FUNCTION IF EXISTS `fn_findCharCount` $$
CREATE FUNCTION fn_findCharCount
(in_string VARCHAR(500),
in_find_str VARCHAR(50)
)
RETURNS INT
BEGIN

    DECLARE tcount INT DEFAULT 0;
    DECLARE new_str VARCHAR(500);
    DECLARE scount INT;

    SET new_str = in_string;

    SELECT INSTR(new_str,in_find_str) INTO scount;

WHILE scount>0 DO
SET tcount = tcount+