MYSQL 批量给数据库数据表增加字段

DROP PROCEDURE IF EXISTS testEndHandle;
DELIMITER $$
 CREATE PROCEDURE testEndHandle()
BEGIN
  DECLARE s_tablename VARCHAR(100);
 DECLARE cur_table_structure CURSOR
 FOR 
 SELECT table_name 
 FROM INFORMATION_SCHEMA.TABLES 
 WHERE table_schema = 'e-learning' AND table_name LIKE "y_%";
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET s_tablename = NULL;
 OPEN cur_table_structure;
 FETCH cur_table_structure INTO s_tablename;
 label:WHILE ( s_tablename IS NOT NULL) DO
--   SET @MyQuery=CONCAT("alter table `",s_tablename,"` add COLUMN `create_time_stamp` int(10) COMMENT '添加时间_时间戳'");
--     SET @MyQuery=CONCAT("alter table `",s_tablename,"` add COLUMN `update_time_stamp` int(10) COMMENT '修改时间_时间戳'");

--   SET @MyQuery=CONCAT("alter table `",s_tablename,"` modify COLUMN `create_time_stamp` datetime(0) COMMENT '添加时间_时间戳'");
-- SET @MyQuery=CONCAT("alter table `",s_tablename,"` modify COLUMN `update_time_stamp` datetime(0) COMMENT '修改时间_时间戳'"); 
 IF (s_tablename != 'y_admin_user_action' && s_tablename != 'y_clue_record' && s_tablename != 'y_role_menu' && s_tablename != 'y_user_role') THEN
 SET @MyQuery=CONCAT("alter table `",s_tablename,"` modify COLUMN `create_time` varchar(255) DEFAULT '' COMMENT '添加时间'");
--     SET @MyQuery=CONCAT("alter table `",s_tablename,"` modify COLUMN `update_time` varchar(255) COMMENT '修改时间'");

  PREPARE msql FROM @MyQuery;
  EXECUTE msql ;
    
 end IF;
  FETCH cur_table_structure INTO s_tablename;
  END WHILE label;
 CLOSE cur_table_structure;

END;

CALL testEndHandle();