1.写一个存储过程,查指定数据库中所有的表名:
CREATE PROCEDURE init_replace(in orig_str varchar(100),in new_str varchar(100...do_replace(orig_str,new_str,db_name,t_name);
FETCH cur INTO t_name;
END WHILE;
END;
2.然后1中调用2中的方法,在查询表中所有的字段...CONTINUE HANDLER FOR NOT FOUND SET done = 1;
OPEN cur;
FETCH cur INTO cul_name;
WHILE (done1) 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;
3.调用1的方法: