mysql批量修改某库中某字段的值

DELIMITER $$ ---mysql中必须要加这玩意儿
drop PROCEDURE if EXISTS NewProc;
CREATE DEFINER = CURRENT_USER PROCEDURE `NewProc`()
BEGIN
            -----定义变变量
		    declare tableName varchar(200) default '';
		    declare columnName varchar(200) default '';
			declare done int default 0;
            ----创建一个游标
				declare cur cursor for  SELECT table_name as tableName,COLUMN_NAME as columnName FROM INFORMATION_SCHEMA. COLUMNS WHERE TABLE_SCHEMA = 'ems_db' and data_type = 'varchar';
				declare continue HANDLER for not found set done = 1;
				open cur;
				
											posLoop:LOOP
										
											IF done=1 THEN  
												LEAVE posLoop;
											END IF; 
									
										FETCH  cur into tableName,columnName;
										
										set @tableNames = CONCAT(tableName);
										set @columnNames = CONCAT(columnName);
			                        ----定义一个变量方便下面用prepare
										set @sqlStr = CONCAT("update ",@tableNames," set ",@columnNames," ='铭德.观澜府' ",' where ',@columnNames," = '德能.渝贵佳苑'");
									 
										
										prepare stmt from @sqlStr;
						           ---执行SQL
										execute stmt;
								
										deallocate prepare stmt;

										END LOOP posLoop;

			 CLOSE cur;

END $$

DELIMITER ;