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