DELIMITER $$ USE `blog`$$ DROP PROCEDURE IF EXISTS `alert_visitlog`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `alert_visitlog`() BEGIN DECLARE i INT; SET i = 0; WHILE i < 1000 DO SET @tab_name = CONCAT('visit_log_',i); SET @tempsql = CONCAT('ALTER TABLE ',@tab_name,' CHANGE url url VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;'); PREPARE mainStmt FROM @tempsql; EXECUTE mainStmt; SET i = i+1; END WHILE; END$$ DELIMITER ;
