mysql 错删字段_mysql删除字段的方法总结

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`p_drop_uuid_uuname`$$

CREATE DEFINER=`root`@`%` PROCEDURE `p_drop_uu`()

BEGIN

declare _db_name char(30);

declare _tb_name char(30);

declare _col_name char(30);

declare no_more_row tinyint(1);

declare cur_uuid cursor for

select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME

from information_schema.COLUMNS

where COLUMN_NAME='uu';

declare continue handler for not found set no_more_row=1;

set no_more_row=0; -- 判断是否结束的标志位

open cur_uuid;

repeat

fetch cur_uuid into _db_name,_tb_name,_col_name;-- 取记录

-- select _db_name,_tb_name,_col_name;

set @_dt = concat("alter table ", _db_name,".", _tb_name, " drop column uu");

-- 在存储过程中，想把一个变量当作SQL执行，只有用prepare;

prepare s1 from @_dt;

execute s1;

deallocate prepare s1;

until no_more_row

end repeat;

close cur_uuid;

END$$