[size=medium][color=darkred][b]1.建表出现异常,需要删除表,创建删除表存储过程[/b][/color][/size]
[size=medium][color=darkred][b]2.执行删除表存储过程[/b][/color][/size]
DELIMITER $$
CREATE
PROCEDURE `score`.`dropp`()
BEGIN
DECLARE i INT;
DECLARE table_name VARCHAR(20);
DECLARE table_pre VARCHAR(20);
DECLARE sql_text VARCHAR(200);
SET i=1;
SET table_name='';
SET table_pre='score_stream_';
SET sql_text='';
WHILE i<16 DO
IF i<10 THEN SET table_name=CONCAT(table_pre,'0',i);
ELSE SET table_name=CONCAT(table_pre,i);
END IF;
SET sql_text=CONCAT('DROP TABLE ', table_name);
SELECT sql_text;
SET @sql_text=sql_text;
PREPARE stmt FROM @sql_text;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET i=i+1;
END WHILE;
END$$
DELIMITER ;
[size=medium][color=darkred][b]2.执行删除表存储过程[/b][/color][/size]
call dropp();