mysql 替换某个数据库里所有表所有字段的文字，存储过程

CREATE PROCEDURE do_replace(in orig_str varchar(100),in new_str varchar(100),in db_name varchar(100),in t_name varchar(100))
BEGIN
	DECLARE cul_name VARCHAR(50);
	DECLARE done int default 0;
	DECLARE cur CURSOR FOR SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA=db_name and TABLE_NAME=t_name;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
	OPEN cur;
	FETCH cur INTO cul_name;
	WHILE (done<>1) do
		set @update_sql=CONCAT("Update ",t_name," SET ",cul_name,"=replace(",cul_name,",'",orig_str,"','",new_str,"');");
		prepare stmt from @update_sql; 
		execute stmt;
		FETCH cur INTO cul_name;
	END WHILE;
	CLOSE cur;
END;

CREATE PROCEDURE init_replace(in orig_str varchar(100),in new_str varchar(100),in db_name varchar(100))
BEGIN
	DECLARE t_name VARCHAR(50);
	DECLARE done int default 0;
	DECLARE cur CURSOR FOR SELECT DISTINCT table_name as name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=db_name;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
	OPEN cur;
	FETCH cur INTO t_name;
	WHILE (done<>1) do
		call do_replace(orig_str,new_str,db_name,t_name);
		FETCH cur INTO t_name;
	END WHILE;
END;

call init_replace('http://image.aaa.com','http://t_image.aaa.com','WEBSITE');

call init_replace('原字符','新字符','数据库名');
将数据库里的所有的表的所有字段的“原字符” 替换为“新字符”