参数:
sqlStatement varchar(250)
BEGIN
DECLARE done INT DEFAULT 0; #游标的标志位
DECLARE dbName varchar(250);
DECLARE cmd varchar(250);
DECLARE tb_name CURSOR FOR SELECT `SCHEMA_NAME` FROM `information_schema`.`SCHEMATA` ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
OPEN tb_name;
REPEAT
FETCH tb_name INTO dbName;
IF NOT done THEN
set cmd=concat(left(sqlStatement,INSTR(sqlStatement,'tc_')-1),dbName,".",substring(sqlStatement,INSTR(sqlStatement,'tc_')));
SET @E=cmd;
PREPARE stmt FROM @E;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END IF;
UNTIL done END REPEAT;
CLOSE tb_name;
END