mysql 存储过程，while循环

    --lyp 20160824 begin
    DROP PROCEDURE if EXISTS pp;
    delimiter //
    CREATE PROCEDURE pp ()
    BEGIN
    DECLARE n INT ;
    DECLARE i INT ;
    DECLARE t VARCHAR(255);
    DECLARE s VARCHAR(255);
    SET n = 200 ;
    SET i =1 ;
    WHILE i < n DO
        BEGIN
            IF ((select count(*) from information_schema.tables where table_name = CONCAT("ms_mime_consumeloan_static_",CAST(i as char))))
            THEN
                SET @s=CONCAT("alter table ","ms_mime_consumeloan_static_",CAST(i as char)," add column contract_money double(64,2) COMMENT '合同金额' AFTER loan_AMT");
                PREPARE stmt FROM @s ;
                EXECUTE stmt ;
                DEALLOCATE PREPARE stmt ;
            END IF;
        END;
        SET i = i + 1 ;
    END WHILE ;
    END ;//
    
    CALL pp();
    --lyp 20160824 end